Business Connectivity Services

learn more… | top users | synonyms

2
votes
1answer
269 views

Impersonated Windows Identity vs Impersonated Custom Identity

Could anyone explain the difference between Impersonated Windows Identity and Impersonated Custom identity in SharePoint?
0
votes
2answers
95 views

Insert data from a XML into a List

Two questions: Is it possible insert data from a XML doc in a SharePoint Native List? Because I checked and is possible create a DataView from a Xml source in SP , but I can't find if it's possible ...
0
votes
1answer
491 views

System Account not having permission to update external list via BCS

My SharePoint administrator granted permissions to services, sp app pool, sp farm adim, and secure store in BCS for me to use but was only able create/delete but not update. I use SharePoint designer ...
0
votes
1answer
303 views

Using workflow and BCS to sync external data - CRUD

I'm new to SharePoint and trying to get BCS working with external content. I need to "replicate" native list to an external SQL DB for my project. So I use the crated/changed workflow start options ...
0
votes
1answer
147 views

External Content Type = access denied

I have an External Content Type created. It connects to a SQL Server 2005 db, using "Impersonate Windows Identity" authentication, with an account over in Secure Store Service. I've got a Read List ...
0
votes
1answer
449 views

How to get BDC data from BDC URL returned by search in SharePoint 2013?

I am building a POC system based on Search in SharePoint 2013. I have setup BCS to crawl external SQL DB. Search crawl is successful and I am getting the results. I have not setup any Managed ...
2
votes
1answer
337 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 ...
3
votes
1answer
151 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. ...
1
vote
1answer
88 views

SharePoint 2010 - BCS secondary columns in viewedit.aspx

I was wondering if this has happened to anyone and if anyone can suggest a fix is. | SharePoint 2010 | Top level site | Administrator permissions I had a number of BCS connections to a document ...
5
votes
3answers
2k 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 ...
1
vote
2answers
103 views

Query External Data using BCS

I'm using SharePoint 2013 and I'm developing a webpart that has to query an external data and show the results. I cannot create external list due to the fact that my external table has more than ...
0
votes
1answer
36 views

I stopped the BCS service on a couple of servers, but I still get connectivity errors

Stopping the service on some of the servers seems to have no effect when the system is trying to make a web service call. Here is the error in the ULS: The BDC Service application Business Data ...
2
votes
1answer
126 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
0answers
237 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 ...
1
vote
0answers
87 views

namespace on external content type

I have noticed that when moving BCS lists/external content types from my development computer to our production server, it keeps the namespace of my development computer. For example, all the ...
0
votes
0answers
128 views

Using $expand with BCS External List via REST call

Is it possible to use the $expand odata keyword to expand a child (associated) entity from BCS within an external list using the REST API. Eg to get the country name from querying the customers list ...
1
vote
0answers
19 views

BCS: Allow deletion of rows only under a given condition

I created a BCS Model and external data type for a MS SQL table. I added a delete action, too, and it is working as expected. But now I want to allow the user only to delete items, that aren't ...
1
vote
1answer
65 views

Kerberos + SharePoint

Kerberos - the beast of SharePoint - has been configured and is creating tickets on my test environment WFE. I also had RevertToSelf for the BCS service application turned on. I am able to create an ...
0
votes
1answer
134 views

Business Connectivity Services vs. ADO.NET

Why should I prefer Business Connectivity Services (BCS) over plain ADO.NET, if all I want are simple CRUD operations on an external database (e.g. remote Oracle Database), which are made from a ...
1
vote
2answers
1k views

How can I get external content crawled into SharePoint online index

I have SharePoint online and I want to add external content to the index. So far I have it set up that the external content is put into an external list using BCS. The content passes through a WCF ...
1
vote
1answer
60 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 ...
0
votes
0answers
152 views

Sharepoint BCS multiple identifiers

I have a BDC model that worked well with one identifier defined. However when I added another identifier i'm getting the following error in the crawl log. Any ideas? Looking at the model i'm not ...
3
votes
1answer
1k 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. ...
1
vote
2answers
497 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 ...
1
vote
1answer
61 views

How to create a External Content Type equivalent to a Document Set?

I'd like to create an External Content Type either inheriting from or equivalent to a Document Set. I'm not finding any good examples and Document Sets are derived from folders, so the API must be ...
0
votes
1answer
447 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
567 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
1answer
248 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
0answers
32 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 ...
0
votes
1answer
105 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 ...
1
vote
2answers
2k 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
0answers
40 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 ...
5
votes
3answers
382 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
913 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
1answer
522 views

SharePoint 2013 Result Sources - Combining BCS Content Source with SP Content Source - Only See SP Content Source

Scenario: Content Source 1: Standard SharePoint Local Sites Content Source 2: BCS Application Seek to create 1 Unified Search Result from a Common Result Source.. I have been trying to combine a ...
0
votes
1answer
83 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 ...
1
vote
1answer
73 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
53 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
163 views

Item-level security possible with OData external content type?

I've created an External Content Type which uses an OData service as it source, and I created a content source in the Search Service Application in order to crawl this data. This works fine. However, ...
1
vote
1answer
236 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 ...
1
vote
2answers
1k 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 ...
3
votes
0answers
125 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 ...
2
votes
2answers
1k 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 ...
3
votes
2answers
746 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
215 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 ...
1
vote
1answer
132 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 ...
1
vote
0answers
186 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 ...
3
votes
0answers
223 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
302 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 ...
2
votes
1answer
231 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 ...