UniData DB connection in v7.5.2

Griffin07 · Post by **Griffin07** » Tue Oct 27, 2009 1:26 pm

Hi, what DB stage can I use to connect to a UniData Database, there is no UniData stage in parrellel, is ODBC the option to use, and if so is there any special setup required in the odbc.ini?

thanks

hiral.chauhan · Post by **hiral.chauhan** » Tue Oct 27, 2009 4:27 pm

I think, from what it sounds like, you'll have to go with the ODBC Connector or the ODBC Enterprise stage.

Secondly, you will have to be able to establish a connection between the Datastage server and the Database that you're using. For that, you'll have to configure the settings in the .odbc.ini file..

Does that make sense?

ray.wurlod · Post by **ray.wurlod** » Tue Oct 27, 2009 5:36 pm

And you will also need to purchase a third party UNIX-based ODBC driver for Unidata - none ships with DataStage.

An easier approach would be to embed a Unidata stage in a server shared container and to incorporate the same in your parallel job.