Business Connectivity Services

learn more… | top users | synonyms

1
vote
1answer
12 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
9 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
21 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
77 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
33 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
15 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
15 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
18 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
19 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
37 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
24 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
87 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
31 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
29 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
17 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
68 views

JS Link on External list views (BCS)

How can I apply SharePoint Client Side rendering (JSLink) on an external List?
0
votes
1answer
30 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
33 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 ...
2
votes
2answers
29 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
15 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
26 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
56 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
34 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 ...
0
votes
1answer
52 views

Export(or map) List data to external MSSQL table

There is much information about External Lists - when You make a Sharepoint list from SQL database table. In my case I need reverse operation - I have list, and want to map it to external SQL table, ...
1
vote
1answer
491 views

External Content Types are not available. Contact your system administrator - BCS - User profile sync

I'm trying to setup a BCS connection from a SQL view -> user profile properties. I've created the external content type and got the right view. I also set the "set object permission", checked all ...
0
votes
1answer
265 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 ...
0
votes
1answer
35 views

How to prioritize BCS content at the top of search results?

I have a requirement in a SharePoint 2013 environment to push all BCS items to the top of the search results. I have played with the weight/context groups as well as result source sorting, but have ...
0
votes
0answers
18 views

FInish button is not getting Enabled

I am working with BCS External Content types. When I am setting up the filter the "Finish" button is not getting Enabled. Please suggest a solution
0
votes
1answer
22 views

Sharepoint 2013 BCS Connectivity

I have created a BCS Service but as I am clicking on it, this is giving me error.. please tell me what is the problem and how to trace it.
1
vote
1answer
28 views

External content types in sharepoint

I have an external list based webpart with 5 wild card filters. when I searched using one filter the required item is displayed but the same item is not displayed using other filter. For example if an ...
0
votes
1answer
31 views

My site and properties from external sources

We have an on premise SharePoint 2013 farm. In setting up mysite, we will only retrieve username and picture from AD, all other properies for profiles we need to get from another database that is ...
0
votes
0answers
8 views

Display some data collected from external sources to external customers?

we're looking the way how to display some data collected from external sources in SP to external customers. We have the list of projects handled in SQL. Every project has own number, name and status ...
0
votes
0answers
74 views

BCS OData navigation properties are not shown in SharePoint Hosted App external list

I have created a WCF Data Service that is hosted on Azure. I use this service as the data source for my SharePoint Hosted App's external lists. I noticed I was missing all navigation properties from ...
0
votes
0answers
76 views

Displaying User Profile Data Pulled into Custom Properties from BCS on People Search Results

I am currently pulling some data from a BCS connection to populate custom properties on my user profiles. I know that piece is working since I am able to look up a user in CA, Application Management ...
0
votes
0answers
39 views

Connect to excel external data source using BCS

I want to know the steps of connecting to excel external data source. I have done using Connect With SQL External Data Source Now i want to know how can i connect to excel external data source
0
votes
0answers
47 views

Urgent: Unable to update BCS external data in a Large List (5000+ items)

URGENT: Question regarding BCS and large lists (5000+ items) I have a document library in SharePoint Online that has more than 5000 items. (I'm well aware of the limitations and steps to prepare for ...
0
votes
0answers
69 views

How to read Odata service(created for SAP LOB) response which is a entity query set and expects filter parameters, in SharePoint BCS code?

I am performing DUET development where in the requirement is to read collection of data(attachments in SAP) is published over OData service by Gateway development. It is filtering based on 3 ...
0
votes
1answer
225 views

Business Data Connectivity: error when saving External Content Type due to invalid assembly or codebase

I am trying to create an external content type that will be connected to a SOAP webservice using SharePoint Designer. To do this, I added a WCF Connection in the Operation Designer section with the ...
0
votes
0answers
56 views

Search Refiners Error When mixing Refiners of different sources

I have a lot of content sources all from the same kind of sources with the same kind of managed properties I created a new content source based on a BCS connection to a local SQL server database, ...
0
votes
2answers
99 views

SharePoint SQL Reporting

how can I do a simple report on SharePoint 13? (reading data by a SQL Server). Is there a way to put the data directly into a list? I heard about BDC how does it work? Thanks
0
votes
0answers
124 views

create a BCS External Content Type based on a WCF web Service using Visual Studio.

How to create a BCS External Content Type or list Based on a WCF Web Service using Visual Studio. The link provided shows the requirement through Designer. ...
0
votes
0answers
113 views

BDC: cannot logon with credentials obtained from secure store provider

Hmm.. When I manually create a new contentsource, point it to the single sql database-bcs everything works OK (no probs) (via Central Admin) but... When i try the same via a powershell script I get ...
0
votes
0answers
266 views

Sharepoint Online External Content Types WCF Service

I have this issue I can't find solution for a couple of days now as I am working on creating External Content Types for Sharepoint Online 2013 (trial period will expire in the next 5 days :( ). I ...
0
votes
0answers
146 views

How to retrieve BDC Identity from External List programmatically?

I need to do a lookup on an External List (in SharePoint Online - Office 365) to retrieve the value of the BDC Identity. BCS is talking to an OData web service. (I'm not a Visual Studio guy), so ...
2
votes
0answers
92 views

Unable to Refresh BCS External Data

I am running into a refresh issue with BCS. Whenever I hit the little refresh button in the UI, I am repeatedly getting this error. I am using an OData web service for BCS with WindowsCredentials ...
0
votes
0answers
105 views

Custom BCS External Content Type Error handling

Using SharePoint 2013. I have created a custom BCS model (bdcm with custom assembly deployed to GAC) to create external content types to connect to an proprietary external data source. I have created ...
1
vote
1answer
237 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 ...
1
vote
0answers
27 views

Keep SQL Connection Alive during ReadItem

Is there any way to keep a connection open during the ReadItem process or is there a best practice around this? Basically if i'm calling ReadItem in BCS 100K times, how can I streamline that ...
0
votes
2answers
127 views

SharePoint Online BCS list from Azure SQL - to whom do I open the firewall?

I've been asked to set up a list on SharePoint Online that's populated from an Azure SQL database via BCS. I have found some fairly extensive guides on how to do this, such as this one: ...
0
votes
0answers
65 views

Filter BCS Data by Users AD Group

I'd like to know if it is possible (and if so, how) to filter the BCS data results by the AD group a user belongs to. For example. User A belongs to AD group 'group1'. In the external data that ...