Business Connectivity Services

learn more… | top users | synonyms

3
votes
1answer
1k 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 ...
3
votes
1answer
3k 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. ...
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 ...
1
vote
1answer
26 views

SharePoint 2010 bcs item limit

I have an on premise SharePoint 2010 implementation. I need to implement a custom form with 65 fields which has rich text, drop downs and some complex filtering logic on the form. I want to load the ...
1
vote
1answer
39 views

Active Directory Import and it “not supporting” Business Connectivity Services Import

I'm in the process of setting up a new SharePoint farm. We only really need one way import for Active Directory so I've been thinking we'll go with simplified Active Directory Import... however... of ...
1
vote
1answer
184 views

SharePoint 2013 BCS and SQL Views

I have setup my SharePoint 2013 publishing site with BCS and Secure Store so that users can access multiple external lists within the site and if they have the correct permissions setup in Secure ...
1
vote
1answer
96 views

Business Data List web part customization?

I have a question with business connectivity services in SharePoint 2013. I have a connection with CRUD access using an SQL server. The list view displays all records, but I have use the Business Data ...
1
vote
1answer
51 views

Crawled properties missing for Business Data source

We've implemented and crawled a Business Data Connectivity Service data source. I can find the items based on the values in their fields, but when I look at Crawled Properties, there is only the ...
1
vote
1answer
28 views

External content types in sharepoint

I have an external list based webpart with 5 wild card filters. when I searched using one filter the required item is displayed but the same item is not displayed using other filter. For example if an ...
1
vote
1answer
417 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
1answer
1k 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
162 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 ...
1
vote
1answer
382 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
1answer
106 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 ...
1
vote
1answer
89 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 ...
1
vote
1answer
957 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 ...
1
vote
1answer
171 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 ...
1
vote
1answer
368 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 ...
0
votes
1answer
29 views

How we can access External content type to client system via code?

In visual studio we are creating one project and implement some functionality. Then we are deploying in bin folder we can get .wsp file. So the same functionality need for our client or other ...
0
votes
1answer
24 views

Activating BCS in sharepoint 2013

I'm wanting to use BCS in my SharePoint environment and i came to the problem of the database. Can we connect multiple databases on different servers? Can we select the database from its IP ...
0
votes
1answer
27 views

MetadataObjectNotFoundExceptionState when creating an external content type in SharePoint Designer

I am getting a really strange error in SharePoint designer upon trying to create an external content type for a simple SOAP Web service. The error happens at the moment I clicked Add Connection, have ...
0
votes
1answer
12 views

Displaying BCS data like profile view

I have configured external content type and able to display the data in Business data list web part. But now it is showing in table format. Emp ID Emp Name 1 aaa 2 bbb but I want something ...
0
votes
1answer
35 views

External Lists not working

Two problems. Despite spending all day learning BCS and Enterprise Features and getting all the different levels of credentials set in Central Administration when I put an External List webpart on ...
0
votes
1answer
74 views

How is Secure Store Service storing passwords under the hood?

When Business Connectivity Services need to access external data which requires per-user authentication, it uses Secure Store Service to store the user password in order to avoid asking for it again ...
0
votes
0answers
36 views

BCS is to get external data into SP, what about the other way around?

I am going to migrate/update our SP 2010 to 2013 or 2016 (depending on when it actually gets released). Preferably cloud. What our fear is currently is... if we go cloud will we really have access to ...
0
votes
0answers
11 views

Displaying BCS data and user profile data in single web part

I have successfully displayed external data i.e. sql using external content type and Business data list web part. Now the new requirement is I need to show user data from both sql and user profile in ...
0
votes
0answers
37 views

Defining DeletedCountField in BCS model breaks crawl

I've implemented the BCS model as described in http://chad-hinton.blogspot.nl/2015/06/bcs-models-part-7-changes-to-bcs-model.html using the StackExchange database. I used the exact model from this ...
0
votes
0answers
104 views

External content type data retrieving error in SharePoint Online

I followed this page to create an external content type in SharePoint Online and add a Business Data List Web Part to read data from this external content type. But it displays an error, it says An ...
0
votes
0answers
20 views

Crawl option not available in Sharepoint 2013 Search

I see that this option in not available for the Business Data category in SharePoint 2013 Search Administration. - Automatically discover new properties when a crawl takes place I have come across ...
0
votes
0answers
12 views

Custom Data Provider for External Content Type

I have a several data services and I want to add them to SharePoint portal. I found that I can create an external content types for that. All tutorials says that External Content Type can be created ...
0
votes
0answers
19 views

Is there any way to customize error in business data list

I'm looking for a way to customize errors for Business Data list. I want to change the following error in to some nice, user friendly error: An error occurred while retrieving data from ...
0
votes
0answers
75 views

Updating External List after Updating BCS: SharePoint 2013

I am using SharePoint 2013 and SQL Server 2012, both Enterprise Editions. Earlier I had created an External Content Type and created its External List. I have no problem performing various options ...
0
votes
0answers
24 views

Crawling Business Connectivity Service

I've been working lately on crawling Business Connectivity Service models in SharePoint 2013. I created the business data connectivity models with Visual Studio and deployed them to SharePoint. The ...
0
votes
0answers
65 views

SharePoint Online (Office 365) & BCS Authentication Error

Following systems are involved: - SharePoint Online / Office 365 On Premise SQL Database Back-end data source is on our actual estate and consists a SQL Database with an OData web service ...
0
votes
0answers
23 views

Sync data from sharepoint to external web application

I am writing a provider hosted app for showing data from Sharepoint and add additional functionality to the entities. So I am looking to import the unique id and title of all the entities in ...
0
votes
0answers
22 views

Can SharePoint user login to another system and display the information at Sharepoint?

We have a SP2013 on-premise farm and another self-written web application. The web application have its login member database and is written by Java. User would like to add a login box on SharePoint ...
0
votes
0answers
213 views

BDC: cannot logon with credentials obtained from secure store provider

Hmm.. When I manually create a new contentsource, point it to the single sql database-bcs everything works OK (no probs) (via Central Admin) but... When i try the same via a powershell script I get ...
0
votes
0answers
466 views

Sharepoint Online External Content Types WCF Service

I have this issue I can't find solution for a couple of days now as I am working on creating External Content Types for Sharepoint Online 2013 (trial period will expire in the next 5 days :( ). I ...
0
votes
0answers
226 views

How to retrieve BDC Identity from External List programmatically?

I need to do a lookup on an External List (in SharePoint Online - Office 365) to retrieve the value of the BDC Identity. BCS is talking to an OData web service. (I'm not a Visual Studio guy), so ...
0
votes
0answers
81 views

Filter BCS Data by Users AD Group

I'd like to know if it is possible (and if so, how) to filter the BCS data results by the AD group a user belongs to. For example. User A belongs to AD group 'group1'. In the external data that ...
0
votes
0answers
126 views

Access powershell variable in next command- Can not convert the value of type “System.String” to type xxx

How to execute both commands in powershell. I get below error. I want to access $ Db in next powershell command. $ Db = Get-SPBusinessDataCatalogThrottleConfig-Scope ThrottleType Items ...
0
votes
0answers
533 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
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 ...
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
550 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
0answers
102 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
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 ...
0
votes
0answers
86 views

Auto-generated code for “Using”, “SQLConnection”, “ReadItem”, “ReadList” methods

I am beginner in SharePoint 2010 development. and doing following lab: Module 6: Accessing external data with Business Connectivity Services in SharePoint 2010 ...
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 ...
0
votes
0answers
222 views

Enterprise - External Task List - Connect to Outlook- setting Assigned To

I've got an External List coming from an External Content Type which has Office Item Type of "Task". It comes from an external system which has its own concept of a task, and I'm pulling them into ...