How to connect to multiple database on single connection

Javen2867

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.

Turribeach

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:

https://community.dataiku.com/t5/Product-Ideas/Add-support-to-access-multiple-Microsoft-SQL-Server-databases-in/idi-p/38157

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.