ODBC connectivity to datastage server

prasson_ibm · Post by **prasson_ibm** » Mon Dec 22, 2008 1:12 am

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

ray.wurlod · Post by **ray.wurlod** » Mon Dec 22, 2008 1:29 am

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.

prasson_ibm · Post by **prasson_ibm** » Wed Dec 24, 2008 4:25 am

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...???

vasa_dxx · Post by **vasa_dxx** » Wed Dec 24, 2008 4:53 am

You need to explicitly Install ODBC pack for different DBs. For Eg: MS Excel, Oracle, Teradata etc.

prasson_ibm · Post by **prasson_ibm** » Wed Dec 24, 2008 5:32 am

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..???

vasa_dxx · Post by **vasa_dxx** » Wed Dec 24, 2008 5:55 am

check in ODBC admin for available ODBC drivers installed

ray.wurlod · Post by **ray.wurlod** » Wed Dec 24, 2008 2:25 pm

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.