Business Connectivity Services

learn more… | top users | synonyms

11
votes
4answers
6k 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 ...
10
votes
7answers
15k 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. ...
9
votes
3answers
1k views

FAST Search Security Trimming of non Windows External Content Types

We have integrated a back-end web application into SharePoint 2010 using the BCS and the OOTB Web Services connector. The data in the backend system is protected by ACLs and we need these ACLs to be ...
8
votes
5answers
8k 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 ...
7
votes
2answers
756 views

SharePoint 2010 User Profile Synchronization: BCS + WCF

I'm here because I'm trying to implement a scenario of user profile synchro with bcs connecting to wcf service. Here is the context: A remote web service is returning a full list of employee infos. ...
6
votes
4answers
3k views

Working with large external lists using BCS

I have a database that I want to display the content in SharePoint 2010. I am not displaying the content in a list but am using a custom WebPart. The database is not updated any more as it is ...
6
votes
4answers
1k views

Reusing and parameterising BCS External Content Types

I recently posted a query here that asked about the best way of connecting to an external SQL store. I got some great responses back but need a little more info, specifically around External Content ...
5
votes
2answers
629 views

Use custom page in _layouts for display item form

I was wondering if I could acheive the following. I have a custom application page living in _layouts which displays an entity based upon an external content type item. For external lists using this ...
5
votes
2answers
1k 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 ...
5
votes
2answers
310 views

How to dynamically generate Business Connectivity Services

We are trying to deploy a Business Connectivity Services(BCS) Model solution where the properties in the model depend on the structure of the data exposed by a web service. Ideally the BCS Model ...
5
votes
1answer
261 views

How to use BCS in Word for editing BLOBs

If I have an External Content type defined with a StreamAccessor that will end up referencing Word docx files stored in another system (reason for using BCS), what options do I have for updating the ...
5
votes
3answers
331 views

CAML query on external list: access denied by business connectivity services

I am trying to run a CAML query on a BCS list and getting access denied as an error when debugging the code: SPList CMList = web.Lists[Constants.cmlist]; SPQuery query = new SPQuery(); query.Query = ...
5
votes
2answers
606 views

Updating Active Directory User Information from Sharepoint User Profiles BCS Data

I am investigating the possibility of updating Active Directory user account information from Sharepoint 2010 User Profiles. I am aware that there is functionality to synchronise data from the User ...
4
votes
2answers
4k views

Access Denied while setting Metadata Store Permission

Breaking my head with this issue for the past 2 days! Received Access Denied error in SPD so tried to set Meta Data permission and get the following error. I am one of the Admins for BSC service ...
4
votes
3answers
3k 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 ...
4
votes
1answer
216 views

Int type as Entity key into BCS Model

The BCS Model can't create a form for the "Update" operation if the key of Entity has a type of uint, int, long or ulong when I use WCF as a data source. It works fine with the string type. Does ...
3
votes
1answer
4k 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 ...
3
votes
3answers
1k views

Moving BDC models from server to server

I have created a BDC model and deploy it through a feature. The feature has to have a SiteUrl as specified in the feature xml below. However when I move the feature from say the development to test, ...
3
votes
2answers
539 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 ...
3
votes
2answers
1k views

TFS-SharePoint integration

I am currently investigating how to push data from Team Foundation Server to SharePoint. Are there any connections available out of the box? Any useful online references? Third party tools?
3
votes
1answer
150 views

Can document views/metadata be 'live'?

We have a need for end users to see documents with additional 'live' columns, i.e. I would like to show a view of documents with employee id JOINED with data from sql server (for some additional ...
3
votes
2answers
226 views

Update CRM from User Profile

We currently have Sharepoint 2010 setup to use AD to get useraccounts, and a BCS connection to provide extra information to the User Profile of users. The data from AD is very basic: only username and ...
3
votes
1answer
2k 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 ...
3
votes
1answer
696 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 ...
3
votes
1answer
130 views

How to Sync user data from multiple sources BDC and AD?

I have a user profile that has fields from multiple sources. fields form AD and fields from BCS -> SQL DB. Everything is working, except if the DB is down, the fields get populated with empty data. ...
3
votes
3answers
665 views

Custom BCS indexing connector and changelog inremental crawl: ChangedIdEnumerator method is not working

I am writing a custom indexing connector using changelog incremental crawl approach. The full crawl is working perfectly. All atems are indexed and queryable. The problem is that incremental crawl ...
3
votes
1answer
621 views

Paging and sorting with BCS - Is it really possible?

I'm trying to add paging on an external list and so far it does not work 100%. The best references I could find (that actually... kinda... work) are these: Paging and sorting with BCS Paging and ...
3
votes
1answer
523 views

Access denied for BCS method in e-mail event receiver

I have a SPItemEventReceiver which does some stuff with an external list when a document is uploaded to a DocLib. I now wanted to have it also run when an e-mail is sent to that DocLib. I could have ...
3
votes
1answer
513 views

How to use the batching and batching termination filter descriptors in BCS .NET Connectivity solutions

I know about this post on BCS paging: Paging and sorting with BCS and have implemented a similar approach in a BCS solution. However, what I'm really looking for is a complete example showing how to ...
3
votes
1answer
303 views

Is it possible to filter a BCS list using a site's name?

I'm running SharePoint Foundation and copying a site template per project. I would like to filter the BCS list in my template using the site name. Is there a possible method?
3
votes
3answers
2k views

Display an SPFieldUrlValue property from a BCS Model

I have a pretty simple BCS model: public Guid Id { get; set; } public SPFieldUrlValue Url { get; set; } public string Description { get; set; } public string Owner { get; set; } public DateTime ...
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 ...
3
votes
1answer
632 views

Business Data Connectivity Service is not accessible

I am working on sharing service applications across farms ( SP2013 Publishing Farm, SP 2010 Consuming Farm). Services like Search, MMS and Secure Store are working perfectly fine after sharing. ...
3
votes
0answers
106 views

Ribbon is disabled when I Filter an external list in SharePoint 2010

I created an external list in sharepoint 2010 (SP1) using SPD. The backend is sql server. The I added a wildcard filter on a column called Source_System (and a limit filter). The out of the box ...
3
votes
0answers
189 views

How to filter a paged and sorted external list

I have succesfully implented an external content type with a read list method, which can sort and page through the external data. The external content type has 4 filters (two limit and two wildcard) ...
3
votes
1answer
244 views

SharePoint 2013 Custom BCS/BDC Entity Search Refiner

I have a custom BCS model that I am using to index SQL data in SharePoint 2013. The localized name of the type of item is being set as the title (i.e. Answer, Question, Idea, etc.). In the search ...
3
votes
0answers
249 views

Filling a External Data field (BCS) in a list trough Powershell [duplicate]

I have a list of which one of the columns is of the "External Data" type, linked to a BCS service. We called this column "Organisation", and when I check the generated fields in powershell (with ...
2
votes
1answer
1k views

Creating an external list from SQL query using BCS

I'm developing a visualization application on SharePoint Enterprise 2010. This involves doing some SQL queries I would love to expose as external lists in SharePoint. All interfacing with the database ...
2
votes
1answer
412 views

Dropbox access from SharePoint

I am new to Dropbox, and I'd like to know if there is an easy way to access Dropbox content from SharePoint 2010 / Office 365. For example, should I consider BCS? Or is there a way to work with the ...
2
votes
3answers
7k views

How do you enable connect to outlook on external list?

I am very new to sharepoint, its about day 3 of working with it, and I am having a problem getting Connect to outlook working on external lists. The menu item is greyed out. In my external contact ...
2
votes
2answers
685 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 ...
2
votes
2answers
990 views

Selecting default filter

I have a ERP system which is linked to SharePoint via BCS. In a previous 2007 site, the BDC layer used the searchcode from the ERP system as primary key. That meant the user could just type in a ...
2
votes
1answer
998 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 ...
2
votes
1answer
2k views

No Business Data Connectivity Service associated with current web context error

I am running on a new dev setup for SharePoint 2010 and trying to setup some External Content types. I think that I have setup BCS correctly (since I see it running in the central administration). ...
2
votes
1answer
149 views

Timestamp in Sharepoint external content type not matching value in SQL table

I have an external content type in SharePoint 2010 pulling data from a SQL 2008R2 DB using BCS. All the data comes back fine but the Time stamp column is off by 2 hours when I compare the values ...
2
votes
2answers
497 views

Connect SAP data from SharePoint 2010

If we want to create a custom connector to connect SAP data from SharePoint 2010 ... how to do that? what steps are involved?
2
votes
1answer
1k views

External List from External Content Type: missing and/or error

I've created an ECT w/ Read List and Read Item operations using SharePoint Designer, saved it, and given myself permissions. The ECT's external data source is a WCF service. When I try to create an ...
2
votes
1answer
2k views

How To Define Specific ReadItem Finder with List View in External List?

I have an external list which is using the BCS to pull data from a custom database. This database has several views which have the same column structure and several that do not. I have been adding ...
2
votes
1answer
1k views

External list with friendly display names for columns

I have an external content type that I'm accessing through a .NET assembly. So I created a BDC model with Type="DotNetAssembly" (for now with just finder and specific finder operations). It works, ...
2
votes
3answers
837 views

SPTimer job and BCS External list

Business requirement - synchronize a table from external my sql database into SharePoint list. What I have done. I have an external MySql database which as LOB data. I have created a BCS ...