Business Connectivity Services

learn more… | top users | synonyms

0
votes
0answers
8 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
12 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
16 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
37 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
20 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
38 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
19 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
12 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
45 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
29 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
32 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
21 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
18 views

External ContentType to a public JSON feed

I had expected it to be easy to link to an external JSON feed by now (last time I did BCS was with SP2007) but SharePoint Designer (I don't master VS) only has: What would be the easiest solution ...
0
votes
0answers
9 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
9 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
16 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
23 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
1answer
158 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
52 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
45 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
39 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
19 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
74 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
213 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
10 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
91 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
14 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
53 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
89 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
62 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
19 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
26 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
38 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
22 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
47 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
37 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 ...
1
vote
0answers
159 views

BDC types not coming up as crawled properties in SharePoint 2013 search

I am trying to setup search in my SharePoint 2013 site, using BCS, connecting to a .Net assembly which is exposing the types. The first time I deployed the solution, the exposed types came up as ...
1
vote
1answer
45 views

Crawled properties missing for Business Data source

We've implemented and crawled a Business Data Connectivity Service data source. I can find the items based on the values in their fields, but when I look at Crawled Properties, there is only the ...
0
votes
0answers
34 views

Can I use SharePoint 2013 BCS to connect to external OAuth service?

Can I use SharePoint 2013 BCS to connect to external OAuth service and read the data form that service? Please provide a reference or an article.
0
votes
0answers
31 views

Creating External Content Type List with lookup/dropdown column

How to create an External Content Type list (BCS using SPD) with a dropdown control (column name = Products) Then the contents/choices of the product is also from a table in the database.
0
votes
0answers
108 views

JS Link on External list views (BCS)

How can I apply SharePoint Client Side rendering (JSLink) on an external List?
0
votes
1answer
55 views

How is Secure Store Service storing passwords under the hood?

When Business Connectivity Services need to access external data which requires per-user authentication, it uses Secure Store Service to store the user password in order to avoid asking for it again ...
1
vote
2answers
37 views

Using External Data in SharePoint 2013

Hi i am new to SharePoint, i have been given a requirement and i am not able to find the right approach. We have a SharePoint portal which keeps track of employees details, very recently we have ...
1
vote
2answers
33 views

Service instance quantity

On a clean farm (one WFE\APP server and one back-end (SQL)) after installing SharePoint binaries i ran some configuration scripts. One of them contains command Install-SPSerivce which, according to ...
0
votes
0answers
18 views

Can SharePoint user login to another system and display the information at Sharepoint?

We have a SP2013 on-premise farm and another self-written web application. The web application have its login member database and is written by Java. User would like to add a login box on SharePoint ...
0
votes
0answers
34 views

Updating External List via Workflow - Columns Missing

I have a BCS model that I've created a list instance in SharePoint off of and I'm using a workflow to copy over some values. Everything works great, except the identifier is not showing up as a field ...
0
votes
0answers
103 views

How do I get this field in the External List(ECT->BCS->SQL) to show up in SharePoint Designer Workflow?

I have created an External Content Type that has CRUD rights to SQL tables. Off that External Content type I have created an External List. I have a document library that has an InfoPath form on it ...
1
vote
0answers
50 views

Select Default Filter in BDCM File

When working with Business Connectivity Services (BCS) and Business Data Connectivity Model (BDCM) files, does anyone know in the code where to set the "default" Filter and hide the option? Right ...