topic Re: SAS/ACCESS to ODBC on Linux and IBM U2 UniVerse in Administration and Deployment

SAS/ACCESS to ODBC on Linux and IBM U2 UniVerse

Timmy2383 — Thu, 19 May 2016 20:37:36 GMT

Anyone familiar with IBM U2 UniVerse? I am not familiar with it at all. I recently found out that one business unit has a connection to said database through Windows. They want to migrate to our Linux Grid environment, which has SAS/ACCESS to ODBC, SAS/ACCESS to MSSQL Server and SAS/ACCESS to Oracle, but based on the configuration info their admin sent me it looks like I might need additional drivers installed.

Also, some of the values for the data source configuration don't directly translate were I to try and plug them into a typical MS SQL Server type entry in odbc.ini.

Re: SAS/ACCESS to ODBC on Linux and IBM U2 UniVerse

SASKiwi — Thu, 19 May 2016 21:52:11 GMT

I haven't used Universe either but I've always found this site useful for figuring out database connection strings. You could try experimenting with these in ODBC.ini and/or the SAS NOPROMPT option:

https://www.connectionstrings.com/universe/

Re: SAS/ACCESS to ODBC on Linux and IBM U2 UniVerse

Timmy2383 — Thu, 19 May 2016 21:55:07 GMT

Thanks! I will check it out when back in the office and do some testing.

Re: SAS/ACCESS to ODBC on Linux and IBM U2 UniVerse

Timmy2383 — Fri, 20 May 2016 16:03:21 GMT

Ok, I got official word from SAS TS that I have to get the U2 UniVerse ODBC driver from a vendor (i.e. Rocket, Progress/DataDirect, EasySoft). Once I have that driver installed I believe they have something called "uci' client that you use to set up connection information.