HANA SDA to MSSQL with multiple database

[gbrochet_2]

Hi,

I have a SDA remote source (MSSQL) from which i'd like to consume several databases.

By default, HANA studio only display the default database of the SQL user (used by SDA>ODBC>MSSQL)
"DataBase1" in my screenshot

The sql user also have acces to "DataBase2", "DataBase3" , ...

Is it possible to have SDA list all those databases ?

Or can i use the equivalent of SQL command "use database" to switch database ?

Best regards, and thanks for your help

[gbrochet_2]

As an alternate solutions to several DSN (one per database) as propose per Mickael, i might use a utility database (databaseX) holding views pointing to database1,database2,database3 etc ...