Connecting DataStage 7.5 on AIX to Oracle 10

apierro1 · Post by **apierro1** » Sat Sep 18, 2010 6:31 pm

I am running DataStage 7.5 on AIX 5.3 and want to connect to an Oracle database on another server. Does an Oracle client need to be installed on the AIX (ETL) server prior to getting DataStage to connect or does DataStage not need a client to make that connection? Are the DataStage oracle drivers enough to connect?

Any help would be greatly appreciated.

Thanks,

chulett · Post by **chulett** » Sat Sep 18, 2010 7:48 pm

You can use the ODBC wire drivers for Oracle and not need a client, or install a client and then use the ODBC non-wire drivers or the native Oracle stages.