1 Report but querying 2 databases

[soundguy]

Hello,

I have a catalog connected to an Oracle database, querying our ERP system. I also have a catalog connected to a MSACCESS database querying the tables.

I need to include data from both databases in 1 report.
How can I do this using Impromptu?

Many Thanks in Advance.

/Phil

 

[infotekguy]

you could create a hotfile from the ms access database and join that hotfile to a table within the oracle database.

 

[GJParker]

You could also link your oracle tables into the access database this will allow you to create a catalog which will give you acces to both databases.

Gary Parker
Systems Support Analyst