Page 1 of 1

Cross Table Analysis across multiple databases

Posted: Thu Jun 08, 2006 7:56 am
by dsdev750
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.

Posted: Thu Jun 08, 2006 2:54 pm
by ray.wurlod
I can't see why not. All data access is via ODBC, so all you should have to do is to define multiple DSNs.

Posted: Thu Jun 08, 2006 3:07 pm
by dsdev750
Thanks Ray. I checked the Cross Table Analysis and found that it does have the functionality of doing cross table analysis across multiple databases.