Hi Everyone,
I wanted to know if we can connect to multiple databases using one odbc connection in the DataFlux tool.
This question was posed to me from an analyst who wants to query a parallel datawarehouse that uses tables from 2 different databases that are on the same server. In his query, he would ndicate the database, schema, and tables in his 'From" statement...I believe he can do this easily in SAS but not sure if its the same in DataFlux. Most times, we ask our analysts to indicate the database when setting up the ODBC connection in DataFlux...that is why I am asking.
Thanks for any help.
Brett
Select a.*
from database1.schema1.table1 a inner join
database2.schema2.table2 b
on a.field1 = b.field1