Pulling Data from a remote IBM Universe database

I need to pull data from a remote IBM Universe database (10.1.2 is the version I believe)
"remote" meaning another server in our local network.
I would imagine the only way to do this is ODBC based.

The only method I have now is to pull the data from a IBM based terminal program on the server itself and save it as a local file that then has to be transported to another server .. This all has to be done by a human, so it is tedious and error prone.

I have looked into Products like MITTS and some other tools but they seem to be reporting only, I need to pull actual data from the Universe database tables.

I have searched and searched and can only seem to find reporting type solutions.


Open in new window

EGormlyAsked:
Who is Participating?
 
stevengmoreauConnect With a Mentor Commented:
The unijdbc.jar file is installed onto your system when you install UniDK, from the Universe installation CD. If the CD is unavailable you should be able to download the clients for Universe from here:

http://www14.software.ibm.com/webapp/download/search.jsp?go=y&rs=u2trials
0
 
Sowmya_KCommented:
What about using DataStage ?
0
 
EGormlyAuthor Commented:
Doesn't seem to fit.

Unless I am misunderstanding it?
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
stevengmoreauCommented:
There is a JDBC driver available for Universe that can be used to run SQL statements against Universe files. It is a solution that is easy to implement and flexible for gaining standard access to your Universe data.
0
 
EGormlyAuthor Commented:
where can I find that?
0
 
EGormlyAuthor Commented:
although not entirely what I am looking for, it's a good pointer towards the right direction.!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.