access universe

[andy心&#262]

I am try to access the datastage universe by ODBC.
I installed a universe database ODBC driver.
But I don't know what is the datastage default account and password.

When I develop a server job using Universe stage, the account and password is omit.

Can anyone can help me ?


Thanks a lot!

[chulett]

What "universe database" are you trying to access? Why not explain what you are trying to accomplish - for example, do you have an external Universe source you need to connect to? DataStage hasn't had Universe under the covers for umpty.

[ray.wurlod]

User and password are greyed out if you choose localuv as the DSN, because you are already connected to localuv; it is the schema of the project itself.

[andy心&#262]

Yeah, I just want to see the data in datastage universe.
Not other universe database.

I select localuv, the account and password is omitting.

I want to access the universe by odbc.
I have download and install the Universe odbc driver.

In my opinion, I can access the datastage universe.
But, I don't know how to fill the universe information.

I look into the UV.ACCOUNT file, there are accouts of UV, uv and projects names.
I also check VOA and other file, but I don't know what is the key.

I have no idea about the universe database.
I want to see the meta data of datastage.
We don't bye the meta stage. I thought, we can get the datastage meta data if we can access the universe via ODBC.
Then I will use other tools to query the data form the universe database.

Thank you so much!

[Nagaraj]

if you want to just view the metadata then do the following on the server side

Please login to DS server as DS administrative account, cd to $DSHOME,
and execute commands below:
1) . ./dsenv #read as dot_space_dot_slash_dsenv
2) bin/dssh ( this will take you to the database)
3) LIST UV.ACCOUNT
LIST UV_SCHEMA

[andy心&#262]

Yeah, I know this can get datastage meta data from the universe database.

I hope easily to access the datastage meta data, not type commands every time.

Can I export data from the universe into other database, just like oracle or DB2.

I have no idea about the universe.

Thanks a lot.

I have developped data stage job to transform the hash files into sequence file.
So, I can get the information from the UV.ACCESS,UV.ACCOUNT,UV.FLAVOR,VOC,VOCLIB files.

[andy心&#262]

I have configure the uci.config file
<localuv>
DBMSTYPE = UNIVERSE
network = LAN
service = uvserver
host = 127.0.0.1

It is a ODBC driver.

So, the Universe server is "loacaluv"
I type a datastage project name as the universe database name.

Now I need the account and password.

I try UV,uv and others, failed.

[andy&#24515;&#262]

I set the server "localuv"
The database is 'CATALOG" or datastage project names.
The database name is "UV","uv", or datastage project names.

But, I don't know the password!

[chulett]

Seems to me you are making this more complicated than it needs to be. What exactly do you think you need to see/do there?

ps. You don't need a userid or password for 'localuv'. Nor do you need ODBC.

[ray.wurlod]

Use a UV stage rather than an ODBC stage. A UV stage uses ODBC protocols, but is native to UniVerse and "understands" some of the unique features of the database's capabilities. The DSN localuv has its user ID and password disabled because it is already connected.

Having established that, can you please be more precise about what you want to achieve? Most of the structure of a DataStage project database is neither documented nor supported by metadata - this was a deliberate decision made by the vendor. So most of your ODBC discovery functions aren't going to work in any case. Workarounds are needed. When we learn more detail of your requirements we may be able to offer better targeted advice.

[andy&#24515;&#262]

I want to access the universe database via ODBC.
I want to see or export all data of the universe through GUI tools.

If I can access the universe by ODBC, I needn't type command every time or develop a job using universe stage.

Is it possible to access the universe via ODBC?


Thank you so much!

[ray.wurlod]

The only way you will be able to access the DataStage database through an ODBC client is to obtain an ODBC driver for UniVerse. One is available from IBM, others are available from third party providers. But remember that you have been warned that much of the DataStage repository metadata has been deliberately hidden from view, so you will not be able to ascertain the table names or the record structures in those tables.

[andy&#24515;&#262]

yeah, I have installed the universe odbc driver download from IBM.

But I have some trouble when I configure the ODBC connnection to universe.

[ray.wurlod]

OK, when you go into Control Panel/ODBC Administrator to configure the DSN, what values do you put into the Configuration Editor (opened by clicking the Configure button)? Take a look at either of the examples (UV/ODBC Sales Sample or UV/ODBC Service Sample - they are User DSNs) that installed when you installed the driver; you may get some more ideas from those. There is one extra step required on the server side - you need to go to the HS.ADMIN account and configure your project account for ODBC access from the HS.ADMIN menu.

[andy&#24515;&#262]

I add a ODBC DSN using "IBM Universe ODBC Driver"

I need to fill Server, Database, User and password information.

I choose the server as "localuv", "localuv" is defined in the C:\IBM\UniDK\Config\uci.config file.

<localuv>
DBMSTYPE = UNIVERSE
network = LAN
service = uvserver
host = 127.0.0.1

Then, I find User in the universe dabase is "UV","uv" and project names.
Now, I need the Database and password.

Thanks a lot!