Business Connectivity Services

learn more… | top users | synonyms

0
votes
1answer
11 views

Pull Data from SharePoint on premises to SharePoint online

I would like to pull Data from SharePoint On-Premises(Custom List Data's) to SharePoint online.when searched in internet most of the posts are suggesting like SQL Azure Connectivity between SharePoint ...
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
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 ...
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.
-1
votes
0answers
17 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 ...
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 ...
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 ...
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
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
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
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
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
53 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 ...
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
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 ...
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
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 ...
0
votes
1answer
30 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
2answers
416 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 ...
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
90 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
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 ...
1
vote
0answers
78 views

Using a InterSystem Caché database in SharePoint? [closed]

I have searched for any kind of database compatible with SharePoint and at this point I haven't found anything. I've searched on google and msdn. Google gave me this only thread about my question : ...
5
votes
1answer
293 views

Problems trying to retrieve logs from a Correlation Id

I have a correlation id for an error that an external list has been throwing which I need to view the ULS log entries for. I've connected to the site in SharePoint Online Management Shell using ...
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 ...
1
vote
1answer
164 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 ...
0
votes
0answers
18 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 ...
1
vote
0answers
55 views

Sharepoint 2013 accessing external list in workflows

I have created an external list using WCF connections. I have in that list all the information that I need. Now I need to access that data from another list workflow(sharepoint 2013 platform ...
1
vote
1answer
95 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 ...
0
votes
0answers
70 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
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 ...
1
vote
0answers
35 views

After importing, src attribute is removed from img tag [closed]

This is SP2010. I am using BCS and an external list to read in HTML from a non-SharePoint CMS. The HTML includes typical rich-text content, including images. Looking at the external list text, I can ...
0
votes
0answers
54 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 ...
2
votes
1answer
54 views

SharePoint - reporting data from SQL

We have got a time tracker website in ASP.NET which is used by employees to record their daily time and work. The data is huge (about 10 years of data and ongoing) and stored in the SQL database. We ...
0
votes
0answers
42 views

Business Connectivity Services DateTime formatting

I have a SQL Server database with a number of columns of type Date. I have used BCS to create External Content Types in SharePoint 2013 for the tables in my database. However when a view these content ...