0

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

Sandra Rossi
  • 11,934
  • 5
  • 22
  • 48
HANAGB
  • 13
  • 4

1 Answers1

0

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

makes all database available .. :)

HANAGB
  • 13
  • 4