Business Connectivity Services

learn more… | top users | synonyms

5
votes
2answers
321 views

How to dynamically generate Business Connectivity Services

We are trying to deploy a Business Connectivity Services(BCS) Model solution where the properties in the model depend on the structure of the data exposed by a web service. Ideally the BCS Model ...
1
vote
1answer
468 views

How to Stop ECT Action from Using ActionRedirect

If I create an Action on an External Content Type with a URL such as this . . . ...
1
vote
0answers
151 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) { ...
3
votes
1answer
569 views

Access denied for BCS method in e-mail event receiver

I have a SPItemEventReceiver which does some stuff with an external list when a document is uploaded to a DocLib. I now wanted to have it also run when an e-mail is sent to that DocLib. I could have ...
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 ...
2
votes
0answers
125 views

External Data Column no sorting by a string based additional field

Can anyone confirm or tell me why you can't sort by an External Data column additional field if its type descriptor is a string? It works for int, bool and guid type descriptors. If I add a standard ...
4
votes
1answer
793 views

multiple value in external data column

We need to store multiple value from external source in the one column. Same multiple lookup. Is there any exiting way to do it? If no, i think about developing custom entity piecker, but it need ...
1
vote
3answers
254 views

SharePoint foundation and BCS

I am testing SharePoint 2010 foundation with bcs to access one of my sql tables. I created a list with filters on some fields (wildcard and limit types) But unfortunately, when I display (browser) ...
1
vote
0answers
531 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 ...
2
votes
1answer
399 views

BCS Model not deploying in Farm environment

Has anyone else seen an issue with deploying a BCS Model WSP to a farm and the External Content Type is not being deployed? The Farm feature is activated. It is working fine for a single server ...
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
552 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
242 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
507 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
819 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
277 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
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
1answer
533 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
892 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
526 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
614 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
1k 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
607 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
598 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
469 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
638 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
267 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
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 ...
11
votes
4answers
7k 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
677 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
157 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
18k 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
418 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
488 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
190 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
5k 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
385 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
334 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 ...