Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Hello,
We are currently configuring our connections and were wondering if it was possible to configure connections to access multiple databases? We have multiple databases, each with a large number of tables on a single server, but we don't want our users to have to maintain a large set of credentials. Is it possible to add multiple database/catalogs to a single connection? Leaving the database field blank only returns the system tables for the server.
If you are talking about Microsoft SQL Server then this is not supported I am afraid. We have asked for this for years and it has never been implemented. Feel to chase for Customer Success Manager and see if you can have any traction. You can also vote for this item I just raised about this:
The only workaround I am aware of is to use views in a single database to be able to refer to tables and views in other databases.