Page 1 of 1
ODBC connectivity to datastage server
Posted: Mon Dec 22, 2008 1:12 am
by prasson_ibm
Hi,
Can any one tell me the steps of ODBC connectivity to datasgate server(my datastage PX server version is 7.5.1)?
thanks in advance
Posted: Mon Dec 22, 2008 1:29 am
by ray.wurlod
Do you mean TO your DataStage server from something external, or from your DataStage server to some data source?
The first would require an ODBC driver for DataStage Engine, and no such animal exists. Nor is ever likely to.
Posted: Wed Dec 24, 2008 4:25 am
by prasson_ibm
ray.wurlod wrote:Do you mean TO your DataStage server from something external, or from your DataStage server to some data source?
The first would require an ODBC driver for DataStage Engine, and no such animal exis ...
Data stage server means it is server to some data source and from where i can get ODBC driver,is it autometically installed during datastage installation...???
Posted: Wed Dec 24, 2008 4:53 am
by vasa_dxx
You need to explicitly Install ODBC pack for different DBs. For Eg: MS Excel, Oracle, Teradata etc.
Posted: Wed Dec 24, 2008 5:32 am
by prasson_ibm
vasa_dxx wrote:You need to explicitly Install ODBC pack for different DBs. For Eg: MS Excel, Oracle, Teradata etc.
Thanks for Quick reply,is it not available with datastage packages..???
Posted: Wed Dec 24, 2008 5:55 am
by vasa_dxx
check in ODBC admin for available ODBC drivers installed
Posted: Wed Dec 24, 2008 2:25 pm
by ray.wurlod
Many ODBC drivers (sourced from DataDirect) ship with DataStage; these are to be found in a directory called branded_odbc. There are plenty of "read me" files there. For any other connectivity you will need to obtain UNIX-based ODBC drivers; there are several vendors which a simple internet search should be able to find.