HANA SDA to SQL Server with several databases

123 views Asked by At

In my configuration there are several databases available in the "SQL_SERVER" remote source.

SDA only displays the database set as default for the SQL User used at ODBC level

Is it possible to display many databases through one SDA remote source ? Is it possible to have "Database2", "Database3", ... also listed under "SQL_SERVER" ?

Of course, the SQL Server user has access to all those databases.

Thanks for your help.

HANA SDA:

HANA sda : screenshot

1

There are 1 answers

0
HANAGB On BEST ANSWER

While creating the SDI with SQL syntax, specifying ADAPTER "odbc" instead of ADAPTER "mssql"

makes all database available .. :)