Business Connectivity Services

learn more… | top users | synonyms

0
votes
1answer
665 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
745 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. ...
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 ...
0
votes
0answers
14 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 ...
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) ...
0
votes
2answers
31 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
10 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 ...
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 ...
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
31 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 ...
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 ...
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
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
12 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
40 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
19 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
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 ...
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
19 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
12 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
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 ...
0
votes
2answers
539 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
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
33 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
61 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 ...
1
vote
1answer
284 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
97 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
7k 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
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 ...
0
votes
0answers
13 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
17 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
24 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
74 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
49 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
62 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 ...
0
votes
0answers
33 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
543 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
24 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
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 ...
3
votes
0answers
37 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 ...
1
vote
0answers
26 views

Error while connecting an External Content Type

In Sharepoint 2013, I am trying to create an External Content Type, and use a connection to a SQL Server. In Sharepoint Designer when I am in the wizard to create an ECT, I'm having trouble creating ...
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
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
0answers
38 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 ...