1)Create SharePoint Provider Hosted App
2)Right Click this Project to Add External Content type using Odata
3)Create Secure Store Service Target Application (in case of FBA Authentication) else enable RevertToSelf Authentication mechanism (in case of Windows Authentication).Revert To Self Authentication needs to be enabled explicitly for Business Connectivity Service Application using Powershell
4)Create New-SPODataConnectionSettings Jump For BCS using Powershell,
This will help to use Secure Store Credentials to be associated with BCS external content type
Look at the Output of this command
5)In Visual Studio ,Select .ect (BDC model file) , select the Designer View of ECT then Select the Properties , and Update the Properties (obtained in the step 4)
To be continued for the deployment part...
<cross-posted from
here>