How to access Sybase ASE and IQ databases in one job

peter_dickinson · Post by **peter_dickinson** » Thu Mar 10, 2005 1:03 am

Hi there,

My client is wanting to create jobs that source data from a Sybase ASE database (version 12.5) and load it into a Sybase IQ database (version 12.6).

We were planning to use the SYBASE OC plug-in stage to access the databases.

The problem appears to be that the SYBASE environment settings in dsenv, can only point to one environment at a time (so, currently we can log onto the ASE database but NOT the IQ database).

Anyone have any suggestions as to how we can achieve this?

ArndW · Post by **ArndW** » Thu Mar 10, 2005 1:45 am

Hello Peter,

without looking into an elegant way to perhaps overcome this limitation, could you use an ODBC connection for one of the Sybase connections? It might not be as fast, but at least it would give you the functionality you require.

roy · Post by **roy** » Thu Mar 10, 2005 6:35 am

Hi,
you could configure your OC to the source DB and use the command line bulk loader from command line to load the data you prepared using the bulk loader stage with manual option.

IHTH,