SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

DataFlux Connecting to Multiple Databases Through One ODBC Connection

Reply
New Contributor
Posts: 4

DataFlux Connecting to Multiple Databases Through One ODBC Connection

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

Super User
Posts: 3,260

Re: DataFlux Connecting to Multiple Databases Through One ODBC Connection

Posted in reply to BrettRankin

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.

Ask a Question
Discussion stats
  • 1 reply
  • 249 views
  • 0 likes
  • 2 in conversation