DataFlux Connecting to Multiple Databases Through One ODBC Connection

BrettRankin — Tue, 23 Feb 2016 12:36:54 GMT

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

Re: DataFlux Connecting to Multiple Databases Through One ODBC Connection

SASKiwi — Tue, 23 Feb 2016 19:02:11 GMT

I don't have a working Dataflux environment to check this out but one option you could consider is creating a table view in SAS based on a single ODBC SQL passthru query using multiple databases.

Dataflux can happily read SAS tables so I see no reason it could not read a SAS view.

topic DataFlux Connecting to Multiple Databases Through One ODBC Connection in SAS Data Management

DataFlux Connecting to Multiple Databases Through One ODBC Connection

Re: DataFlux Connecting to Multiple Databases Through One ODBC Connection