Business Connectivity Services

learn more… | top users | synonyms

0
votes
1answer
509 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?
0
votes
1answer
327 views

BCS StreamAccessor method

I've implemented a StreamAccessor method for my BCS indexing connector. My source is an SQL database which has a table that contains records. Some of the records have links to files. My problem is ...
0
votes
3answers
356 views

Pass user UPN claim to WCF service via BDC

I've finally managed to get my SharePoint system up and running so that it authenticates users with Kerberos and successfully passes that authentication along to a back-end WCF service. All end-users ...
0
votes
2answers
560 views

SiteUrl BCS deployment error through Visual Studio

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

SharePoint 2010 BCS stops working after a while

A little background: we are using the BCS with an external content type to expose external content we provide using a WCF service. We have a webpart that uses the external content type to display a ...
0
votes
1answer
83 views

Displaying error in External List

I've an external list. I've to add a new item to the list (insert a record in the db) based on some conditions. Failing to meet those condition I must not allow the creation of object. I've thrown an ...
0
votes
2answers
994 views

SharePoint 2010 using web service to insert a data that has a lookup into external BCS list

I've got a 2 SharePoint lists: List A: This is an external list that's using Business Connectivity Services to connect to CRM. List B: This list contains a lookup field that linked into List A. I am ...
0
votes
1answer
1k views

ECMAScript Client OM with External List

In SharePoint 2010, for a regular "custom" list calling SP.ListOperation.Selection.getSelectedItems() using the ECMAScript client object model returns an array of item IDs. These IDs correspond to the ...
0
votes
2answers
1k views

SharePoint 2010 Foundation BCS Errors

We have an BCS issue on a Sharepoint Foundation multi-tenant farm. Users are able to create external content types using SharePoint Designer 2010, but when they browse to the list of external data we ...
0
votes
0answers
16 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
17 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
65 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
16 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
23 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
39 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
55 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
26 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
7 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
33 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
56 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
0answers
45 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
49 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
148 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
67 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
127 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 ...
0
votes
1answer
44 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
84 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
0answers
26 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
0answers
23 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 ...
0
votes
0answers
10 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 ...
0
votes
1answer
235 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
156 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
32 views

I stopped the BCS service on a couple of servers, but I still get connectivity errors

Stopping the service on some of the servers seems to have no effect when the system is trying to make a web service call. Here is the error in the ULS: The BDC Service application Business Data ...
0
votes
0answers
100 views

Using $expand with BCS External List via REST call

Is it possible to use the $expand odata keyword to expand a child (associated) entity from BCS within an external list using the REST API. Eg to get the country name from querying the customers list ...
0
votes
0answers
117 views

Sharepoint BCS multiple identifiers

I have a BDC model that worked well with one identifier defined. However when I added another identifier i'm getting the following error in the crawl log. Any ideas? Looking at the model i'm not ...
0
votes
1answer
263 views

Create external content type with impersonated custom identity

I'm developing a SharePoint Application. I have SharePoint Foudation 2010. I have created a External Content Type with Impersonated Custom Identity(Connection to SQL Server 2012). After I created a ...
0
votes
1answer
209 views

Catastrophic failure when crawling BCS data in SharePoint 2013

I am getting error in search crawl Logs when doing a full crawl on a Business Data Connectivity content source. The content source is set up to crawl a SQL BCS entity that has a stream accessor, ...
0
votes
0answers
29 views

Cannot modify BCS Model Security Validation Exception

I am trying to programmatically modify a ECT/Entity based on REST data from another system. It works if I am running it from a console application but if I am trying to run it from for example a ...
0
votes
1answer
89 views

BCS: Edit button in context menu works, but edit button in display form is disabled

I created an external content type für a MS SQL Server view. I created a list from it and three different views and I changed the form with InfoPath. All of this done without VS, only SharePoint ...
0
votes
0answers
103 views

Use Custom rendering Template with External List

Does anyone Know if its poossible to use a custom RenderingTemplate with an External List? In my Schema.XML I have <Forms> <Form Type="DisplayForm" Url="DispForm.aspx" ...
0
votes
0answers
102 views

BCS: multiple input parameters for delete operation in ECT possible? How to pass them? SharePoint 2013

I'm currently designing an external content type that should be able to view a list, an item, insert and delete items. The first three work without problems, but I still can't get the delete operation ...
0
votes
0answers
457 views

Get Items from External List using BdcIdentity on server

I added a ribbon Action on an external list. When the users clicks the Button in the ribbon I use SP.ListOperation.Selection.getSelectedItems() to get the ids and of thr items the user selected. ...
0
votes
0answers
67 views

BCS: external data from SQL Server - Image column not showing

I created an external content type based on a view in the external SQL Server database with SharePoint Designer. So far it worked fine, but when I create a list of this ECT there are two columns ...
0
votes
1answer
389 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
59 views

Cascading External Data in Sharepoint 2010

I have a list called "Jobs" that have two columns (Type External Data) called "Company" and "Project". When the user selects a Company, I need the field "Project" filter projects in accordance with ...
0
votes
0answers
21 views

Business Connectivity Service set permission on entry level

I am not sure if it is possible or not. I Need a way to set permissions on entry Level. that means that I am retrieving data from a REST Service but every single user has different permissions on ...
0
votes
0answers
29 views

SP 2010 - BCS - Displaying SP List with additional columns autopopulated from External List

I want to know if the following is possible. I have an SP list called 'Orders'. The Fields are 'Number', 'Quantity','Amount', etc. I have an External List from a SQL DB called 'ExtOrders' - Fields = ...
0
votes
1answer
47 views

Using External Content Type Pickers with Boolean fields

I have a SQL table with three fields - a unique ID I don't care about, a description, and a Boolean indicating whether or not the record is 'current'. This table is setup as a fairly standard ...
0
votes
0answers
30 views

how to use association when creating a new item using BCS Object Model and OData

I have an odata service that exposes two collections: customer and orders. So I have this example: http://spabcd.net/customer('1')/Orders How can I create a new customer and associate new orders to ...
0
votes
0answers
35 views

Dynamically create BDC Data Model based on delivered Meta information via REST

I have the Problem that I have a REST Service which delivers the data I Need to work with in SharePoint but the System I am retrieving the data from might get additional parametes/fields over the time ...