Connecting to UniVerse db

[MIS_6]

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

[Mark Greene_1]

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