Business Connectivity Services

learn more… | top users | synonyms

3
votes
2answers
1k views

TFS-SharePoint integration

I am currently investigating how to push data from Team Foundation Server to SharePoint. Are there any connections available out of the box? Any useful online references? Third party tools?
2
votes
1answer
535 views

Sharepoint Online and custom BDC models

Hello I hope somebody can help. I need to access an external timesheet from Sharepoint Online. The Timesheet site uses a REST api to provide the data, not a WCF or traditional ASPX webservice. So ...
6
votes
4answers
3k views

Working with large external lists using BCS

I have a database that I want to display the content in SharePoint 2010. I am not displaying the content in a list but am using a custom WebPart. The database is not updated any more as it is ...
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 ...
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
1answer
1k views

External List Error : The query against the database caused an error

I got an SQL Server 2008 R2 and a SharePoint Server. I have put up a BCS between the two servers. Reading data through a External List. This worked fine yesterday. But to day I got this error: The ...
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
497 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
2answers
782 views

External list with bulk amount of data does not work properly

I have created and external content type to fetch data from a SQL table. The table currently contains 8000 records. So when I create an external list from that content type the list does not display ...
0
votes
2answers
259 views

Single Library Storage for multiple Site collections

We are building portal based on SP 2010 platform which will mainly be a e-learnig site with SharePointLearning Kit. There will be ca. 100 school site collections. We will also have about 23 gigabytes ...
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
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
1answer
518 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?
2
votes
3answers
860 views

SPTimer job and BCS External list

Business requirement - synchronize a table from external my sql database into SharePoint list. What I have done. I have an external MySql database which as LOB data. I have created a BCS ...
2
votes
1answer
501 views

How to customize profile pages for external content type search results?

I have set up the SP 2010 enterprise search to include searches in line-of-business data. (In my concrete case that would be data from Dynamics CRM 2011 but I hope that is not relevant). I have ...
3
votes
1answer
587 views

How to use the batching and batching termination filter descriptors in BCS .NET Connectivity solutions

I know about this post on BCS paging: Paging and sorting with BCS and have implemented a similar approach in a BCS solution. However, what I'm really looking for is a complete example showing how to ...
1
vote
3answers
975 views

Error while import resource file Business Data Connectivity

I am trying to use powershell for importing a resource file in Business Data Catalog but I keep getting the following error Import-SPBusinessDataCatalogModel : The root element of a valid Metadata ...
1
vote
2answers
1k views

SQL Hardening, BCS, and ECT (SharePoint 2010)

Currently running into some errors when trying to setup External Content Types with SharePoint 2010. The goal is simple which is to connect to a SQL Server and pull information into SharePoint to an ...
1
vote
1answer
574 views

BDC hide identifier in new item form

I'm working on a simple bdc model in visual studio. i use the entity framework to access the data on the database. Everything works fine (all CRUD operations) but in the "New item" form i have to ...
3
votes
0answers
249 views

Filling a External Data field (BCS) in a list trough Powershell [duplicate]

I have a list of which one of the columns is of the "External Data" type, linked to a BCS service. We called this column "Organisation", and when I check the generated fields in powershell (with ...
0
votes
1answer
567 views

BDC - User profile sync won't sync with sql server/wcf service

I created simple web service which implement 2 methods (one (no parameters) return list of object, another (one parameter - upId int) returns simple object with 3 properties (bool, string, and int ...
1
vote
2answers
444 views

merge data in a sharepoint2010 user profile property sync with sql using BCS

i have configured the user profile syncing with my custom SQL table. i require 4 properties that are with 6 columns in the table & the scenario is i have to concatenate the strings of the 3 ...
1
vote
1answer
634 views

Best way to get external data to SP 2010

This is the scenatio: I have an AD that i'm going to use when installing SP 2010 but it doesn't have a lot of meta data as in poperties its only got : Lastname, fistname and email etc.. So i would ...
1
vote
1answer
243 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
1k views

How to Bind Data to Traditional ASP.NET Controls in SharePoint Foundation 2010?

First off, my background is ASP.NET Web Forms. I'm sure this is very simple but I'm quite new to SharePoint. We're running SP Foundation 2010. I'm going to build a WebPart in VS.NET 2010 and deploy ...
0
votes
1answer
336 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 ...
11
votes
4answers
6k views

How to automate entry of external column data in BCS?

I have a document library, Resumes, that has a large number of resumes in it. There is a regular column on that library, called EmployeeID, that is already populated. I have an external content type ...
9
votes
3answers
1k views

FAST Search Security Trimming of non Windows External Content Types

We have integrated a back-end web application into SharePoint 2010 using the BCS and the OOTB Web Services connector. The data in the backend system is protected by ACLs and we need these ACLs to be ...
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 ...
5
votes
2answers
648 views

Use custom page in _layouts for display item form

I was wondering if I could acheive the following. I have a custom application page living in _layouts which displays an entity based upon an external content type item. For external lists using this ...
1
vote
0answers
155 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
2
votes
1answer
79 views

Good book or resource that talks about custom connectors and SharePoint search Integration?

Do you know any good books or resources that explains how to write your own custom connector for search crawling? I have been reading Professional Business Connectivity Services in SharePoint 2010 ...
10
votes
7answers
16k views

How to sync a SQL database with a SharePoint List?

I need to sync an already existing SQL Database to a SharePoint 2010 list. Two way sync would be great but one way sync is also alright. Any documentation in this regard would be of a great help. ...
1
vote
2answers
387 views

BCS Security Access Using Secure Store in code question

I have Secure Store and also Kerberos setup on my development and production farms. I am using Event Receivers to access BCS data. I have verified that if I simply impersonate a user that has access ...
1
vote
0answers
475 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 ...
0
votes
0answers
183 views

Enterprise - External Task List - Connect to Outlook- setting Assigned To

I've got an External List coming from an External Content Type which has Office Item Type of "Task". It comes from an external system which has its own concept of a task, and I'm pulling them into ...
1
vote
3answers
1k views

Accessing External List Items Programmatically

The following bit of code throws an Unauthorized Operation exception when I try to enumerate the items in the list. Any ideas? SPSecurity.RunWithElevatedPrivileges(delegate() { ...
5
votes
2answers
4k views

Access Denied while setting Metadata Store Permission

Breaking my head with this issue for the past 2 days! Received Access Denied error in SPD so tried to set Meta Data permission and get the following error. I am one of the Admins for BSC service ...
0
votes
3answers
367 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 ...
1
vote
0answers
327 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 ...
3
votes
3answers
2k views

Moving BDC models from server to server

I have created a BDC model and deploy it through a feature. The feature has to have a SiteUrl as specified in the feature xml below. However when I move the feature from say the development to test, ...
2
votes
1answer
765 views

Is there a way to modify external list form with Infopath?

I would like to modify an external list form with infopath like I do with custom lists. However, even if I select "create infopath form" when creating my external list, it doesn't seems I can do that. ...
4
votes
3answers
3k views

Date Only format with BCS

I have created an External Content Type through SharePoint Designer. One of the fields that I'm getting from my database is a DateTime column. In SharePoint, however, I want to format this as a Date ...
1
vote
0answers
355 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 ...
2
votes
1answer
1k views

Creating an external list from SQL query using BCS

I'm developing a visualization application on SharePoint Enterprise 2010. This involves doing some SQL queries I would love to expose as external lists in SharePoint. All interfacing with the database ...
5
votes
1answer
262 views

How to use BCS in Word for editing BLOBs

If I have an External Content type defined with a StreamAccessor that will end up referencing Word docx files stored in another system (reason for using BCS), what options do I have for updating the ...
2
votes
1answer
652 views

Using BCS and External Content Types to create Publishing Pages

I'm starting a new SharePoint 2010 web content management project where a portion of the site's content is driven by an external system (SQL Server based). Think employee bios... The external system ...
3
votes
1answer
150 views

Can document views/metadata be 'live'?

We have a need for end users to see documents with additional 'live' columns, i.e. I would like to show a view of documents with employee id JOINED with data from sql server (for some additional ...
2
votes
2answers
841 views

Supplementing User Profile with information from BCS

I've got my external content type and BCS all sorted and working - the list view of the external list shows 100% in the site and the external content type shows under my BCS service application. Now ...
6
votes
4answers
1k views

Reusing and parameterising BCS External Content Types

I recently posted a query here that asked about the best way of connecting to an external SQL store. I got some great responses back but need a little more info, specifically around External Content ...