Business Connectivity Services

learn more… | top users | synonyms

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
21 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
10 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
731 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 ...
0
votes
1answer
26 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 ...
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
646 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 ...
2
votes
1answer
16 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
617 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 ...
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 ...
-1
votes
0answers
16 views

can we scope external content type to site collection level?

I have some content type in web application , now i want to create a list based on that content type in different site collection ,but when i selecting external list in add an app the external content ...
1
vote
1answer
939 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
20 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
18 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 ...
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
0answers
11 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
21 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
414 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
23 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
27 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
47 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
281 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
89 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
34 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
12 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
16 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
65 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
36 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
52 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
28 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
521 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
18 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
33 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
36 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
25 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
29 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
26 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 ...
2
votes
1answer
71 views

Provider Hosted App vs BCS

I'm new to Office 365/2013 but I've been working with on-prem SharePoint 2007/2010 for a while. I've mostly setup some simple webparts to pull data out of SQL/WCF and display it. I'm wondering what ...
0
votes
0answers
89 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 ...
1
vote
0answers
15 views

How to tell an ECT developed in VS to use credentials from Secure Store Service?

I am trying to develop an External Content Type using Visual Studio so I can use External Data Source columns in a SharePoint list. Most of the stuff I am finding online uses Designer, but I don't ...
0
votes
1answer
14 views

External List from SharePoint 2010

I want to know can we create an external list for SharePoint Online from SharePoint 2010 list as a source. ?
0
votes
2answers
43 views

Query on BCS list

I need to retrieve the items of BCS based list. I am using the server side object model on SP2013 and I am getting this error: An error occurred while enumerating through a collection: The shim ...
0
votes
1answer
278 views

Export(or map) List data to external MSSQL table

There are many references about External Lists, where you make a Sharepoint list from SQL database table. In my case, I need to do the opposite - I have SharePoint list, and I want to map it to an ...