Hi All,
I need to extract the data from Universe Database. For that I m using Universe Stage. Here my doubt is should I need to configure (or define ) the systems in the uvodbc.config file in the relevant DataStage project directory on the server or without configuring anything in uvodbc.config can I extract data from the Universe Database like we use ORAOCI Stage to extract data from the Oracle database.
Since using Hashed files and UniVerse are identical, there is no need for you to define ODBC connectivity, just point your jobs at the the hashed files you want and you can access them.
But in the Documentation (For Universe Stages ) it is saying that To connect to a UniVerse data source, the data source must be configured in the uvodbc.config file. Kindly clarify in this regard.
When you installed the server in Unix, odbc is usually installed too and a dsn entry called localuv would have been configured for you. You could use that to load hashfiles as Universe tables in your Universe stage.
HTH