Creating external content type and external list is rather straight forward. But then, I came across this “Access denied by Business Data Connectivity” today. I got this error even I am using the site collection admin account.
The solution is to configure the permission on the BCS Entity. Found the solution from this site: http://zimmergren.net/technical/access-denied-by-business-data-connectivity-solution