Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Business Data Connectivity (BDC) service is the new version of the Business Data Catalog that was provided in Microsoft Office SharePoint Server 2007.

0
votes
1answer
82 views

unable to obtain master key error in secure store service application

We have recently migrated the SharePoint 2010 services to SharePoint 2016 using standard Microsoft SharePoint recommendations like content database backup and restore model. As part of it, we have ...
0
votes
0answers
18 views

Refresh External Data failed: do not have permissions on the External Content Type

We have an external content type in SharePoint 2016. We have created the "External Data" type column using this external content type. Now, when we are trying to refresh the External Data from the ...
0
votes
0answers
15 views

Search Trimmer changes between 2013 and 2016

I have a Bdc connector and associated security trimmer that worked fine with SharePoint 2013. On SharePoint 2016, the Bdc connector still works and the content is crawled. But when a user runs a ...
0
votes
1answer
65 views

Very slow external list based on SQL Server

I am using SharePoint 2016 on premises. This is a new farm with installation done just now. I created BDC to fetch data from SQL Server view. That view contain less than 8000 records. Then I created ...
0
votes
0answers
87 views

Using External Content Type/BCS in SharePoint Online

In SharePoint Online, I'm exploring External content type for displaying a list from a site collection on a different site collection. Using SP Designer 2013, I'm trying to create a External content ...
1
vote
0answers
82 views

Business data connectivity metadata store is currently unavailable

When I tried to add External Content Type via sp designer, I got following error "business data connectivity metadata store is currently unavailable". sp2013. I've tried many common solutions, ...
1
vote
1answer
43 views

Sharepoint 2013 search no result anonymous user use term with double quotes

I am using SharePoint 2013 search that The content come from an external content source -via BDC connectivity -using Hebrew text. My problem start when the anonymous user search text with double ...
2
votes
0answers
30 views

Business Data Connectivity choice does not appear in Type dropdown on the Create New Connection page

This is in SharePoint 2016 Enterprise, I am logged into Central Admin with the farm admin account. Trying to get a Business Data Connectivity working. I've created an application in the Secure Store, ...
1
vote
1answer
86 views

External List shows only BDC Identity

I have created an external list called Employees. When I go to site contents, I see Employees and when I click it, I see the exact contents I expect. When I create a new page for my site and insert ...
0
votes
1answer
83 views

SharePoint 2013 custom search connector fails after patch

We have a custom search connector that we built to make documents from another system searchable from SharePoint. This worked fine for a year until we decided to add a CU(October 2015 uber). The ...
0
votes
1answer
40 views

One profile not syncing with BDC

Somehow a user was created in AD and synced in UPS, the user had a username something like domain\xxx1. The user was then deleted in AD and a new one with the same email/sip was created but with the ...
0
votes
1answer
169 views

BCS external content type ReadList fails with InvalidMetadataObjectException

I have create a BDC model with a .Net assembly linking to a LOB system. Checking the model in Visual Studio is all good. I upload the solution to SharePoint 2013 Enterprise and create a new external ...
2
votes
0answers
17 views

Dynamic Queries for SharePoint BDC in Visual Studio

I've created a BCS in Visual Studio to Get Oracle Information, how to perform dynamic Configurations for the queries?
1
vote
0answers
65 views

BDC Incremental crawl always crawls full

I added External Content Type to my BCD application. The content type gets data from SAP trough a service. There is a column/property in the service called PartnerChangeDate, that is set to last ...
0
votes
1answer
34 views

Connecting to external data sources like sql database and exchange

I am looking for the best options on connecting my SharePoint list with external data sources like SQL database and exchange servers to update the contacts list automatically. I am using SharePoint ...
1
vote
0answers
153 views

Fill in External Item Picker (BDC) with query string value with InfoPath

We are trying to customize a 'new' form with InfoPath so that our query string value (idPatient) is automatically filled in into the External Item Picker (BDC entity). In InfoPath, we have set up the ...
-1
votes
1answer
310 views

User Profiles - Merge BCS with AD Sync Data

Preface: Yes, I've read many, many articles related to each aspect of this issue, but still welcome any references. Problem: I'm unable to merge BCS (SQL connection) data with user profiles pulled ...
0
votes
0answers
80 views

External Content type: Cannot connect to the lobSystem

So i have BDC activated on my sharepoint app. And i would like to create external content types based on tables from my local database. It's a sql database and when i'm trying to add a connection to ...
0
votes
3answers
3k views

Query String Parameter pass to Data Source Filters in External List (BDC)

Can you please guide me how to pass the Query String Parameters to Data source Fiters in external list? I have created external list based on external content type. External content type has three ...
2
votes
1answer
3k views

Error while crawling LOB contents SharePoint BDC

I have configured BDC in SharePoint. I am able to get data in my external list. I need this data in search too. So I created another content source for BDC. Now when I crawl this content source, it ...
3
votes
0answers
95 views

BDC: Decimal field with comma separator

Sorry for my English. I'm in despair. I created external content type from table. I created external list. Decimal field with comma ( thousand separator ) from external list saved wrong to data base. ...
1
vote
0answers
50 views

Business Data Connectivity entity namespace purpose

I've noticed that my BDC's entity namespace is a SharePoint website url. I have recently imported successfully our BDC during a SharePoint migration, and the namespace remains the same on the new ...
1
vote
0answers
35 views

Error in creating external content type list

When I want to create a SharePoint list from external content type on a client machine and when I click on "Select External Content Type", I am getting following error. The error does not happen, when ...
2
votes
0answers
410 views

How to correctly update specific columns in an external database through an ECT?

Here is the scenario: I have an External Content Type based on a specific table in an external DB. The table itself has 33 columns, my ECT exposes a total of 13 of those columns, 7 as read-only and ...
1
vote
0answers
155 views

BDC update operation fails with socket exception

I have set up an external content type in my BDC Service, and I am using the Secure Store Service to provide the database credentials. In the ECT I have set up Read Item, Read List, and Update Item ...
0
votes
1answer
1k views

Access denied to Business Data Connectivity

User is trying to create external content types using SQL Server, using sharepoint designer. I as an SharePoint Administrator i can login without any issue but this user who is dbo of remote sql ...
1
vote
1answer
508 views

Business Data Connectivity Service Application Stuck in “Stopping” State

My existing BDC service application is not working and it is giving below error in log when i am accessing it: The BDC Service application Business Data Connectivity Service is not accessible. The ...
2
votes
0answers
500 views

Migrate external content types from 2010 to 2013

I have done a test 2010 -> 2013 migration and most things work fine. I have some user profile property mappings to BDC models I have restored the secure store, managed metadata, BDC services using ...
3
votes
3answers
12k views

Create External Content Type - Access denied by Business Data Connectivity

Following the technet articles on how to get external data into SharePoint 2013 (for testing purposes) I've created: Business Data Connectivity Service with Metadata Store Permissions Secure Store ...
0
votes
1answer
78 views

Export BDC in 2010 and import in 2013

Can I export a BDC in SP2010 and import and use it in SP2013?
0
votes
1answer
395 views

External content type: bdc identity

I have a list with an external content type. For 3 items, I have the same bdc identity. How is it possible? Is not bdc identity suppose to be unique?
1
vote
0answers
243 views

I have a list built on external content using bdc with a custom filter, I get the data but not the filter

SPD 2013, SP Enterprise 2013, SQL 2008 So I have a BDC connector setup with a SQL backend, I then built a Exernal Content List off that. I then inserted a content control webpart and inserted some ...
0
votes
1answer
435 views

Using External Content Type to display XML file data as Contacts list

My client has a contacts list in some other system and this data needs to be displayed in SharePoint as a Contacts list. This external system can provide an xml periodically with the contacts data. ...
0
votes
0answers
512 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 ...
2
votes
1answer
281 views

Sharepoint 2013 - OData Endpoint against External List - Supply Input Parameters

I have an external list in SharePoint 2013 that uses a filter (called idcode, say). I can supply the filter value in the "Modify View" UI of the site and it works as expected, but my ultimate aim ...
1
vote
1answer
82 views

How to handle DeleteItem in external list

We have an external list bound to data source by the WCF service. It displays a metadata of "tasks", and for every "tasks" we have in another document Library a special folder. When user selects 'edit'...
0
votes
2answers
105 views

Search 2013 - is there any way to index a list of URLs stored in a database?

I have a database table with a list of URLs that I would like Sharepoint Search 2013 to index so they show up in search results - the URLs are a mixture of content types - web pages, Word documents, ...
1
vote
0answers
19 views

BDC service not working [duplicate]

So I had to switch SharePoint from one server to another. Our network guy installed SharePoint onto a new server and I backed up and uploaded my stuff into the new server (with the same name as the ...
2
votes
0answers
83 views

Updated external content type but connection not updated in central admin

I have an external content type for a sql server view, all working well. I add a new field to the view and save (SPD), in central admin I go to BDC and click on the content type - I can see the added ...
0
votes
1answer
129 views

Customizing details page link in BCS list or custom details page redirection with SarePoint 2013

I'm having fun with Sharepoint 2013 and studio 2013, just started dev few months ago -) I have some external lists pointing to external content type, I would like to redirect to a custom detail page ...
0
votes
1answer
161 views

Send extra parameter(s) in BCS/BDC-call to WCF-service

Ok, this question got lengthy, but I wanted to give all details, actual question is in bold below. I have defined an External content type, let's call it ExternalCustomer. I use an ExternalCustomer-...
1
vote
0answers
266 views

2013 BCS in Designer: data source objects do not exist

We've inherited an SP2013 solution, which had previously been upgraded from SP2007. The BDC service was converted as well, and appears to be working in most respects - external lists, external ...
1
vote
0answers
136 views

Import Sharepoint 2010 BDCM file in a SharePoint 2013 environment

I was wondering if it's possible to import a BDCM file exported from SharePoint 2010 in a Sharepoint 2013 environment ? Is the file format identical ? Thank you
0
votes
3answers
253 views

BDC Deployment to Foundation

I was able to successfully develop and test a BDC model developed in visual studio 2010. It was developed on a server using SharePoint Server 2010. I tried deploying the solution to our SharePoint ...
0
votes
0answers
252 views

Export bdc data to excel in sharepoint

I have an External content type that I called it as bdc/bcs webpart with 2 (or more) filters with a stored procedure behind that. How can I export a result (one or more results) view of bdc to an ...
0
votes
0answers
1k views

External list - Access denied by Business Data Connectivity - Cannot add permissions

I created an external list, and got the "Access denied by Business Data Connectivity" error. So I tried to fix it by adding permissions on BDC Service, according to google, this is exactly what I have ...
0
votes
0answers
84 views

Edit row information using BDC

I want to make simple database table insert/edit/delete using BDC. What I have tried: I have created External Content type mapped to database table and using external content type created list. But ...
0
votes
2answers
702 views

Custom BCS Connector Incremental crawl not working with AssociationNavigator

I created a custom BCS connector in SharePoint 2013. I need to use the changelog approach for incremental crawling. Since I am crawling the file system like data source I am using AssociationNavigator ...
1
vote
0answers
47 views

How to change SQL Authentication to Windows Authentication in BDC Sharepoint 2007

Sharepoint 2007 Created a BDC Access SQL Server as following Authentication Mode: Passthrough DBACcessProvider: sqlserver Integrated Security: empty User Name: username Password: password This is ...
0
votes
1answer
271 views

BDC Model is not visible in Central Administration site

I am new to SharePoint 2013. I have created a BDC model using Visual Studio 2012 and deployed in SharePoint 2013. Deployed Solution is visible in Central Admin site and it is activated too. But when I ...