Business Connectivity Services

learn more… | top users | synonyms

0
votes
1answer
601 views

Create a SharePoint 2010 BCS connection to Web Service with Visual Studio only

While I have been using SharePoint for quite some time I have not used BCS at all (except way back when I took some training). What I am looking for are steps to create a BCS connector to an external ...
0
votes
1answer
155 views

Which approach I should follow; SharePoint business connectivity services OR developing SharePoint App

I have developed a document management system and an enterprise wiki library for our company using SP2013. The second project I am going to start is to develop an asset management system for our ...
0
votes
2answers
802 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
2answers
181 views

Get Items from View of an Extrenal List(BCS List) programmatically

I have created a external content type (BCS list) in SharePoint. I am using the below code in order to get items from bcs list. SPQuery query = new SPQuery(); query.Query = ...
0
votes
1answer
666 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 ...
0
votes
2answers
584 views

Connect BCS / BDC to the User Profile Service?

Firstly I'm open to suggestions if people have better solutions or ideas. I would like to be able to create a list with a 'username' field that will pull additional fields from the information stored ...
0
votes
1answer
655 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 ...
0
votes
2answers
596 views

External List and jQuery

I have an external list that I want to hackup with jQuery. If i put a simple alert in document .ready, it fires, and THEN the SharePoint progress spinner shows up, and then the data is returned - long ...
0
votes
1answer
250 views

External list in SharePoint 2010 with unique item permissions

Is there any way to set permission for bdc items within external list?
0
votes
1answer
855 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 ...
0
votes
1answer
947 views

External Content Type and Entity Framework

I have been struggling with this project for about two weeks now. I have successfully created an External Content Type using Visual Studio and have deployed it. I was also able to use the SharePoint ...
0
votes
1answer
335 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 ...
0
votes
1answer
1k views

Unable to display this Web Part. BCS SP2010

I am trying to get data form SqlServer2008 in SP2010 with the hep of BCS. I have created External List Successfully,but when I go to my Site I get following error: Unable to display this Web Part. To ...
0
votes
1answer
1k views

Search results: URL of BCS search results start with bdc3://

I am using sharepoint 2010 Business connectivity service. I need to search an item in the database. So I configured search service. I am able to find the search results but when I clicked on the ...
0
votes
1answer
532 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
348 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
384 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
616 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
475 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
85 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
1k 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
2k 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
4 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
30 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
13 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
0
votes
0answers
15 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
0answers
14 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
47 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
0answers
23 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
32 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
31 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
77 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
62 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 ...
0
votes
0answers
30 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 ...
0
votes
0answers
46 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
39 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
50 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 ...
0
votes
0answers
55 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
51 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
0answers
54 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
90 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
258 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
35 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
55 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
141 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
177 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
55 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
41 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?