New answers tagged external-content-type
In short you could declare them as varchar as you asked. However, BCS will create your mapped fields (for your external list through the External Content Type) based on the column types (e.g. if your database column for "Name" is varchar(50) then your ECT field "Name" will be a single line of text). Also, you won't get any built-in validation support if you ...
I think this is the correct way of doing it. Copying the data from Old List to new List using datasheet view would have made copying data easy, but datasheet view is not available in External list. You can create a console application or PowerShell script which will read data from old list and insert it into new External list.
I had a similar issue and while I hope you can find a better solution mine was as follows: I created an external content type for just the values/ID's that should be in the drop down. I then created an external list for just these values/ID's (call this the "Drop down List") I then modified the new and edit aspx forms (for my actual external list ...
I ended up disabling throttling for BCS for now. To do this, I used PowerShell: Instructions I don't like this solution. When I find some bandwidth, I will instead change my query and BDC model to use indexing.
Provided that BCS is connected to the web service and not to the DB directly, you should not need to worry about any changes at all.
You can create a view in sql which will contain friendly display name. Then create external content type based on the view.
When you are configuring a BCS connection via SharePoint Designer you get 3 options, one of which is "Connect with impersonated custom identity." This option allows you to create a SQL Server or other account type (i.e. not a Windows AD account) and store those credentials in the Secure Store Service Application. The Secure Store keeps these credentials in a ...
Top 50 recent answers are included