Business Connectivity Services

learn more… | top users | synonyms

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
57 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
1k 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
2k 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
758 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
776 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
624 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
74 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
939 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
316 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 - ...
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
224 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
617 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
737 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
487 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
660 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
683 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
662 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
19 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
173 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
1answer
655 views

REST API ItemCount on oData BCS List

I have a list generated from a BCS oData provider and I am attempting to get the number of items in the list so I can generate a $top on my request rather than bring back only the 100 item generic ...
2
votes
0answers
663 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
300 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 ...
2
votes
0answers
282 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 ...
2
votes
0answers
571 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
493 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
143 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
340 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
0answers
363 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 ...
1
vote
2answers
74 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
397 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 ...
1
vote
1answer
657 views

Best way to get external data to SP 2010

This is the scenatio: I have an AD that i'm going to use when installing SP 2010 but it doesn't have a lot of meta data as in poperties its only got : Lastname, fistname and email etc.. So i would ...
1
vote
4answers
2k views

BDC to BCS Application Definition Upgrade

I'm trying to perform an upgrade of a SharePoint 2007 environment to 2010. Our plan is to move to entirely new hardware and do a content database migration. In such a scenario, it seems that BDC ...
1
vote
2answers
628 views

BCS and SharePoint 2010

I'm looking to possibly upgrading to the latest version simply because the latest version has BCS integrated with the free version. A question I have to answer is "Does BCS integrate with Sage ...