Business Connectivity Services

learn more… | top users | synonyms

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
9 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
19 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
21 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
11 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
1answer
29 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
0answers
15 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
5 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
58 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
48 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
22 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
50 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
76 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
0answers
22 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
97 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
130 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
26 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
68 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
84 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
73 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
315 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
52 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
251 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
41 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
22 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
40 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
23 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
34 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 ...
0
votes
1answer
313 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 ...
0
votes
0answers
68 views

BCS code - The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel

I am using a Console Application to connect to an Enternal Source (BCS) which is secure. How can I pass my credentials to my code below so that I don't get the error above? // Specify the SiteURL, ...
0
votes
0answers
41 views

Custom connector for BCS search - SP 2010

I have some doubt on when to create a custom BCS connector for searching LOB data? By default BCs provides way to search on LOB database like Adventureworks in the given image. But when do we need ...
0
votes
0answers
23 views

Custom search option through BCS Metaman

Can any one of you help me on this? If we implement BCS through BCS Metaman tool will we be able to search LOB oracle data through our SharePoint 2010 Enterprise search template? Or even after using ...
0
votes
1answer
134 views

InfoPath changes the look of the form

I am following this guide to create a cross site lookup field in SharePoint. I am using SharePoint 2013. The problem is that when I open the form with InfoPath Designer 2013 the form doesn't resemble ...
0
votes
0answers
300 views

Using Business Connectivity Service to connect SharePoint 2013 to an external WCF service

Has anyone successfully connected BCS in SharePoint 2013 to an WCF service? I did several attempts and always got Cannot connect to Business Data Connectivity Metadata Store in the SharePoint ...
0
votes
0answers
136 views

External Content Type in a Site Column results in ArgumentNullException for wildcardedNamespace

I created an external content type, which seems to work fine. I created a list to browse the external content type, and I can see the elements coming from my sql server. I can also use the create and ...
0
votes
0answers
99 views

BCS DateTime Format to Date Format Conversion in Display From

Version: sharepoint Online 365 I am having Date Field in DB . While i am retrieving in BCS Its showing as Datetime Format. How can trim Time Value. I need to display in Date Format only . ...
0
votes
0answers
16 views

2010 BCS contains metadata for an invalid Data Source for a ECT

I have been asked to look at getting search to work on an External Content Type. Taking a look at the ECT in designer I see that the previously defined datasource which is stored in BCS is invalid in ...
0
votes
0answers
30 views

BCS field seen in model but not in item profile page - SP2013

I've added a column to my source SQL table, updated the model so that I CAN the new (URL - string type) field in the model (both in SP designer 2013 & BCS application), profile page for displaying ...
0
votes
0answers
98 views

BDC model to connect oracle data in SharePoint 2010

Need to connect to oracle through BDC model - we can do this by either BDC model created through Visual studio or through BCS Meta man? performance wise which one will be better? BDC model created ...
0
votes
2answers
434 views

oracle data in InfoPath form

We have a InfoPath form on which wants to show real time data from Oracle database. E.g. Employee name in a drop down list in InfoPath form from employee table in oracle. Don't want to populate ...
0
votes
0answers
23 views

Is there a way to make data linked to by BCS look like a document library?

Is there a way to make the data linked to by BCS look like a document library? Basically, I'm storing some archival type documents in cheaper storage than a SharePoint document library, but I would ...
0
votes
0answers
81 views

External item picker Default Value

How to set default value to external item picker (the textbox that related to it.) Thanks, Omri
0
votes
0answers
262 views

The created external list does not support creating new items

i have BCS with external list that read list and read item is from a table. and create new item is from Stored Procedure. i'm using applicative user who has full permissions (work directly from ...
0
votes
1answer
173 views

Search External Content type not returning all records

I have a sql view that returns 449 records. I have setup my external content type to point to this view and have implemented via SPD the read item and read list operations. I have created the ...
0
votes
3answers
446 views

How can I view Developer Dashboard from a custom master page or PowerShell?

I need to view Developer Dashboard data to investigate a bottleneck on a SharePoint deployment, but the master page has been customized and the Developer Dashboard is not available (after enabling it ...
0
votes
0answers
60 views

Enumerate BCS Object Permissions

Hi I am looking for a method via PowerShell to enumerate the various ETC's that have been created to determine who currently has access. I realize that I can do this via the front end, however I need ...
0
votes
1answer
164 views

Getting Filtered results by Date column from a list with BCS and SharePoint 2010 JavaScript Client Object Model

I'm trying to get the filtered results by a column type DateTime from a list filled with BCS using JavaScript. I've tried everything to get those results with query like: "<Where>" + ...
0
votes
0answers
86 views

Show related entities in FAST search results

I've successfully created a .net assembly BCS to crawl external data in my enviorment. The BCS include an AssociationNavigator to crawl related entities based on foreign key. When i perform a crawl ...
0
votes
1answer
373 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 ...