https://community.hpe.com/t5/operating-system-hp-ux/connecting-to-universe-db/m-p/3119753#M802144 We are currently running UniVerse 10 and Oracle 8.1.7 on two seperate HP-UX 11.0.<BR /><BR />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).<BR /><BR />We want to be able to run cron-jobs to update our Oracle tables with data from UniVerse.<BR /><BR />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.<BR /><BR />Thanks Fri, 14 Nov 2003 12:41:12 GMT MIS_6 2003-11-14T12:41:12Z https://community.hpe.com/t5/operating-system-hp-ux/connecting-to-universe-db/m-p/3119753#M802144 We are currently running UniVerse 10 and Oracle 8.1.7 on two seperate HP-UX 11.0.<BR /><BR />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).<BR /><BR />We want to be able to run cron-jobs to update our Oracle tables with data from UniVerse.<BR /><BR />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.<BR /><BR />Thanks Fri, 14 Nov 2003 12:41:12 GMT https://community.hpe.com/t5/operating-system-hp-ux/connecting-to-universe-db/m-p/3119753#M802144 MIS_6 2003-11-14T12:41:12Z https://community.hpe.com/t5/operating-system-hp-ux/connecting-to-universe-db/m-p/3119754#M802145 UniVerse is now owned by IBM:<BR /><BR /><A href="http://www-3.ibm.com/software/data/u2/universe/" target="_blank">http://www-3.ibm.com/software/data/u2/universe/</A><BR /><BR />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.<BR /><BR />HTH<BR />mark Fri, 14 Nov 2003 12:56:50 GMT https://community.hpe.com/t5/operating-system-hp-ux/connecting-to-universe-db/m-p/3119754#M802145 Mark Greene_1 2003-11-14T12:56:50Z