Business Connectivity Services

learn more… | top users | synonyms

0
votes
3answers
2k views

Importing data from Excel/Word into a SharePoint List

Is it possible to import data from an Office Excel or Word file into a list in SharePoint (specifically SharePoint Online)? I have imported data from SharePoint lists to Word files.
0
votes
2answers
2k views

External Data Source vs. External Content Type

I was able to create an external data source (connected to an external SQL) database. However, when I try to create a column that is a lookup field, this data source and it isn't available to me So ...
0
votes
2answers
2k views

Manage User Profile Custom Properties using BCS

We want to write a Custom Webservice to pull the User Profile Properties from SharePoint 2007 and should be able to consume the same Webservice in BCS (SharePoint 2010). AIM: 1. Read a User Profile ...
0
votes
1answer
41 views

Export(or map) List data to external MSSQL table

There is much information about External Lists - when You make a Sharepoint list from SQL database table. In my case I need reverse operation - I have list, and want to map it to external SQL table, ...
0
votes
1answer
22 views

Sharepoint 2013 BCS Connectivity

I have created a BCS Service but as I am clicking on it, this is giving me error.. please tell me what is the problem and how to trace it.
0
votes
1answer
26 views

My site and properties from external sources

We have an on premise SharePoint 2013 farm. In setting up mysite, we will only retrieve username and picture from AD, all other properies for profiles we need to get from another database that is ...
0
votes
2answers
114 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
522 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
2answers
50 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
2answers
202 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
56 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
167 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
323 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
711 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 ...
0
votes
1answer
787 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
160 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
975 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
211 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
727 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
676 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
812 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
647 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
261 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
1k 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
1k 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
370 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
2k 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
553 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
357 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
391 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
689 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
493 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
87 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
1answer
12 views

Business Data List web part customization?

I have a question with business connectivity services in SharePoint 2013. I have a connection with CRUD access using an SQL server. The list view displays all records, but I have use the Business Data ...
0
votes
0answers
20 views

Updating External List after Updating BCS: SharePoint 2013

I am using SharePoint 2013 and SQL Server 2012, both Enterprise Editions. Earlier I had created an External Content Type and created its External List. I have no problem performing various options ...
0
votes
0answers
11 views

Crawling Business Connectivity Service

I've been working lately on crawling Business Connectivity Service models in SharePoint 2013. I created the business data connectivity models with Visual Studio and deployed them to SharePoint. The ...
0
votes
0answers
10 views

SharePoint Online (Office 365) & BCS Authentication Error

Following systems are involved: - SharePoint Online / Office 365 On Premise SQL Database Back-end data source is on our actual estate and consists a SQL Database with an OData web service ...
0
votes
0answers
18 views

Sync data from sharepoint to external web application

I am writing a provider hosted app for showing data from Sharepoint and add additional functionality to the entities. So I am looking to import the unique id and title of all the entities in ...
0
votes
0answers
24 views

Business Connectivity Services DateTime formatting

I have a SQL Server database with a number of columns of type Date. I have used BCS to create External Content Types in SharePoint 2013 for the tables in my database. However when a view these content ...
0
votes
0answers
28 views

Can I use SharePoint 2013 BCS to connect to external OAuth service?

Can I use SharePoint 2013 BCS to connect to external OAuth service and read the data form that service? Please provide a reference or an article.
0
votes
0answers
15 views

Creating External Content Type List with lookup/dropdown column

How to create an External Content Type list (BCS using SPD) with a dropdown control (column name = Products) Then the contents/choices of the product is also from a table in the database.
0
votes
0answers
54 views

JS Link on External list views (BCS)

How can I apply SharePoint Client Side rendering (JSLink) on an external List?
0
votes
1answer
26 views

How is Secure Store Service storing passwords under the hood?

When Business Connectivity Services need to access external data which requires per-user authentication, it uses Secure Store Service to store the user password in order to avoid asking for it again ...
0
votes
0answers
13 views

Can SharePoint user login to another system and display the information at Sharepoint?

We have a SP2013 on-premise farm and another self-written web application. The web application have its login member database and is written by Java. User would like to add a login box on SharePoint ...
0
votes
0answers
24 views

Updating External List via Workflow - Columns Missing

I have a BCS model that I've created a list instance in SharePoint off of and I'm using a workflow to copy over some values. Everything works great, except the identifier is not showing up as a field ...
0
votes
0answers
50 views

How do I get this field in the External List(ECT->BCS->SQL) to show up in SharePoint Designer Workflow?

I have created an External Content Type that has CRUD rights to SQL tables. Off that External Content type I have created an External List. I have a document library that has an InfoPath form on it ...