access universe
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 18
- Joined: Tue Oct 28, 2008 2:31 am
access universe
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!
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!
![Confused :?](./images/smilies/icon_confused.gif)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 18
- Joined: Tue Oct 28, 2008 2:31 am
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!
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!
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
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
-
- Participant
- Posts: 18
- Joined: Tue Oct 28, 2008 2:31 am
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.
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.
-
- Participant
- Posts: 18
- Joined: Tue Oct 28, 2008 2:31 am
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.
<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.
-
- Participant
- Posts: 18
- Joined: Tue Oct 28, 2008 2:31 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 18
- Joined: Tue Oct 28, 2008 2:31 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 18
- Joined: Tue Oct 28, 2008 2:31 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 18
- Joined: Tue Oct 28, 2008 2:31 am
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!
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!