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

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:

What about using DataStage ?
EGormlyAuthor Commented:
Doesn't seem to fit.

Unless I am misunderstanding it?
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

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.
EGormlyAuthor Commented:
where can I find that?
EGormlyAuthor Commented:
although not entirely what I am looking for, it's a good pointer towards the right direction.!
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.