Business Connectivity Services

learn more… | top users | synonyms

1
vote
0answers
118 views

Searching CRM 2011 records in Sharepoint 2010

I need to search Microsoft Dynamics CRM 2011 (onpremise or online) records in SharePoint 2010 (onpremise and preferably foundation but can go to enterprise if it is a must). I want to know from ...
1
vote
2answers
483 views

How to connect Outlook to an external list, which uses external connector in DLL

The task: connect Outlook with the external list, which was created in Visual Studio and uses SAP connector (sapnco.dll). What I've done: Created this external list. I can see all information in ...
1
vote
2answers
2k views

working and filtering with large external lists using BCS

I have a large set of orders (about 7500) that I want to show in my SharePoint site. I'm using BCS because I also want to link the orders to documents. I also have an external list with these ...
1
vote
1answer
402 views

How to Set Input Filter Programmaticlly in BCS

I have a Method in Entity which takes 2 input filters. Now I want to set a value in this filter. How can I do that? I already got the collection of Filters using the GetFilters() method of the ...
1
vote
0answers
143 views

Use Secure Store Credentials to connect to database with Windows Authentication in Visual Studio solution?

Background: I have an external content type that has been developed in a Visual Studio 2010 solution. This content type is based mostly off elements in a database that are accessed via stored ...
1
vote
0answers
189 views

Does BCS support creating an external list from an existing list in a different web application using List Web Services

I have sharepoint 2010 farm where there are multiple web applications. I am trying to understand BCS and its capabilities. This is the structure I have :- Web Application A > Site Collection > ...
1
vote
0answers
61 views

Getting error while creating ECT using WCF that is hosted in SharePoint through SharePoint Designer [closed]

I am getting error while creating ECT using WCF that is hosted in SharePoint through SharePoint Designer. The error message is Object Reference. When I Host this WCF then I am able to create ECT ...
1
vote
2answers
524 views

ReadList with Association for External Content Type via Visual Studio

I would have thought this is a common requirement but I just cannot seem to find any resources addressing this. I have several Entities defined along with Associations between them. They deploy ...
1
vote
0answers
438 views

Association created by VS does not work

I am trying to create several ECT with Associations between them. Been playing around with several tools and reading/watching a handful of tutorials. I have gotten my pieces to work when playing ...
1
vote
0answers
179 views

Read sharepoint external-list items

I am working with sharepoint 2010. I have an external list. I need to retrieve the list items from the external list for which i am using the following code below. SPQuery query=new SPQuery(); ...
1
vote
0answers
636 views

Navision + sharepoint.

For the last couple of weeks we have been struggling with an issue that we could not solve. This issue are concerning Sharepoint and Navision 2009. So we really hope that you would find a solution. ...
1
vote
0answers
150 views

updating item from an external list

I'm trying to update an item in my external list i'm using BCS and LINQ to query. That's my Update method : public static void Update(Customer customer, int parameter) { ...
1
vote
0answers
497 views

PageNumber-Fillter for Finder in .Net Assembly Connector

I'm currently trying to use an PageNumber-Filter for an Finder-Method in an .NET Assembly Connector. The relevant Part of the Method-Definition of the ReadList-Method looks the following. <Method ...
1
vote
1answer
240 views

Association between a custom list and an external list

I have a very basic question. I have a Custom List and I'd like to add a lookup column from an External List based on a WCF Service. Is it possible? E.g. I have employers in a custom list. I'd ...
1
vote
0answers
109 views

Edit the BCS search item

I have created an external list and external content type using SharePoint Designer. I need to search an item in the external list. So I configured search in central admin. I am able to search an item ...
1
vote
0answers
490 views

Problem with Refresh button on External data column

I'm struggling with refreshing items on list with external data. So far I have been able to make the refresh button work, but only when I add items to list in a standard way (via browser). When I add ...
1
vote
1answer
234 views

The operation(s) generations creates an SQL query which exceeds the length limit in Business Data Connectivity Metadata Store

I am trying to add a table from a SQL database as an external content type. When I do so I am getting the following error: The database table has 188 columns (I did not design this legacy system. I ...
1
vote
2answers
2k views

External Data field - problem with refreshing (SP 2010)

I have created a custom list with a field (column) of 'External Data' type, connected to my external content type. External Content Type's source is an SQL view. My problem is, when I make changes on ...
1
vote
0answers
151 views

BCS External List selected items using ECMA script

I am getting the BdcIdentity values using ECMA script for external list, is there any way to get the list column values using ECMA script
1
vote
0answers
471 views

Populating User Profile properties with multiple values via BCS/BDC in SP2010

In SharePoint 2010, I have user profile data synchronized from active directory. Additionally, I've created a BdcModelProject in Visual Studio 2010 and done the necessary work to add some additional ...
1
vote
0answers
319 views

Changing the field order after BCS Association? [closed]

I’ve created and deployed an External Content Type with Associations. All of the CRUD methods I’ve implemented are working correctly. Here’s my problem – in the View Item, Edit Item and New Item ...
1
vote
0answers
346 views

Deploying BCS Model To Multi-Tenant Administration Site [closed]

I've got a simple BCS model with a single entity for a test. The entity pulls from a Entity Data Model in a separate assembly. I'm using SharePoint Foundation so I used the feature receiver here to ...
0
votes
2answers
715 views

Where the SharePoint External List data is stored?

Last week I had a discussion with one of my colleagues about "Where the SharePoint external List data is stored?", Is it stored in a SharePoint list and the SharePoint is synchronizing the changes ...
0
votes
1answer
883 views

What are the BCS/External List Limitations for ECMA CSOM?

I cannot seem to find any documentation on this topic. Are there any limitations for what I can or cannot do with the JavaScript CSOM in SharePoint Server Standard 2010 External Lists as compared to ...
0
votes
2answers
1k views

Update and Create Problem with Adding Columns to an Existing External Content Type in SharePoint 2010

I used SharePoint Designer 2010 to create an external content type (ECT) that consumes and writes data to SQL Server. [Went through the process of connecting to a database table, then right-clicking ...
0
votes
2answers
1k views

Using LINQ on an external list

When I create a list in SharePoint and want to run LINQ agaisnt it I use SPMetal to auto generate the mapping. SPMetal.exe /web:http://mysite /code:C:\MyFile.cs This does not seem to generate the ...
0
votes
1answer
107 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 ...
0
votes
1answer
96 views

Business Connectivity Services vs. ADO.NET

Why should I prefer Business Connectivity Services (BCS) over plain ADO.NET, if all I want are simple CRUD operations on an external database (e.g. remote Oracle Database), which are made from a ...
0
votes
2answers
467 views

How can i use External Content Types - SQL Authentication with NO Kerberos

I'm in the process of using ECT and the data is in a sql sever. Before i get started is this possible with no kerberos existing in this current environment. So the service where SP resides is ...
0
votes
3answers
212 views

BCS in a multi tenant scenario

I'm planning on creating a BCS layer which will be used in a multi tenant scenario. The plan is as follows: multiple clients will all get a SharePoint site. They will sync data from their ERP into a ...
0
votes
3answers
1k 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
1k 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
33 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
72 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
82 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
301 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
394 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
2answers
652 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
3answers
432 views

How to sync a Sharepoint 2010 list with data from a table in SQL server

I have a table in SQL server 2008 and a list in sharepoint 2010 that has a few columns from this table and a few other unrelated columns as well. This SQL server table keeps changing and I want to ...
0
votes
1answer
147 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
608 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
158 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
923 views

Synchronization of SharePoint 2010 List with SQL Server Table

I need to create a list such that the values on the list can be stored in SQL table as well. I need to attach workflows to the list item as well. Its a simple workflow with two approval process ...
0
votes
2answers
477 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
2answers
552 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
237 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
643 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
867 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
304 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 ...