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 then I thought well, I'll create it as an external content type (as a SQL connection) but get this error: Access denied by Business Data Connectivity
Does BCS have to be enabled somewhere is site collection settings? Also, in just general terms, what is the difference between an external data source and an external content type? When do you use one vs. the other? Will I be able create a lookup field to an external content type?
Thanks for any help you can give