Questions tagged [business-data-catalog]

The Business Data Catalog (BDC) is a feature introduced for SharePoint 2007 that provides an easy way to integrate business data from back-end server applications, such as SAP or Siebel, within Office SharePoint Server 2007 without writing any code.

Filter by
Sorted by
Tagged with
1 vote
0 answers
31 views

POSH created Items and BusinessData fields not displaying additional ECT fields

I have a POSH script that create items on a list that pulls additional field data from a BCS source. The function is as follows. Function Add-SPItems($TargetingDetails) { $site = New-Object ...
Trey Nuckolls's user avatar
0 votes
1 answer
348 views

External list from SQL database with more than 2000 rows

I created external list in SP2013 which has more than 2000 rows but I still cannnot read it all, error is: Database Connector limited response. The response from the database contains more than 2000 ...
Zbyna's user avatar
  • 149
2 votes
1 answer
638 views

Failed to create list item for external list using REST API POST

I've AN OData API, which I'm consuming in SharePoint via BCS and External List. I already have the Get and Update functionality working using REST API to external list. But when I try to add an item ...
user5579208's user avatar
1 vote
1 answer
302 views

Sharepoint 2010 BDC not working

I want to create external content type, so in central admin I create a new Business Data Connectivity Service (BDC) and I start the service from system settings --> manage service on servers. but ...
BKChedlia's user avatar
  • 303
1 vote
0 answers
218 views

OOTB Shopping Cart for 2013, product catalog

I'm making a product catalog for industrial materials. This catalog will not be for commerce, I just want to allow my users to search and casually add items to a list. Can anyone guide me in the ...
Michael Ellis's user avatar
0 votes
1 answer
1k views

Is It possible to sync MySQL table to SharePoint list through SharePoint Business Connectivity Service?

I want know is it possible to connect MySQL table to SharePoint list ? This question is asked in an interview for me.
azharuddin's user avatar
0 votes
1 answer
114 views

How to make user edit data in business data list?

I set up a business data list to get data from SQL server through external content type. It works very well and users are able to see the data from SQL server on their SharePoint UI. But now I'm ...
SSilicon's user avatar
  • 155
2 votes
0 answers
104 views

How to create multiple operator options in one filter, and how to add "contain" filter in external content type?

I'm creating external content type from SQL server to business data list. I would like to create a read list operator based on search stored procedure. I noticed in creating filter table, there's no "...
SSilicon's user avatar
  • 155
0 votes
1 answer
66 views

How to add new service application with Central Adminstration

I want to excel document into my webpart in sharepoint 2013. First, I added a webpart in my page as follows. Then I clicked "Click here to open the tool pane." and I added workbook URL and OK. But I ...
zengel's user avatar
  • 539
1 vote
0 answers
583 views

The request was aborted: The connection was closed unexpectedly in BDC

I created a custom BCS connector to index external system results into SharePoint. Now I am getting the following error while crawling the content source: System.Net.WebException: The request ...
user30364's user avatar
0 votes
1 answer
259 views

How do I populate the VALUEs in one column with the FIELD NAMES of another list?

I'm trying to create a 'request update form' where the user selects an entry which is incorrect and then which field is incorrect and writes a comment and that form will get submitted via workflow to ...
Bec's user avatar
  • 13
1 vote
0 answers
88 views

ExecuteWcFOperation http://www.microsoft... slow performance

I am troubleshooting a performance issue and I see some log entries like: Leaving Monitored Scope (ExecuteWcfOperation:http://www.microsoft.com/Office/2009/BusinessDataCatalog/...
axawire's user avatar
  • 48
1 vote
0 answers
68 views

Error Connecting to Business Data Connectivity Metadata Store - SharePoint 2010 Foundation

Issue connecting to External Content Types in SharePoint Designer. After clicking on the ECT Site Objects on the Left side of the screen, it displays all the previously set up ECTs. When trying to ...
KeithRStolte's user avatar
1 vote
1 answer
751 views

Starting with Business Connectivity Services in SP2010 or SP2013

I've been looking for a good guide to using Business Connectivity Services for a while now and have not run into one that details how to implement and use this for a full solution. Most of them that ...
burgermenu's user avatar
3 votes
0 answers
74 views

Crawled Properties from Business Data not getting created

I have created a content source crawling exteranl data using business data connectivity service. I can sucessfully crawl the business data content source without any errors. In crawl logs also I didn'...
Roy Justin's user avatar
3 votes
1 answer
6k views

The load balancer is not provisioned - BDC Exception in SharePoint 2013

When I click on 'Business Data Connectivity Services' link on 'Manage Service Application' page of Central Administration, I get the following error : "The load balancer is not provisioned. Verify the ...
Diptarag's user avatar
  • 1,697
1 vote
2 answers
666 views

StreamAccessors >> Can SharePoint 2010 BCS return multiple attachments?

Can SharePoint 2010 BCS return multiple attachments? I have a database which stores multiple attachments per entity. Would like to have all of them accessible, but I've insufficient experience with ...
Neil Richards's user avatar
1 vote
1 answer
577 views

BDC external contet type SharePoint Designer

I have problem with Business Data Connectivity, when I try to create new external content type in SharePoint Designer - I "Add Connection" then I choose SQL Server I fill Database Server and Name and ...
Wilon's user avatar
  • 513
2 votes
2 answers
5k views

How to create an external List on SharePoint 2010 using MySQL table

I have a MYSQL database that contains customer related data from sugarcrm while a few order related data is stored in the MSSQL server. So far, I have been able to create an external list for the ...
ArkoD's user avatar
  • 5,304
0 votes
0 answers
198 views

Business Data Catalog: Application Definition File issue

I created my BDC application definition file with the help of Application Definition Designer. Before exporting the file, I executed the methods and they are all executing fine without issues. I then ...
Ashish's user avatar
  • 881
3 votes
2 answers
4k views

Sharepoint External Data field with multiple values

I need to create a list column which contains external data (from BDC). The field has to contain multiple values. But I haven't found a way how to make a external-data-field take multiple values. ...
MOI's user avatar
  • 1,031
1 vote
0 answers
787 views

SharePoint BDC Model NULL Structure

I crawl database with FAST Search Server for SharePoint 2010. When incremental crawl is running, it is getting the following error for some records. After the first error, SharePoint takes the same ...
Fırat Çelik's user avatar
0 votes
3 answers
1k views

SpecificFinder not called on Sharepoint 2010 BCS

I have an external content type for which I created a BDC model with a LobSystem of type dot.NET assembly. I have a SpecificFinder and a Finder method defined. I also have an external list created on ...
JohnDoDo's user avatar
  • 1,169
1 vote
4 answers
1k views

Issue with External Data Columns on Document Libraries with Content Types

I have site content type called ContractBase that has a bunch of fields that are used in contracts. I created some other site content types (ContractType1 and ContractType2) that inherit from ...
RussGove's user avatar
  • 1,254
0 votes
1 answer
668 views

Change Identifier for BDC field in use

UPDATE: After searching around, it seems what I am looking to change is the identifier for a given entity. Is this done simply by exporting the application definition, changing it and then importing ...
Christian P.'s user avatar
2 votes
1 answer
460 views

How can I let users enter credentials for a Secure Store Target Application?

I am trying to use Business Connectivity Services in SharePoint 2010 to interface with an Oracle database. I have created a .NET assembly connector in combination with some custom application pages ...
Chris Farmer's user avatar
1 vote
1 answer
196 views

What is the easiest way of setting (workflows, programmatically, etc) the value of columns from Business Data Catalogue for new docuemnts?

In Sharepoint 2007 I am trying to automatically set values read from business data for new documents added to the document list. Right now, when new file is uploaded, user: needs to go to the "Edit ...
zeroDivisible's user avatar
2 votes
0 answers
277 views

Business Data Connector List Column not working BDC XML Definition

I have a BDC connected to a SQL Table with 2500 Rows. I'm able to add a Business Data List WP to a page and point it to the BDC source and it looks fine except for limited number of Rows. However, if ...
Hell.Bent's user avatar
  • 1,299
14 votes
4 answers
13k views

How to automate entry of external column data in BCS?

I have a document library, Resumes, that has a large number of resumes in it. There is a regular column on that library, called EmployeeID, that is already populated. I have an external content type (...
lwbecker2's user avatar
  • 1,494
0 votes
1 answer
768 views

Add additional columns to see properties from an external data (BDC) field in code

So I've got a list with a BDC External Data field (Sharepoint 2010). This has been added via code and works well (although some sharepoint hacking was needed!) Anyway on the front end you go to list ...
Amjid Qureshi's user avatar
0 votes
1 answer
1k views

Getting an error while creating external content type based on WCF service

I created a WCF Service in Visual Studio and wanted to create an external content type based on it but I get an error message while creating the content type: "Error loading URL ... this normally ...
Bassel Alkhateeb's user avatar
4 votes
1 answer
768 views

How do I access an SQL image column using an External Content Type list?

I have a External Content Type (list) which pulls the data from an SQL Server. The image field in SQL can be stored in binary format or just the image path is stored (currently I am storing the path ...
Nikhil J's user avatar
  • 4,934
4 votes
3 answers
2k views

Validation for external lists / external content types

Where does one put validation for external content types? Let's say one field on my ECT represents an email address that must be unique in our system. Where would I put the validation that checks to ...
SPMeta's user avatar
  • 51
3 votes
1 answer
386 views

Anonymous BDC Authentication problem

We are using SP 2007 Enterprise and it's Business Data Catalogue to return data in web parts on our external web site to anonymous users (or am trying to in any case). I haven't found any concrete ...
user avatar
0 votes
1 answer
330 views

Create field of type Business data with the object model

How can I create a Business Data catalog field with the object model? So I want to create a field that utilities business data catalog and not add an item to an already existing list.
user avatar
1 vote
1 answer
372 views

User Profiles synching to BDC 1:1 option

What is the purpose of the 1:1 option within the Custom Import Connections when selecting the BDC? I initially thought that 1:1 was 1 record per user profile, but it is actually the set of profiles, ...
Mike Oryszak's user avatar
  • 11.3k
1 vote
2 answers
303 views

Updating connection for BDC to a different SQL Server

Is there a way other than exporting the BDC definition, changing the xml, and re-importing the definition to change the connection for the BDC application to a different server. We are setting up a ...
SitWalkStand's user avatar