cancel
Showing results for 
Search instead for 
Did you mean: 

Connecting to UniVerse db

MIS_6
Occasional Visitor

Connecting to UniVerse db

We are currently running UniVerse 10 and Oracle 8.1.7 on two seperate HP-UX 11.0.

We want to be able to connect to UniVerse from Oracle Server using C and ODBC (if possible - unless this is not possible and/or someone has a better idea).

We want to be able to run cron-jobs to update our Oracle tables with data from UniVerse.

What is the best way of doing this? And how do you set up the UniVerse ODBC on the HP and then where can I find the functions and procedures available to help me connect and do all that other good stuff.

Thanks
1 REPLY
Mark Greene_1
Honored Contributor

Re: Connecting to UniVerse db

UniVerse is now owned by IBM:

http://www-3.ibm.com/software/data/u2/universe/

There is an ODBC driver for UniVerse (and a JDBC one too, if I recall correctly), but you have to setup the Universe tables to be sql-compliant. This generally involves "flattening" the file; i.e., normalizing the data by pulling any sub-values out into a new table. You can also check with your application vendor, they may have gone down this road already.

HTH
mark
the future will be a lot like now, only later