How to connect to Unidata using ODBC

jacksamsula · Post by **jacksamsula** » Wed Jul 25, 2012 2:50 pm

I wish to connect to Unidata via ODBC using Rocket Software's Virtual Schema Generator. The documentation assumes that the user will be using an SQL product such as Access or Visual Basic and, therefore, the documentation assumes that the user will create SQL ready normalized views on the Unidata server. However, I would think that this should not be necessary for Datastage as the Unidata stage does not expect normalized data. Does anyone have experience doing this and should I be correct in thinking I should not have to create views on the Unidata server?

ray.wurlod · Post by **ray.wurlod** » Wed Jul 25, 2012 5:29 pm

Once you've run VSG over your Unidata account it should be able to be accessed via the UniODBC driver. Therefore it will be necessary to install that driver on your DataStage Engine tier. Do this from the U2 clients media (usually CD or DVD).

Note that the UniData stages in DataStage do not use an ODBC driver; the above process configures your account so that it can be accessed using ODBC (from any ODBC client). In DataStage you'd use some form of ODBC stage, such as ODBC Connector.

There should be no need to do any of this if you stick with the UniData stage.