Business Connectivity Services

learn more… | top users | synonyms

2
votes
1answer
2k views

External list with friendly display names for columns

I have an external content type that I'm accessing through a .NET assembly. So I created a BDC model with Type="DotNetAssembly" (for now with just finder and specific finder operations). It works, ...
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
2answers
687 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
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
970 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
0answers
11 views

Create ECT using Nested SQL Store Procedure

I'm creating ECT in SharePoint O365 using SP Designer. I'm defining the operations using Store Procedure. My Read List Store Procedure some thing like below: CREATE PROCEDURE [dbo].[...
0
votes
1answer
225 views

external content type

We are a tenant in a larger SharePoint setup. I have tenant admin rights. As a test I would like to create a list that originates from a SQL table. I followed this guide: http://www.sharepoint....
0
votes
1answer
94 views

Displaying error in External List

I've an external list. I've to add a new item to the list (insert a record in the db) based on some conditions. Failing to meet those condition I must not allow the creation of object. I've thrown an ...
1
vote
4answers
2k views

BDC to BCS Application Definition Upgrade

I'm trying to perform an upgrade of a SharePoint 2007 environment to 2010. Our plan is to move to entirely new hardware and do a content database migration. In such a scenario, it seems that BDC ...
0
votes
1answer
715 views

The remote server returned an error: (407) Proxy Authentication Required.- BCS

We are trying to Consume OData in BCS using an App External Content Type. The OData service that we used is http://services.odata.org/V3/Northwind/Northwind.svc We followed this to create app ...
0
votes
1answer
757 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 ...
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. ...
0
votes
0answers
18 views

SharePoint 2013 BCS identity delegation with kerberos and claims

I have a question about the BCS and having it successfully pass through the current users' identity to a SQL database whilst using Claims and Kerberos. I've read a lot of contradictory information ...
0
votes
2answers
55 views

Parameters not passed to BCS External List via REST API

I have two external lists connected via external content types which are connected to stored procedures in SQL Server. I believe I have them set up identically (though evidently not because one is not ...
0
votes
0answers
13 views

How to query data thats coming from BCS connections in SharePoint customised forms

I need to create a SharePoint customized form with data that send data back and forth to external database(SQL 2014). I can do this, with Provider Hosted Apps. But i would like to create a farm ...
2
votes
1answer
2k views

External Content Type Search not returning results

I have configured my 2010 External Content Type for search by adding the RootFinder property to the ReadList method. I have also added the ShowInSearchUI property to the LOB entry. I then set up my ...
0
votes
1answer
38 views

How to add External Content type To custom SharePoint list?

We have a requirement Creating External Content type in sharpoint 2013 based on that SQL database Table. For example in sql i have four database(db1,db2,db3,db4) and sharepoint i have 4 custom list(...
0
votes
1answer
32 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 ...
1
vote
1answer
29 views

Pull data from SharePoint On-Premises to SharePoint Online

I would like to pull data from SharePoint On-Premise (Custom List Data) to SharePoint Online. When searched on Internet most of the posts are suggesting like SQL Azure Connectivity between SharePoint ...
0
votes
2answers
2k views

Unable to display this Web Part. BCS SP2010 [duplicate]

I am trying to get data form SqlServer2008 in SP2010 with the hep of BCS. I have created External List Successfully,but when I go to my Site I get following error: Unable to display this Web Part. To ...
0
votes
2answers
4k views

Error with External Content Type List: “Unable to display this web part”

I have deployed an external content type to my local Sharepoint 2010 Server using a Visual Studio solution. The deployment appears to work. I can view the details of the content part in the central ...
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 ...
1
vote
0answers
14 views

Integrating Sharepoint with Dynamic CRM using K2 SmartObject Services [closed]

I want to Synchronize Microsoft Dynamic CRM with Sharepoint List, so that all the account's will be exported to sharepoint list. Can i do it with the help of K2 SmartObject Services.?
0
votes
1answer
54 views

Connecting Microsoft Dynamics CRM 2013 and Sharepoint 2013 Online using BCS

I want to connect SharePoint 2013 Online with Microsoft Dynamics CRM Online using BCS(Two way). Two way meaning is that When I have 100 account's (customers) in CRM I want to export these account's ...
2
votes
1answer
22 views

What happens to External List created using BCS from SQL query once the server goes offline?

If the database gets deleted or somehow goes offline, will the list keep the existing data or will it all be gone due to failed synchronization.
0
votes
1answer
32 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 ...
1
vote
1answer
1k views

Connect ECT to SharePoint List in InfoPath?

I'm trying to create a list in Infopath 2010. I'd like one of the fields to be a drop down list that connects to an external content type list. It doesn't show any of the External Content Type Lists ...
0
votes
0answers
22 views

InfoPath doesn't publish templates for an External List

I created an external list on my site by using Business Connectivity Services. It works properly. I'd like to use InfoPath forms instead of SharePoint default. I modified InfoPath form. When I ...
0
votes
0answers
13 views

Filter external content type search result by site

How to filter external content type search result by site in SharePoint using a query string value?
1
vote
1answer
28 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 ...
0
votes
2answers
681 views

Workflow to read data from external list

I have just recently started working with external lists using BDC and was quite surprised to discover that I can’t really interact with the data in any way using SharePoint 2013 workflows (Even just ...
0
votes
0answers
27 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
40 views

Web Part connection on external list form

I added an External Content Type (from WCF service) with Read List and Read Item operations defined. I created an External List based on this Content Type. I would like to display a Web Part on the ...
0
votes
1answer
76 views

use external liste error :Oracle database TNS The value's length for key 'data source' exceeds it's limit of '128'

I have created xml model for external list using bcs this is the code example for my BDCM model: <?xml version="1.0" encoding="utf-8" standalone="yes"?> <Model xmlns="http://schemas....
1
vote
1answer
289 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, ...
0
votes
1answer
113 views

BCS UserProfile Sync to Oracle not working after upgrade from Oracle 10 to Oracle 11

I am experiencing problems with a BDC connection to Oracle. I am using SharePoint 2013. The database I am connecting to is moved to a new Oracle 11 server. It was Oracle 10. I use this connection to ...
2
votes
3answers
8k views

How do you enable connect to outlook on external list?

I am very new to sharepoint, its about day 3 of working with it, and I am having a problem getting Connect to outlook working on external lists. The menu item is greyed out. In my external contact ...
1
vote
1answer
41 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 ...
0
votes
0answers
14 views

Value from Oracle BCS not visible in user property

I am working on the same issue as Danny at BCS UserProfile Sync to Oracle not working after upgrade from Oracle 10 to Oracle 11. However, since the issue has progressed, we now run into a problem ...
1
vote
0answers
19 views

How to implement Update/Delete operations using Business Data Web part

I have created a web part page for displaying the contents of my external list with a Filter parameter. I'm using a Business Data List Web part for this. I need to have Update/Delete operations for ...
0
votes
0answers
28 views

Getting BCS type list with REST

I'm trying to get a BCS type list with JSOM in angular app. My externl list is MyCoustomers and External content type for this list is CTBCSDemo. External content type is connected to SQL Azure with ...
1
vote
2answers
104 views

BCS, can I connect a result of SQL query to external database in SharePoint list?

Can I connect a result of SQL query to external database in SharePoint list? As I understand - External Content types could map only one table for list, but I need to get some combined data from few ...
0
votes
0answers
56 views

SPD 2013, Adding external data source - “Data source file cannot be saved” error

I have two machines - one with SQL 200 R2 and other with sharepoint 2013. BCS persists in Service Applications. Adding source from remote machine I get "Data source file cannot be saved" message. I'm ...
1
vote
0answers
72 views

BCS REST Performance Issues

So we're migrating from On-Prem 2010 to Office 365 and I need to convert some of our simple calendar webparts to online solutions. I've setup an External Content Type in 365 using SharePoint Designer....
0
votes
0answers
38 views

Raise limit on Database Connector and BCS in SharePoint Online

I have found a way to increase the limit for on-premise SharePoint, but is there any way to increase the 2000-row limit on the Database Connector for SharePoint Online? I am connecting an external ...
1
vote
2answers
570 views

How to do a Filter in a BCS External Data picker

I am using an OData web service with BCS (testing with Northwind) and I would like to define some filters when using the External Data picker. I'd like to be able to have a drop down that then ...
3
votes
1answer
6k views

CAML and External List - pass parameter to ReadList (finder) method

I have a Finder method defined on an External Content type (created with Visual Studio). Whan That method receives a parameter. So the method is something like ReadList(string partnerName). I have ...
0
votes
0answers
38 views

Use BCS to Connect to Access Database Stored in a Document Library

If I copy an Access database file into a document library (I presume this is possible), can I set up a Business Connectivity Services connection to it (within the same site) so I can manage the tables ...
0
votes
0answers
39 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 ...
3
votes
0answers
39 views

create custom BCS connector

What are the steps to create a custom bcs connector? I have a ftp location where the data gets updated every week. So I want to write a bcs connector which will connect to data source with the ...