Add support to access multiple Microsoft SQL Server databases in a connection

Turribeach
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 1,971 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.

0
0 votes

New · Last Updated

Setup Info
    Tags
      Help me…