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

[Cocquerel · Accepted solution]

My understanding of the documentation ( https://help.sap.com/docs/SAP_HANA_PLATFORM/6b94445c94ae495c83a19646e7c3fd56/8a6a672f289243a285bc504... ) is that you should have one remote source by database. Each remote source refer to a specific DSN entry where database name is defined.

[gbrochet_2 · Accepted solution]

Hi Michael,

Thanks for your feedback, i'd like to avoid that solution (one DSN par database), because i have many databases to fetch data from.