New answers tagged external-content-type
Once you have edited the ECT in SPD 2010. You don't need to delete the external list and recreate it. Just modify the list view in SP and add the additional columns to the view.
As it turned out, I needed to configure an External Content Type Profile Page Host within the Business Data Connectivity Service. When the ECT Profile Page Host was configured, I could connect to the database and see the tables from the database within SharePoint Designer.
The columns defined as unique (so the BDC identity was built on that colums) were not unique in the sql view, that why I had not unique BDCIdentity.
SharePoint Designer does not use the Secure Store connection. Try creating the ECT first by connecting with user's identity. Once the ECT is created, modify the properties to use the Secure Store application ID.
Another option is to connect through WCF Service: https://msdn.microsoft.com/en-us/library/office/ee556831(v=office.14). WCF on AWS: https://forums.aws.amazon.com/thread.jspa?messageID=323145
Top 50 recent answers are included