Cross Table Analysis across multiple databases

dsdev750 · Post by **dsdev750** » Thu Jun 08, 2006 7:56 am

Hi,

Is it possible to perform a CrossTable Analysis across multiple Sybase databases on the same server.
I need to write an extract process that extracts data from multiple databases. I am not too familiar with the data at this point and am wondering if it's even possible to perform such an analysis.

Thanks.

ray.wurlod · Post by **ray.wurlod** » Thu Jun 08, 2006 2:54 pm

I can't see why not. All data access is via ODBC, so all you should have to do is to define multiple DSNs.

dsdev750 · Post by **dsdev750** » Thu Jun 08, 2006 3:07 pm

Thanks Ray. I checked the Cross Table Analysis and found that it does have the functionality of doing cross table analysis across multiple databases.