Business Connectivity Services

learn more… | top users | synonyms

0
votes
0answers
7 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 ...
3
votes
1answer
1k 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
4 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
27 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
33 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
13 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
573 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
405 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
1answer
15 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
19 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
15 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
18 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
899 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 ...
1
vote
1answer
615 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
18 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
537 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
903 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
18 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
44 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
94 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
19 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
108 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
81 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
20 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
58 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
19 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
65 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
1answer
450 views

Is it possible to link existing Sharepoint 2010 lists to SQL server databases?

I created a SQL server database and added a table to it. Then I used Sharepoint Designer 2010 to create an external Content Type using this table. Now I can alter the according Sharepoint list which ...
0
votes
2answers
45 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
30 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
0answers
49 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
46 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
80 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
51 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 ...
1
vote
1answer
749 views

403 Error connecting to ODATA via External Content Type with SharePoint

I have a tenant on SharePoint Online (the new 2013 version). In that tenant, I have a Project Online site collection. Project Online hosts a very nice OData endpoint at ...
0
votes
0answers
38 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
93 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 ...
0
votes
1answer
675 views

Cannot see BDC External system in SharePoint Designer Data Source Explorer

I have first created external content types in SharePoint Designer then exported the model to Visual Studio. I then deleted everything created in Designer and deployed the model through SharePoint ...
1
vote
0answers
21 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
1answer
146 views

Custom BCS Connector Incremental crawl not working with AssociationNavigator

I created a custom BCS connector in SharePoint 2013. I need to use the changelog approach for incremental crawling. Since I am crawling the file system like data source I am using AssociationNavigator ...
0
votes
0answers
46 views

Remove 'onmouseover' sorting options for Business Data List Webpart

I have a Business Data List webpart displayed in SharePoint. The data that comes into SharePoint is formatted as general, so the sorting doesn't work. It sorts based on the 'edit view' settings of the ...
0
votes
1answer
672 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
98 views

SharePoint 2010 - BCS secondary columns in viewedit.aspx

I was wondering if this has happened to anyone and if anyone can suggest a fix is. | SharePoint 2010 | Top level site | Administrator permissions I had a number of BCS connections to a document ...
0
votes
0answers
49 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
55 views

Problem While Deploying Business Data Connectivity Model Project in SP Foundation 2010 Installed in Windows 7 Professional 64 Bit

I had posted posted this question earlier in the day but moderators marked my question as Duplicate of BDC Deployment to Foundation but my question is specific to Windows 7 so I am re-posting. I have ...
5
votes
3answers
2k views

BCS External Content Type with 20,000+ items (O365)

We have a large database of 20,000+ items on a local database that we need to get into Sharepoint Online 2013 in O365 to use as metadata for various documents in multiple locations. New entries and ...
1
vote
1answer
326 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 ...
0
votes
0answers
123 views

Using BCS OTB webparts on Standard SharePoint 2013 License

According to MSDN http://technet.microsoft.com/en-us/library/415c9536-ae70-4d4b-b481-5255cb03cc32#bkmk_Developeravailability in a Standard SharePoint 2013 licensed CAL I should have the "BCS:Business ...
0
votes
2answers
38 views

Search 2013 - is there any way to index a list of URLs stored in a database?

I have a database table with a list of URLs that I would like Sharepoint Search 2013 to index so they show up in search results - the URLs are a mixture of content types - web pages, Word documents, ...