Business Connectivity Services

learn more… | top users | synonyms

2
votes
2answers
1k 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
1k 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
3k 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
63 views

SharePoint - reporting data from SQL

We have got a time tracker website in ASP.NET which is used by employees to record their daily time and work. The data is huge (about 10 years of data and ongoing) and stored in the SQL database. We ...
2
votes
1answer
2k views

External Content Types are not available. Contact your system administrator - BCS - User profile sync

I'm trying to setup a BCS connection from a SQL view -> user profile properties. I've created the external content type and got the right view. I also set the "set object permission", checked all ...
2
votes
2answers
1k 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
3k 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

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
1k 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 ...
2
votes
1answer
765 views

Using BCS and External Content Types to create Publishing Pages

I'm starting a new SharePoint 2010 web content management project where a portion of the site's content is driven by an external system (SQL Server based). Think employee bios... The external system ...
2
votes
1answer
788 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. ...
2
votes
2answers
627 views

Implementing Security on custom BCS/.net class?

I'm implementing a custom BCS Model to get data from a backend system. As the backend uses it's own user management, I'm accessing it through a service account. All of this works well and allows me ...
2
votes
1answer
2k views

BCS and Oracle: bug in connection string?

I am trying to connect from BCS directly to Oracle, but there is an error: Keyword not supported: 'connect timeout'. I think that the connection string formed for Oracle is in an incorrect ...
2
votes
1answer
79 views

Provider Hosted App vs BCS

I'm new to Office 365/2013 but I've been working with on-prem SharePoint 2007/2010 for a while. I've mostly setup some simple webparts to pull data out of SQL/WCF and display it. I'm wondering what ...
2
votes
1answer
1k views

Throttled While Crawling Large External Databases

I created an ECT using SPD2013 last week. It connects to a SQL DB while using the Secure Store to impersonate a domain user for a particular DB View. Last week, I used my personal (farm admin) ...
2
votes
1answer
1k views

Impersonated Windows Identity vs Impersonated Custom Identity

Could anyone explain the difference between Impersonated Windows Identity and Impersonated Custom identity in SharePoint?
2
votes
1answer
337 views

SP Designer 2013 - External Content Types & BCS

I'm currently setting up an experimental 2013 environment with BCS, following the instructions in the AdventureWorks white paper found here - http://www.microsoft.com/en-gb/download/details.aspx?id=...
2
votes
2answers
2k views

How to connect multiple external tables into one SharePoint list to perform CRUD operations

I am working with SharePoint 2013 and I have a requirement where I have to perform CRUD operations on multiple external tables (SQL Server) with SharePoint in one List and vice versa. I am able to ...
2
votes
1answer
2k views

User profile properties mapped to a BCS connection requires two syncs for new users

I have the User Profile Service Application up and running in a SharePoint 2010 farm. It is configured with two synchronization connections; one to Active Directory and a second to a backend database ...
2
votes
2answers
227 views

BCS Date Only field on Update Form

I'm tasked with finding a method for Updating a field that is defined as Date in SQL, but rendered as DateTime through BCS (as there is no Date-only type). On the Update form, I only want a Date ...
2
votes
2answers
4k 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 ...
2
votes
1answer
621 views

custom paging and sorting in BCS

I'm creating a custom .Net Assembly connector. I have to show a lot of data, so I want to page and sort that. I've already created parameters in my model for that: StartRow PageSize SortField In ...
2
votes
1answer
758 views

ReadList with Association for External Content Type via Visual Studio

I would have thought this is a common requirement but I just cannot seem to find any resources addressing this. I have several Entities defined along with Associations between them. They deploy ...
2
votes
1answer
2k views

External Content Type Search not returning results

I have configured my 2010 External Content Type for search by adding the RootFinder property to the ReadList method. I have also added the ShowInSearchUI property to the LOB entry. I then set up my ...
2
votes
1answer
495 views

BCS Model not deploying in Farm environment

Has anyone else seen an issue with deploying a BCS Model WSP to a farm and the External Content Type is not being deployed? The Farm feature is activated. It is working fine for a single server ...
2
votes
1answer
670 views

Sharepoint Online and custom BDC models

Hello I hope somebody can help. I need to access an external timesheet from Sharepoint Online. The Timesheet site uses a REST api to provide the data, not a WCF or traditional ASPX webservice. So ...
2
votes
1answer
698 views

How to customize profile pages for external content type search results?

I have set up the SP 2010 enterprise search to include searches in line-of-business data. (In my concrete case that would be data from Dynamics CRM 2011 but I hope that is not relevant). I have ...
2
votes
1answer
83 views

Good book or resource that talks about custom connectors and SharePoint search Integration?

Do you know any good books or resources that explains how to write your own custom connector for search crawling? I have been reading Professional Business Connectivity Services in SharePoint 2010 ...
2
votes
1answer
1k views

Is there a way to modify external list form with Infopath?

I would like to modify an external list form with infopath like I do with custom lists. However, even if I select "create infopath form" when creating my external list, it doesn't seems I can do that.
2
votes
2answers
1k views

Supplementing User Profile with information from BCS

I've got my external content type and BCS all sorted and working - the list view of the external list shows 100% in the site and the external content type shows under my BCS service application. Now ...
2
votes
2answers
671 views

Can I use a Console Application to Programmatically Create a Content Data Source and Start Crawl?

I am looking for examples where folks have programmatically defined a business data content source and setup Search Service Administration to crawl it, all within a console application. I'm aware of ...
2
votes
1answer
225 views

BCS, field captions/title localizations

We've developed BCS appllication and now have no ideas about how to localize fields titles in BCS model. Where some xml tags in BCS model definition, but it did not work in our practise. Does ...
2
votes
1answer
2k views

Developing Visual Web Part with external list in ListView

Using VS 2010 i've created BCS model for external MS SQL source, deployed it with success, then created external list - it works perfect. Now my task is - create visual web part in VS2010 and place ...
2
votes
1answer
2k views

Creating a Site Column from an External List with SharePoint 2010?

Can you create a Lookup column from an External List within SharePoint 2010. I have achieved this before but it seems incredibly fragile and I am now wondering if this is even a supported feature and ...
2
votes
1answer
24 views

What happens to External List created using BCS from SQL query once the server goes offline?

If the database gets deleted or somehow goes offline, will the list keep the existing data or will it all be gone due to failed synchronization.
2
votes
0answers
186 views

Unable to Refresh BCS External Data

I am running into a refresh issue with BCS. Whenever I hit the little refresh button in the UI, I am repeatedly getting this error. I am using an OData web service for BCS with WindowsCredentials ...
2
votes
0answers
709 views

Getting External Data from Oracle to O365?

We have an on-premise oracle database with customer info (lets say roughly 10,000 rows), that we need to make available in our SharePoint Online (2013) environment in O365. The requirement is that ...
2
votes
0answers
302 views

Using code, how to sync data from CRM online 2011 to sharepoint online 2011 (or 2013) & vice-versa

I am trying for a proof-of-concept on this one. I have a sample crm-online plugin and I would like to know if through the code I can open my sharepoint online site and thereby get access to the lists/...
2
votes
0answers
287 views

Custom BCS indexing connector with changelog inremental crawl is not working properly

Custom BCS indexing connector with changelog inremental crawl is not working properly I am writing a custom indexing connector using changelog incremental crawl approach. I'm using sample from http://...
2
votes
0answers
582 views

LastModifiedTimeStampField not working in incremental crawl (SharePoint 2010 + BCS + FS4SP)

I'm using a custom BCS .Net Assembly connector with my BDC model but can't seem to get the Incremental Crawl working correctly. It keeps doing a Full crawl, or at least it seems that way because the ...
2
votes
0answers
134 views

BCS and External List: Validations and Business Logic

I have been able to define an External List through a WCF Service. This works well, but I am now moving onto more advanced scenarios - I would like my Create, Update and Delete methods to implement ...
2
votes
1answer
197 views

Should I Use Business Connectivity Services or Not in This Specific Scenario

I'm currently working on a SharePoint Standard 2010 project. I would have preferred to use the User Profile Service to sync with AD to populate employee details, but our AD doesn't have much ...
2
votes
0answers
498 views

Business Connectivity Services over OData : caching and paging?

I'm planing a new application for a customer that requires to read data from an external system. Basically, the external system will expose a read-only OData service (to be defined actually). The ...
2
votes
0answers
148 views

External Data Column no sorting by a string based additional field

Can anyone confirm or tell me why you can't sort by an External Data column additional field if its type descriptor is a string? It works for int, bool and guid type descriptors. If I add a standard ...
2
votes
1answer
348 views

The operation(s) generations creates an SQL query which exceeds the length limit in Business Data Connectivity Metadata Store

I am trying to add a table from a SQL database as an external content type. When I do so I am getting the following error: The database table has 188 columns (I did not design this legacy system. I ...
2
votes
2answers
3k views

External Data field - problem with refreshing (SP 2010)

I have created a custom list with a field (column) of 'External Data' type, connected to my external content type. External Content Type's source is an SQL view. My problem is, when I make changes on ...
2
votes
0answers
366 views

Changing the field order after BCS Association? [closed]

I’ve created and deployed an External Content Type with Associations. All of the CRUD methods I’ve implemented are working correctly. Here’s my problem – in the View Item, Edit Item and New Item forms,...
1
vote
2answers
132 views

BCS, can I connect a result of SQL query to external database in SharePoint list?

Can I connect a result of SQL query to external database in SharePoint list? As I understand - External Content types could map only one table for list, but I need to get some combined data from few ...
1
vote
3answers
405 views

What is BCS and what can it do for me?

I've been hearing a lot about it but even having Googled the subject I'm not sure what it is or what it can do for me. I believe BDC's could be considered a BCS component? What is BCS?
1
vote
1answer
3k views

BCS External Item picker

There are two external lists like 'Project' and 'Task'. Task referencing project by using field ProjectID. I've created external content types. For 'Project' content type I've marked field '...