Questions tagged [bcs]

Microsoft Business Connectivity Services (BCS) (formerly named the Business Data Catalog) provides the capability to allow data sources outside of SharePoint to be surfaced and potentially modifiable in SharePoint's List user interface. Use this tag for questions or problems related to configuration or using BCS.

Filter by
Sorted by
Tagged with
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
14 votes
3 answers
14k views

Paging and sorting with BCS

I going to use the new exciting External Content Type feature to display a list of data from an external LOB system. The list is potentially long, so paging with filtering at the LOB system side is ...
Vitaly Baum's user avatar
2 votes
2 answers
6k views

Deleted item still showing up in search results if only doing Incremental Crawls

I'm trying to set up a Sharepoint search service using a Content Source based on an external BCS data source. In the BDC model, I implemented the operations I needed, adding a SpecificFinder, an ...
guillaume31's user avatar
16 votes
8 answers
67k views

How to sync a SQL database with a SharePoint List?

I need to sync an already existing SQL Database to a SharePoint 2010 list. Two way sync would be great but one way sync is also alright. Any documentation in this regard would be of a great help. ...
neo269's user avatar
  • 3,175
8 votes
3 answers
8k views

BCS External Content Type with 20,000+ items (O365)

We have a large database of 20,000+ items on a local database that we need to get into Sharepoint Online 2013 in O365 to use as metadata for various documents in multiple locations. New entries and ...
Brent Ellis's user avatar
7 votes
2 answers
8k views

BCS in Sharepoint Online

What are the features and limitations of BCS in Sharepoint online. Can we create an external content type using Stored procedure in Sharepoint online.
Misha's user avatar
  • 83
5 votes
3 answers
6k views

Date Only format with BCS

I have created an External Content Type through SharePoint Designer. One of the fields that I'm getting from my database is a DateTime column. In SharePoint, however, I want to format this as a Date ...
Andy Burns's user avatar
  • 4,949
4 votes
1 answer
1k views

multiple value in external data column

We need to store multiple value from external source in the one column. Same multiple lookup. Is there any exiting way to do it? If no, i think about developing custom entity piecker, but it need ...
IAfanasov's user avatar
  • 1,926
4 votes
1 answer
3k views

Sharepoint Incremental Crawl and BCS

I have a BCS connector (partial BDC Model posted below) and I'm noticing some issues with Sharepoint crawls. My full crawl seems to work perfectly, but incremental is pulling back the same number of ...
firebellys's user avatar
4 votes
2 answers
648 views

2 ways Communication required from SAP to SharePoint

I need to to get the data from SAP to SharePoint, and on performing CRUD operations via Lists from SharePoint. The updated data should also get effected in SAP. Can anyone help me in knowing how I ...
MSA's user avatar
  • 1,155
4 votes
2 answers
2k views

Does all external SharePoint data have to flow through BCS?

I was asked the question why I need access to BCS Services and have been tasked with documenting "ways to access external data in SharePoint' I've read one article after the next regarding external ...
Dazed and Confused..'s user avatar
3 votes
1 answer
8k views

CAML and External List - pass parameter to ReadList (finder) method

I have a Finder method defined on an External Content type (created with Visual Studio). Whan That method receives a parameter. So the method is something like ReadList(string partnerName). I have ...
Gomiunik's user avatar
  • 392
2 votes
1 answer
2k views

"Access denied" while loading the BCS list from the database

I have tried to display data from SQL Server to a SharePoint page through BCS services using SharePoint 2010 designer. While loading I am getting this error: Access denied. You do not have ...
Ayyappan Anbalagan's user avatar
2 votes
1 answer
905 views

Paging and sorting in sharepoint BCS

I saw this post about Paging and sorting and tried to do simiral thing in my project. But failed to do so. Everything works fine apart from instead of getting the value i get the parameter name. ...
user avatar
1 vote
3 answers
5k views

Problems configuring External List on Sharepoint Foundation 2010

I have created a new database on MS SQL SERVER SHAREPOINT instace that contains two simple tables. Then I tried to link values defined in these tables by implementing External Content Types using ...
Drake's user avatar
  • 435
1 vote
3 answers
3k views

Why aren't my result types working with managed properties?

I'm having trouble getting Result Types working in SharePoint Search. I've defined a result source for one of my BDC datatypes, plus a result type that matches everything from that result source. ...
Ben Wyatt's user avatar
  • 330
1 vote
1 answer
308 views

BCS Managed Client Code Get all method instances

When using the class Microsoft.BusinessData.MetadataModel.Entity entity; does anyone know how to get all the External Content type operation method instances so i can dynamically pass the value to ...
monkeyjumps's user avatar
0 votes
1 answer
4k views

External Content Type List as Lookup in SharePoint Online

I am working on a solution that will get data from a web service (third party) and create a list in SharePoint Online (Office 365 E3 subscription). Then use a column from that list as a lookup column ...
Robert's user avatar
  • 1
0 votes
2 answers
5k views

Error with External Content Type List: "Unable to display this web part"

I have deployed an external content type to my local Sharepoint 2010 Server using a Visual Studio solution. The deployment appears to work. I can view the details of the content part in the central ...
TZHX's user avatar
  • 1,062
0 votes
2 answers
5k views

Workflow to read data from external list

I have just recently started working with external lists using BDC and was quite surprised to discover that I can’t really interact with the data in any way using SharePoint 2013 workflows (Even just ...
Morten K's user avatar
  • 1,229
0 votes
1 answer
684 views

BCS UserProfile Sync to Oracle not working after upgrade from Oracle 10 to Oracle 11

I am experiencing problems with a BDC connection to Oracle. I am using SharePoint 2013. The database I am connecting to is moved to a new Oracle 11 server. It was Oracle 10. I use this connection to ...
Danny's user avatar
  • 478