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.
Is ODBC required for Database communications in DataStage?
Moderators: chulett, rschirm, roy
Is ODBC required for Database communications in DataStage?
Andrew Thorne
Lead Software Engineer
PeopleSoft Technical Architecture
Enterprise Rent-A-Car
Lead Software Engineer
PeopleSoft Technical Architecture
Enterprise Rent-A-Car
-
- Premium Member
- Posts: 483
- Joined: Thu Jun 12, 2003 4:47 pm
- Location: St. Louis, Missouri USA
We are using the DRS stage for our maps based on documentation from PeopleSoft. In the background I still have to put a valid dsn in the .odbc.ini under the $DSHOME. So I guess I must have something configured incorrectly, or we are not using the DRS correctly. Is there a delievered document for the product that I can read through to learn more about the proper setup and use of DRS?
Andrew Thorne
Lead Software Engineer
PeopleSoft Technical Architecture
Enterprise Rent-A-Car
Lead Software Engineer
PeopleSoft Technical Architecture
Enterprise Rent-A-Car
-
- Premium Member
- Posts: 483
- Joined: Thu Jun 12, 2003 4:47 pm
- Location: St. Louis, Missouri USA