Business Connectivity Services

learn more… | top users | synonyms

2
votes
2answers
937 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
956 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
726 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
730 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
606 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
1k 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
515 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
233 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
213 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
595 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
670 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
439 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
605 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
590 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
79 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
918 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
973 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
606 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
215 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
2answers
29 views

Service instance quantity

On a clean farm (one WFE\APP server and one back-end (SQL)) after installing SharePoint binaries i ran some configuration scripts. One of them contains command Install-SPSerivce which, according to ...
2
votes
0answers
92 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
451 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
262 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
537 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
127 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
192 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
452 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
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
0answers
134 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
301 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
349 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
3answers
365 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
2k 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
652 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
618 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 ...
1
vote
2answers
3k views

Access denied by Business Data Connectivity on Setting Metadata Store Permissions

When I try to configure Metadata Store Permissions I keep getting this error I am the Farm Administrator and have full access on Sharepoint to start with. Now as I drilled down further looking at ...
1
vote
3answers
1k views

How to sync a Sharepoint 2010 list with data from a table in SQL server

I have a table in SQL server 2008 and a list in sharepoint 2010 that has a few columns from this table and a few other unrelated columns as well. This SQL server table keeps changing and I want to ...
1
vote
1answer
67 views

Read/Write capability in BCS

Can someone tell me what exactly does "Read/Write Capability" means in Business Connectivity Services for SharePoint 2010? I read it somewhere that this is a new feature in 2010 which was not present ...
1
vote
1answer
1k views

Synchronization of SharePoint 2010 List with SQL Server Table

I need to create a list such that the values on the list can be stored in SQL table as well. I need to attach workflows to the list item as well. Its a simple workflow with two approval process ...
1
vote
3answers
3k views

Setting Value of External Field in Code

I cannot seem to find any examples of how to set a BCS External Field via code. I have two lists that both have a BCS field named "Industry". When an item is created in List A I need to create a new ...
1
vote
2answers
441 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 ...
1
vote
1answer
2k views

How to call Finder Method with Parameters using BCS Runtime Model

Hi i have created BCS model which use secure store service for authentication to External system.Everything works fine using out of box external list and BCS webparts but i want to create custom ...