How to configure ODBC connection to MySQL using DS and Linux

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
Luk
Participant
Posts: 133
Joined: Thu Dec 02, 2004 8:35 am
Location: Poland
Contact:

How to configure ODBC connection to MySQL using DS and Linux

Post by Luk »

Can you tell me what I must install and what I must configure and how to connect to MySQL server on remote machine using DataStage 7.5 under Linux RedHat??

Rdds
Luk
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post by roy »

Hi,
odbc configuration files for DS are .odbc.ini & uvodbc.config.
both reside in the engine directory and the later of the 2 is also in each project directory.
read the dsadmgde.pdf in your client install directory under the docs directory for more info.
if you have a relevant datadirect driver with DS you can use it or try configuring 3rd party drivers.

IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.

Search before posting:)

Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Image
Post Reply