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.

learn more… | top users | synonyms

0
votes
1answer
35 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 ...
0
votes
0answers
64 views

Removing a BDC Catalog using PowerShell

I use Sharepoint 2013 and Powershell. I use $metaStore = Get-SPBusinessDataCatalogMetadataObject -BdcObjectType "Catalog" -ServiceContext $siteUrl Import-SPBusinessDataCatalogModel -Path $filename ...
0
votes
0answers
25 views

Filter Business Data List Values from Custom List Values

I am designing a solution in SharePoint 2010. Is it possible to create filter criteria on Business Data List from a Custom List? I have been banging my head around how to achieve this for some ...
1
vote
0answers
67 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 ...
0
votes
0answers
26 views

Index RESTful API results from external system in to SharePoint?

How to index RESTful API results from external system in to SharePoint? Any working samples would be appreciated.
0
votes
1answer
89 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 ...
0
votes
0answers
33 views

Access QueryString Param using Business Data Item Builder - Param name differs

I have an ECT named "BCS Parts" which has 2 Operations: ReadItem & ReadList. Both have 2 columns: ITEM_NUMBER & ITEM_Desc. On a page I want to display an item number and description of the ...
1
vote
0answers
33 views

ExecuteWcFOperation http://www.microsoft… slow performance

I am troubleshooting a performance issue and I see some log entries like: Leaving Monitored Scope ...
1
vote
0answers
39 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 ...
0
votes
0answers
89 views

How to : Visual Studio 2010 create Sharepoint List and define data source?

I have this ugly requirement of creating a SharePoint list (could be a custom or an calendar) which displays the companies upcoming events, the problem is that x department updates an excel sheet ...
1
vote
1answer
150 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 ...
1
vote
0answers
46 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 ...
0
votes
1answer
2k 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 ...
1
vote
2answers
368 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 ...
0
votes
1answer
440 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 ...
2
votes
2answers
3k 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 ...
0
votes
0answers
173 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 ...
2
votes
2answers
2k 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. ...
1
vote
0answers
454 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 ...
0
votes
3answers
676 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 ...
1
vote
3answers
827 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 ...
0
votes
1answer
364 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 ...
2
votes
1answer
325 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 ...
1
vote
1answer
175 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 ...
2
votes
0answers
251 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 look fine except for limited number of Rows. However, if I ...
11
votes
4answers
7k 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 ...
0
votes
1answer
548 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 ...
0
votes
1answer
727 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 ...
3
votes
1answer
535 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 ...
3
votes
3answers
1k 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 ...
2
votes
1answer
353 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 ...
0
votes
1answer
232 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.
1
vote
1answer
349 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, ...
1
vote
2answers
221 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 ...