Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
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