Add support to access multiple Microsoft SQL Server databases in a connection
Turribeach
Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,090 Neuron
Currently it is not possivle to multiple Microsoft SQL Server databases in a single connection. Leaving the database field empty in the Dataiku Connection only returns system tables. And if a particular database is set in the Dataiku Connection then only data for that database can be accessed. Dataiku suggested work around is to use views in a single database to be able to refer to tables and views in other databases. But this work around is neother user friendly nor easy to maintain. So please add proper support to allow connections to use multiple databases.