Business Connectivity Services

learn more… | top users | synonyms

1
vote
1answer
694 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
770 views

How to create an external list from an ECT using powershell

I have an External Content Type in my Metadata store and I want to create an external list using that ECT, using Powershell script. I tried to use $Web.Lists.Add() with SiteTemplate = "External ...
1
vote
1answer
464 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
705 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
vote
1answer
540 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) ...
2
votes
1answer
24 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
16 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 ...
2
votes
1answer
290 views

The operation(s) generations creates an SQL query which exceeds the length limit in Business Data Connectivity Metadata Store

I am trying to add a table from a SQL database as an external content type. When I do so I am getting the following error: The database table has 188 columns (I did not design this legacy system. I ...
2
votes
2answers
1k views

How to connect multiple external tables into one SharePoint list to perform CRUD operations

I am working with SharePoint 2013 and I have a requirement where I have to perform CRUD operations on multiple external tables (SQL Server) with SharePoint in one List and vice versa. I am able to ...
3
votes
1answer
2k 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. ...
1
vote
0answers
24 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 ...
0
votes
3answers
2k views

Update and Create Problem with Adding Columns to an Existing External Content Type in SharePoint 2010

I used SharePoint Designer 2010 to create an external content type (ECT) that consumes and writes data to SQL Server. [Went through the process of connecting to a database table, then right-clicking ...
1
vote
1answer
20 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
94 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
20 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
12 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
38 views

JS Link on External list views (BCS)

How can I apply SharePoint Client Side rendering (JSLink) on an external List?
1
vote
2answers
27 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 ...
0
votes
1answer
18 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 ...
2
votes
0answers
252 views

Custom BCS indexing connector with changelog inremental crawl is not working properly

Custom BCS indexing connector with changelog inremental crawl is not working properly I am writing a custom indexing connector using changelog incremental crawl approach. I'm using sample from ...
2
votes
2answers
27 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 ...
10
votes
7answers
21k views

How to sync a SQL database with a SharePoint List?

I need to sync an already existing SQL Database to a SharePoint 2010 list. Two way sync would be great but one way sync is also alright. Any documentation in this regard would be of a great help. ...
0
votes
0answers
13 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 ...
1
vote
2answers
3k views

Access denied by Business Data Connectivity on Setting Metadata Store Permissions

When I try to configure Metadata Store Permissions I keep getting this error I am the Farm Administrator and have full access on Sharepoint to start with. Now as I drilled down further looking at ...
0
votes
0answers
47 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
91 views

BCS Managed Client Code Get all method instances

When using the class Microsoft.BusinessData.MetadataModel.Entity entity; does anyone know how to get all the External Content type operation method instances so i can dynamically pass the value to ...
0
votes
0answers
19 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
62 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 ...
0
votes
0answers
35 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
20 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 ...
1
vote
1answer
212 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
137 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
29 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, ...
0
votes
1answer
27 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 ...
1
vote
1answer
27 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
0answers
16 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
21 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.
0
votes
1answer
1k views

There are no addresses available for this application. Business Data Connectivity

I can't get the new Business data Connectivity Service I've just created to work. It says that it started, and I proceed to an IISRESET as said in a lot of blogs, but it still doesn't work. Do you ...
0
votes
1answer
22 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
5 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
1answer
545 views

synchronize data from external list and SPList

How do we synchronize data from an external list (BCS) into a custom SharePoint list? I have tried using a timer job, but it did not help. Any ideas?
2
votes
3answers
930 views

SPTimer job and BCS External list

Business requirement - synchronize a table from external my sql database into SharePoint list. What I have done. I have an external MySql database which as LOB data. I have created a BCS ...
0
votes
0answers
46 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
61 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
180 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
28 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
1
vote
1answer
155 views

namespace on external content type

I have noticed that when moving BCS lists/external content types from my development computer to our production server, it keeps the namespace of my development computer. For example, all the ...
0
votes
0answers
30 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
2answers
83 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
1answer
144 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 ...