I want to create an external content type based on SQL Server tables. My external content is a list of Cats and its source is a database table also named Cats.
However, I have a different Cats table in different database catalogues (the name of the table might also vary slightly) and I would like to be able, at runtime (if possible), to change the catalog and table name, the external entity is associated to. Is this possible?
I'm using Sharepoint 2010.