Business Connectivity Services

learn more… | top users | synonyms

7
votes
2answers
1k 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. ...
1
vote
1answer
87 views

Show Atom feed as external content

I hope that this is the correct place to ask this. I have a site that "spits out" an ATOM feed/seedlist that I want to show in SharePoint as an external content type. So far I know that this is done ...
3
votes
1answer
730 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
0answers
331 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) ...
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 ...
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
2answers
830 views

Using BCS and WCF to add external data to sharepoint index

Being completely new to the whole SharePoint environment, I am having trouble understanding exactly how to crawl external data into a SharePoint index. What I need to accomplish is that a user can ...
3
votes
3answers
2k 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, ...
0
votes
1answer
181 views

BCS: Edit button in context menu works, but edit button in display form is disabled

I created an external content type für a MS SQL Server view. I created a list from it and three different views and I changed the form with InfoPath. All of this done without VS, only SharePoint ...
0
votes
1answer
934 views

Create external content type with impersonated custom identity

I'm developing a SharePoint Application. I have SharePoint Foudation 2010. I have created a External Content Type with Impersonated Custom Identity(Connection to SQL Server 2012). After I created a ...
0
votes
1answer
388 views

Catastrophic failure when crawling BCS data in SharePoint 2013

I am getting error in search crawl Logs when doing a full crawl on a Business Data Connectivity content source. The content source is set up to crawl a SQL BCS entity that has a stream accessor, ...
0
votes
1answer
959 views

Create a SharePoint 2010 BCS connection to Web Service with Visual Studio only

While I have been using SharePoint for quite some time I have not used BCS at all (except way back when I took some training). What I am looking for are steps to create a BCS connector to an external ...
0
votes
0answers
36 views

Cannot modify BCS Model Security Validation Exception

I am trying to programmatically modify a ECT/Entity based on REST data from another system. It works if I am running it from a console application but if I am trying to run it from for example a ...
4
votes
3answers
5k 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 ...
5
votes
3answers
517 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
2k 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 ...
1
vote
0answers
49 views

BCS entity code update

I have a problem with the develop with BCS and the Search in SharePoint 2013... I develop an entity that connect with UCM documents and it incorporates in search service (crawling, indexing, etc) The ...
0
votes
1answer
187 views

Cascading External Data in Sharepoint 2010

I have a list called "Jobs" that have two columns (Type External Data) called "Company" and "Project". When the user selects a Company, I need the field "Project" filter projects in accordance with ...
0
votes
3answers
1k views

How can I view Developer Dashboard from a custom master page or PowerShell?

I need to view Developer Dashboard data to investigate a bottleneck on a SharePoint deployment, but the master page has been customized and the Developer Dashboard is not available (after enabling it ...
1
vote
2answers
500 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
163 views

Sharing list data between sites

I have a list on a sub-site that I want to share via Drop Down List with a Calendar on the root site. ie. When you add or modify a Calendar entry, one of the columns will be a Drop Down List ...
0
votes
1answer
81 views

Using External Content Type Pickers with Boolean fields

I have a SQL table with three fields - a unique ID I don't care about, a description, and a Boolean indicating whether or not the record is 'current'. This table is setup as a fairly standard ...
1
vote
1answer
364 views

SharePoint 2010 - Create related hierarchical fields from external source

Is there a way to create two related columns as a custom field type in SharePoint? For example, can you develop a custom field type named CustomerOrder that consists of two related lookup columns ...
11
votes
5answers
11k 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 ...
1
vote
1answer
222 views

Search in Custom indexing connector with AttachmentAssociator property in AssociationNavigator

I have a custom indexing connector with Entities associated via AssociationNavigator method. In order for Search (of SharePoint 2013) to crawl the associated entity, we need to set either the ...
3
votes
2answers
1k 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 ...
0
votes
1answer
413 views

InfoPath changes the look of the form

I am following this guide to create a cross site lookup field in SharePoint. I am using SharePoint 2013. The problem is that when I open the form with InfoPath Designer 2013 the form doesn't resemble ...
4
votes
3answers
1k 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 ...
1
vote
0answers
253 views

Using InfoPath inBrowser forms, create reports from captured data, and present those reports back in SharePoint

I'm using SharePoint 2010 and I have access to InfoPath and BCS services. I’m looking to use InfoPath forms that are accessed IN-BROWSER through SharePoint to capture data, and use that data to ...
4
votes
1answer
461 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 ...
0
votes
0answers
1k views

BCS custom connector and incremental crawl with search server express not working

we are currently developing a generic connector framework to access JSON-resources from an HTTP-Server. As the connector should not depend on a data model it heavily relies on DynamicType. As there ...
3
votes
1answer
310 views

Context Aware BCS Model for Search Crawling in SharePoint 2013

I have an external SQL data source that I would like to include in SharePoint search crawling with a BCS/BDC model. As it stands, SharePoint sees this data independently of the SharePoint site ...
1
vote
2answers
3k views

working and filtering with large external lists using BCS

I have a large set of orders (about 7500) that I want to show in my SharePoint site. I'm using BCS because I also want to link the orders to documents. I also have an external list with these ...
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
0answers
297 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 ...
1
vote
3answers
2k 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
389 views

How can I create a multi-valued refiner for a Business Data Catalog external content type?

This question regards a SharePoint 2010 instance using vanilla search. I'm currently using a Business Data Catalog to pull records from a database table with an end-goal of displaying the records in ...
0
votes
1answer
165 views

Which approach I should follow; SharePoint business connectivity services OR developing SharePoint App

I have developed a document management system and an enterprise wiki library for our company using SP2013. The second project I am going to start is to develop an asset management system for our ...
0
votes
0answers
25 views

Is there a way to make data linked to by BCS look like a document library?

Is there a way to make the data linked to by BCS look like a document library? Basically, I'm storing some archival type documents in cheaper storage than a SharePoint document library, but I would ...
0
votes
0answers
540 views

The created external list does not support creating new items

i have BCS with external list that read list and read item is from a table. and create new item is from Stored Procedure. i'm using applicative user who has full permissions (work directly from ...
0
votes
2answers
278 views

Get Items from View of an Extrenal List(BCS List) programmatically

I have created a external content type (BCS list) in SharePoint. I am using the below code in order to get items from bcs list. SPQuery query = new SPQuery(); query.Query = ...
1
vote
1answer
193 views

External List not returning values

I have an external list which isn't returning any values. The list uses an external content type, which gets information from a SOAP service. After creating the content type using a read item and ...
0
votes
1answer
335 views

Search External Content type not returning all records

I have a sql view that returns 449 records. I have setup my external content type to point to this view and have implemented via SPD the read item and read list operations. I have created the ...
1
vote
1answer
534 views

Error while creating a new customer via BCS from within a web part

This is my first time that I am using BCS via a web part and in general. this is my code and I am getting the following error: The given dot notation 'CustomerID' refers to a node in Type Descriptor ...
0
votes
0answers
100 views

Enumerate BCS Object Permissions

Hi I am looking for a method via PowerShell to enumerate the various ETC's that have been created to determine who currently has access. I realize that I can do this via the front end, however I need ...
0
votes
1answer
450 views

Getting Filtered results by Date column from a list with BCS and SharePoint 2010 JavaScript Client Object Model

I'm trying to get the filtered results by a column type DateTime from a list filled with BCS using JavaScript. I've tried everything to get those results with query like: "<Where>" + ...
1
vote
1answer
46 views

Limiting a view based on authentication by writing qualified username

This article http://www.thesharepointbar.com/?p=340 how to limit a read on a user in BCS, but we can't find the correct syntax for fba-users. (MS Quote: If the login mode for the user is claims-based, ...
1
vote
3answers
257 views

SharePoint foundation and BCS

I am testing SharePoint 2010 foundation with bcs to access one of my sql tables. I created a list with filters on some fields (wildcard and limit types) But unfortunately, when I display (browser) ...
1
vote
1answer
73 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 ...
0
votes
0answers
117 views

Show related entities in FAST search results

I've successfully created a .net assembly BCS to crawl external data in my enviorment. The BCS include an AssociationNavigator to crawl related entities based on foreign key. When i perform a crawl ...