Is ODBC required for Database communications in DataStage?
Posted: Tue Nov 02, 2004 1:22 pm
My apologies if this topic has already been covered, but I'm not the most adept at using the forum search. My question is if I have to use ODBC as my go between for communications between the DataStage Server and my Oracle Database.
I understand I pretty much need it to allow my Clients to access meta data when creating a new map, but for the actual run of an ETL process on my Unix Server, do I really need ODBC or can I do a direct Oracle connection into the Database? I do have the Oracle 9i plugin installed and it is available, but from what I've tested the Database connection definitions are still being pulled from ODBC. I don't have a reason to bypass ODBC currently, but I had some concerns in future with Performance of my maps and figure a native connection would perform better than an ODBC to Oracle connection. Any information on this topic would be greatly appreciated.
I understand I pretty much need it to allow my Clients to access meta data when creating a new map, but for the actual run of an ETL process on my Unix Server, do I really need ODBC or can I do a direct Oracle connection into the Database? I do have the Oracle 9i plugin installed and it is available, but from what I've tested the Database connection definitions are still being pulled from ODBC. I don't have a reason to bypass ODBC currently, but I had some concerns in future with Performance of my maps and figure a native connection would perform better than an ODBC to Oracle connection. Any information on this topic would be greatly appreciated.