Business Connectivity Services

learn more… | top users | synonyms

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. ...
0
votes
1answer
23 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
485 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 ...
0
votes
1answer
351 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
28 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
1
vote
1answer
520 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
0answers
12 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
19 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
17 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
61 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
44 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
40 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
702 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
24 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
56 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
649 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
20 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
32 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
120 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
35 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
642 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
88 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
40 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
41 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
203 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
103 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
34 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, ...
0
votes
1answer
70 views

External Content Type List as Lookup in SharePoint Online

I am working on a solution that will get data from a web service (third party) and create a list in SharePoint Online (Office 365 E3 subscription). Then use a column from that list as a lookup column ...
0
votes
0answers
43 views

Making consolidated lists in SharePoint 2010

I'm currently running into problems trying to create a view of consolidated lists on SharePoint. I'm trying to create a view on a main site to display a consolidated list comprised of a number of ...
0
votes
0answers
42 views

BCS list view webpart filters

I've added a list view webpart to a page and created a query string parameter which filters the data based on a finder method provided via the ECT. I also want users to have the ability to further ...
0
votes
1answer
49 views

BCS Question (scenarios when data source is unreachable)

I have a few real-world (hopefully simple) BCS questions for on-premise database and SharePoint Online (O365) connected by OData web service: In the scenario where the data source is ...
0
votes
2answers
92 views

Insert data from a XML into a List

Two questions: Is it possible insert data from a XML doc in a SharePoint Native List? Because I checked and is possible create a DataView from a Xml source in SP , but I can't find if it's possible ...
1
vote
1answer
26 views

External list edit form not shown

I created an external list using Business Connect Services. I have added operations for read list, read item and update item. Then create external list using external content type. I can display list ...
0
votes
0answers
46 views

Access powershell variable in next command- Can not convert the value of type “System.String” to type xxx

How to execute both commands in powershell. I get below error. I want to access $ Db in next powershell command. $ Db = Get-SPBusinessDataCatalogThrottleConfig-Scope ThrottleType Items ...
0
votes
1answer
70 views

The term 'Get-SPBusinessDataCatalogThrottleConfig-Scope' is not recognized as t he name of a cmdlet, function, script file, or operable program

If you are working with a larger external list (more than 2000 items) in dev environment it works perfectly, but when you work in production environment, it throws error Unable to display this Web ...
0
votes
1answer
218 views

SharePoint 2013: “Sorry, this site hasn't been shared with you” After External Content Type (ECT) Data Column is Refreshed -Only affects non SC admins

I am Farm Administrator and Site Collection Admin for a single site collection (the only site collection in our farm). On Prem SharePoint 2013 Server. I have created an ETC using a Secure Store ID ...
1
vote
3answers
3k views

Problems configuring External List on Sharepoint Foundation 2010

I have created a new database on MS SQL SERVER SHAREPOINT instace that contains two simple tables. Then I tried to link values defined in these tables by implementing External Content Types using ...
1
vote
1answer
293 views

Specify external content type lookup for deployable list?

I have a ListTemplate which is being deployed with Visual Studio. Is it possible to make a reference from this template to an external content type that runs on the farm? Or must I manually add these ...
1
vote
1answer
233 views

Fast Search for Sharepoint 2010: Incremental Crawl Memory Leak

Background My organization has been attempting to use FAST Search for Sharepoint 2010 as a search solution for our DMS. I am currently utilizing a .Net indexing connector to index a database of ~ 8 ...
0
votes
1answer
50 views

FileType Refiner with BCS Content Source does't work

I've installed the file connector sample from MS (link). Everything seems ok and the search is working well. But I can't get the FileType refiner working. What I've done yet: Changed the mime type ...
0
votes
1answer
34 views

Customizing details page link in BCS list or custom details page redirection with SarePoint 2013

I'm having fun with Sharepoint 2013 and studio 2013, just started dev few months ago -) I have some external lists pointing to external content type, I would like to redirect to a custom detail page ...
1
vote
1answer
60 views

How to create a External Content Type equivalent to a Document Set?

I'd like to create an External Content Type either inheriting from or equivalent to a Document Set. I'm not finding any good examples and Document Sets are derived from folders, so the API must be ...
0
votes
1answer
328 views

BCSLogin failed

I got a problem when using BCS in SharePoint Foundation 2010. I'm not able to let other users see the BCS content. I tried all the possibilities I found in internet (giving permission to the users in ...
2
votes
2answers
3k views

How to create an external List on SharePoint 2010 using MySQL table

I have a MYSQL database that contains customer related data from sugarcrm while a few order related data is stored in the MSSQL server. So far, I have been able to create an external list for the ...
0
votes
0answers
123 views

Connecting external list webpart to filter values

I have an external list in SharePoint 2013 on premise which gets data from SQL server. I created another list (regular custom list) in SP where I want to store items which are related to the SQL ...
0
votes
0answers
163 views

Importing BCS Dates in correct format to User Profiles

I'm trying to get the user Profile Service to store the dates in the correct format. Currently the date is displaying in American format, but it is switching the Month and Day around, so the 7th of ...
0
votes
1answer
50 views

external content type

We are a tennant in a larger sharepoint setup. I have tennant admin rights. As a test I would like to create a list that originates from a sql table. I followed this guide: ...
0
votes
0answers
13 views

BCS around connecting Farm(a) to Farm(b) for XL sheets

I have been requested to find the best possible solutions around how to connect a set of XL sheets Farm(a) to a set of dashboards Farm(b). My guess would be based on best practice to make use of BCS. ...
0
votes
1answer
39 views

External content types for specific web applications

Is there any way that we can limit the ECTs are available only for few web applications/site collections rather than across the farm?