Business Connectivity Services

learn more… | top users | synonyms

3
votes
3answers
1k views

Display an SPFieldUrlValue property from a BCS Model

I have a pretty simple BCS model: public Guid Id { get; set; } public SPFieldUrlValue Url { get; set; } public string Description { get; set; } public string Owner { get; set; } public DateTime ...
0
votes
2answers
958 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 ...
1
vote
1answer
149 views

SPBuiltInFieldId structure for BCS - is there any const for “BdcIdentity”?

For SPListItem's built-in field values we have SPBuiltInFieldId class with many guids - SPBuiltInFieldId.Title and so on. Now I am working with BCS and I can't find any built-in object for ...
2
votes
1answer
856 views

“Access denied” while loading the BCS list from the database

I have tried to display data from SQL Server to a SharePoint page through BCS services using SharePoint 2010 designer. While loading I am getting this error: Access denied. You do not have ...
1
vote
3answers
3k views

Problems configuring External List on Sharepoint Foundation 2010

I have created a new database on MS SQL SERVER SHAREPOINT instace that contains two simple tables. Then I tried to link values defined in these tables by implementing External Content Types using ...
2
votes
1answer
579 views

Paging and sorting in sharepoint BCS

I saw this post about Paging and sorting and tried to do simiral thing in my project. But failed to do so. Everything works fine apart from instead of getting the value i get the parameter name. ...
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 ...
1
vote
4answers
1k views

BDC to BCS Application Definition Upgrade

I'm trying to perform an upgrade of a SharePoint 2007 environment to 2010. Our plan is to move to entirely new hardware and do a content database migration. In such a scenario, it seems that BDC ...
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 ...
2
votes
1answer
2k views

Developing Visual Web Part with external list in ListView

Using VS 2010 i've created BCS model for external MS SQL source, deployed it with success, then created external list - it works perfect. Now my task is - create visual web part in VS2010 and place ...
2
votes
1answer
2k views

Creating a Site Column from an External List with SharePoint 2010?

Can you create a Lookup column from an External List within SharePoint 2010. I have achieved this before but it seems incredibly fragile and I am now wondering if this is even a supported feature and ...
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 ...
2
votes
3answers
7k views

How do you enable connect to outlook on external list?

I am very new to sharepoint, its about day 3 of working with it, and I am having a problem getting Connect to outlook working on external lists. The menu item is greyed out. In my external contact ...
1
vote
2answers
594 views

BCS and SharePoint 2010

I'm looking to possibly upgrading to the latest version simply because the latest version has BCS integrated with the free version. A question I have to answer is "Does BCS integrate with Sage ...
0
votes
2answers
1k 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 ...
3
votes
3answers
1k views

Validation for external lists / external content types

Where does one put validation for external content types? Let's say one field on my ECT represents an email address that must be unique in our system. Where would I put the validation that checks to ...
1
vote
1answer
796 views

Exporting Application Model from SP Designer 2010 to Visual Studio 2010 BDC Model Project

I've created an Application Model in SP Designer 2010 and exported it (XML file). I'd like to use the definition in a Business Data Connectivity Project in Visual Studio 2010. Is there a way to ...
2
votes
2answers
567 views

Implementing Security on custom BCS/.net class?

I'm implementing a custom BCS Model to get data from a backend system. As the backend uses it's own user management, I'm accessing it through a service account. All of this works well and allows me ...
2
votes
1answer
2k views

No Business Data Connectivity Service associated with current web context error

I am running on a new dev setup for SharePoint 2010 and trying to setup some External Content types. I think that I have setup BCS correctly (since I see it running in the central administration). ...
8
votes
5answers
8k views

Paging and sorting with BCS

I going to use the new exciting External Content Type feature to display a list of data from an external LOB system. The list is potentially long, so paging with filtering at the LOB system side is ...
4
votes
1answer
214 views

Int type as Entity key into BCS Model

The BCS Model can't create a form for the "Update" operation if the key of Entity has a type of uint, int, long or ulong when I use WCF as a data source. It works fine with the string type. Does ...
2
votes
1answer
1k views

BCS and Oracle: bug in connection string?

I am trying to connect from BCS directly to Oracle, but there is an error: Keyword not supported: 'connect timeout'. I think that the connection string formed for Oracle is in an incorrect ...