Business Connectivity Services

learn more… | top users | synonyms

1
vote
0answers
103 views

Authentication between SharePoint O365 and external OData web service

We are using SharePoint Online (O365) with ADFS. We are also building an on-premise OData web service to provide data into the cloud as an External Content Type. We understand generally how to use ...
0
votes
0answers
258 views

SharePoint 2013 BCS External Data Column

How do I return all entities without using entity.GetFilters() ? I have the following and I can only seem to produce a FilterCollection. I would much rather have just all the enities because i am ...
0
votes
0answers
112 views

SharePoint 2013 External content type security trimming issue

I have a need to security trim only selected external content items using "deny" for a AD group. So created security descriptor method which returns a byte array. The problem is the security ...
0
votes
1answer
238 views

SharePoint 2013 External Content type. Populate secondary fields

I am trying to migrate data to a document library that contains a external content type using the SharePoint 2013 client object model. The external content type is pulling from a sql server 2012 ...
1
vote
1answer
276 views

Fast Search for Sharepoint 2010: Incremental Crawl Memory Leak

Background My organization has been attempting to use FAST Search for Sharepoint 2010 as a search solution for our DMS. I am currently utilizing a .Net indexing connector to index a database of ~ 8 ...
1
vote
0answers
21 views

Sharepoint Business Connectivity Service PrincipalIdentityNotMappedException

Today all external lists on farm suddenly stopped working and I cannot configure any BCS application in central admin configuration. There are ...
0
votes
1answer
450 views

Is it possible to link existing Sharepoint 2010 lists to SQL server databases?

I created a SQL server database and added a table to it. Then I used Sharepoint Designer 2010 to create an external Content Type using this table. Now I can alter the according Sharepoint list which ...
1
vote
0answers
38 views

Are third party solutions really that superior to BCS?

Let us assume it is my task to establish a bidirectional connection between a SharePoint List and a SQL-database. According to Paolo Pialorsi's Developer Manual for SharePoint 2010, BCS (Business ...
0
votes
1answer
80 views

BCS external content type as lookup

I have written a wcf service to read the title and id column from a list and returning as arraylist. Please find the below code. The webservice is returing the values correctly.Now when i create an ...
0
votes
2answers
132 views

SharePoint 2013 - Managed property value does not update

I have configure SharePoint Search with line of Business Content Source (BCS). Create Few Managed Property with this BCS. Records is crawling successfully however managed mapped property value does ...
0
votes
1answer
54 views

BCS Question (scenarios when data source is unreachable)

I have a few real-world (hopefully simple) BCS questions for on-premise database and SharePoint Online (O365) connected by OData web service: In the scenario where the data source is ...
1
vote
1answer
407 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) ...
1
vote
1answer
52 views

BCS Question (changing data source of a web service)

We are going to be building a Web Service (on-premise) to connect our data to SharePoint online (o365) using BCS and OData. If we migrate our database from one location (in Oracle) to another (e.g. ...
1
vote
2answers
505 views

Why aren't my result types working with managed properties?

I'm having trouble getting Result Types working in SharePoint Search. I've defined a result source for one of my BDC datatypes, plus a result type that matches everything from that result source. ...
0
votes
0answers
15 views

Site URL BDCS Error

Error occurred in deployment step 'Add Solution': The default web application could not be determined. Set the Site URL property in feature SP xxx Feature to the URL of the desired site and retry ...
2
votes
1answer
333 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
109 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
573 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
379 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
192 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
545 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
408 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
166 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
98 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
119 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
38 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
155 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
277 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
1answer
108 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 ...
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
72 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
152 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 ...
2
votes
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
63 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
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
553 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
67 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
523 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
643 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
265 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
33 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
111 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
41 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
406 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
994 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
615 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
99 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
80 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 ...