1
vote
0answers
77 views

BCS connection with SQL DB and Sharepoint list passing parameters

Is there way to pass parameters to BCS connection between sharepoint list and sql table and populate the list with the sql table data which agrees to a certain scenario(according to the passed ...
0
votes
0answers
101 views

BCS Model with primary key consisting of multiple columns

We have a database with a table that has a primary key that consists 4 columns. I want to show the table data in SharePoint by using BCS. A created a new BDC Model in Visual Studio, but has no idea ...
1
vote
2answers
835 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
2answers
1k 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 ...
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 ...