Please help me understand ODBC non-wired connectivity

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
mavrick21
Premium Member
Premium Member
Posts: 335
Joined: Sun Apr 23, 2006 11:25 pm

Please help me understand ODBC non-wired connectivity

Post by mavrick21 »

Hello,

I don't understand why ODBC non-wired connectivity is required when native DB API client already exists. Doesn't ODBC non-wired connect to DB via the installed native DB API client? In which scenario(s) would one prefer ODBC non-wired connectivity over native DB API client.

Thank you
asorrell
Posts: 1707
Joined: Fri Apr 04, 2003 2:00 pm
Location: Colleyville, Texas

Post by asorrell »

Maverick,

I'm assuming your server is UNIX-based (as was indicated). DataStage ships wire protocol drivers from DataDirect as part of the product to provide high-speed ODBC access. This eliminates the need for database client libraries such as Oracle SQL*Net or DB2 Connect.

However, with that said, I always use client libraries and native stages (ie: DB2 stage, Oracle Enterprise stage, etc.) if they are available. Those are highly tuned and usually provide superior performance.

ODBC is truly native to SQL Server, and of course must be used in that instance. I also use ODBC to access Progress and some other older databases that aren't directly supported by DataStage. Other than that, I stay away from ODBC as it isn't the fastest way to transfer data.

I hope this helps, if it doesn't, please add more specifics or examples to your question.
Andy Sorrell
Certified DataStage Consultant
IBM Analytics Champion 2009 - 2020
mavrick21
Premium Member
Premium Member
Posts: 335
Joined: Sun Apr 23, 2006 11:25 pm

Post by mavrick21 »

Thanks Andy!
Post Reply