Business Connectivity Services

learn more… | top users | synonyms

1
vote
0answers
18 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
12 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
17 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
20 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
0answers
22 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 ...
1
vote
1answer
83 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
1answer
31 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
30 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
2answers
33 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
0answers
23 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 ...
1
vote
1answer
14 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
31 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
41 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
158 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 ...
0
votes
1answer
31 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 ...
0
votes
1answer
37 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
0answers
84 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
105 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
34 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
11 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
35 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?
0
votes
0answers
90 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
1answer
75 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
56 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 ...
1
vote
0answers
94 views

Authentication between SharePoint O365 and external OData web service

We are using SharePoint Online (O365) with ADFS. We are also building an on-premise OData web service to provide data into the cloud as an External Content Type. We understand generally how to use ...
0
votes
0answers
195 views

SharePoint 2013 BCS External Data Column

How do I return all entities without using entity.GetFilters() ? I have the following and I can only seem to produce a FilterCollection. I would much rather have just all the enities because i am ...
0
votes
0answers
92 views

SharePoint 2013 External content type security trimming issue

I have a need to security trim only selected external content items using "deny" for a AD group. So created security descriptor method which returns a byte array. The problem is the security ...
0
votes
1answer
154 views

SharePoint 2013 External Content type. Populate secondary fields

I am trying to migrate data to a document library that contains a external content type using the SharePoint 2013 client object model. The external content type is pulling from a sql server 2012 ...
1
vote
1answer
208 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 ...
1
vote
0answers
20 views

Sharepoint Business Connectivity Service PrincipalIdentityNotMappedException

Today all external lists on farm suddenly stopped working and I cannot configure any BCS application in central admin configuration. There are ...
0
votes
1answer
240 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 ...
1
vote
0answers
37 views

Are third party solutions really that superior to BCS?

Let us assume it is my task to establish a bidirectional connection between a SharePoint List and a SQL-database. According to Paolo Pialorsi's Developer Manual for SharePoint 2010, BCS (Business ...
0
votes
1answer
64 views

BCS external content type as lookup

I have written a wcf service to read the title and id column from a list and returning as arraylist. Please find the below code. The webservice is returing the values correctly.Now when i create an ...
0
votes
2answers
110 views

SharePoint 2013 - Managed property value does not update

I have configure SharePoint Search with line of Business Content Source (BCS). Create Few Managed Property with this BCS. Records is crawling successfully however managed mapped property value does ...
0
votes
1answer
38 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 ...
1
vote
1answer
228 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) ...
1
vote
1answer
45 views

BCS Question (changing data source of a web service)

We are going to be building a Web Service (on-premise) to connect our data to SharePoint online (o365) using BCS and OData. If we migrate our database from one location (in Oracle) to another (e.g. ...
0
votes
0answers
25 views

Update BCS Value Programatically

Here is my issue, we had a BCS definition with a value being stored as an int. we had to update that definition so the value is now stored as a string. However do to most of our values being stored of ...
1
vote
2answers
323 views

Why aren't my result types working with managed properties?

I'm having trouble getting Result Types working in SharePoint Search. I've defined a result source for one of my BDC datatypes, plus a result type that matches everything from that result source. ...
0
votes
0answers
14 views

Site URL BDCS Error

Error occurred in deployment step 'Add Solution': The default web application could not be determined. Set the Site URL property in feature SP xxx Feature to the URL of the desired site and retry ...
2
votes
1answer
194 views

Impersonated Windows Identity vs Impersonated Custom Identity

Could anyone explain the difference between Impersonated Windows Identity and Impersonated Custom identity in SharePoint?
0
votes
2answers
84 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 ...
0
votes
1answer
367 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
251 views

Using workflow and BCS to sync external data - CRUD

I'm new to SharePoint and trying to get BCS working with external content. I need to "replicate" native list to an external SQL DB for my project. So I use the crated/changed workflow start options ...
0
votes
1answer
107 views

External Content Type = access denied

I have an External Content Type created. It connects to a SQL Server 2005 db, using "Impersonate Windows Identity" authentication, with an account over in Secure Store Service. I've got a Read List ...
0
votes
1answer
393 views

How to get BDC data from BDC URL returned by search in SharePoint 2013?

I am building a POC system based on Search in SharePoint 2013. I have setup BCS to crawl external SQL DB. Search crawl is successful and I am getting the results. I have not setup any Managed ...
2
votes
1answer
236 views

Timestamp in Sharepoint external content type not matching value in SQL table

I have an external content type in SharePoint 2010 pulling data from a SQL 2008R2 DB using BCS. All the data comes back fine but the Time stamp column is off by 2 hours when I compare the values ...
3
votes
1answer
139 views

How to Sync user data from multiple sources BDC and AD?

I have a user profile that has fields from multiple sources. fields form AD and fields from BCS -> SQL DB. Everything is working, except if the DB is down, the fields get populated with empty data. ...
1
vote
1answer
75 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 ...
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 ...