Hello all,

Is anyone running SAS with Ingres Net?
I've located some information and would appreciate any tips before I head
down possibly the wrong direction.

Previously our client was running data extracts to text then massaging and
copying data to the analysis/reporting machine. They are upgrading to SAS
9.2 and moving to Solaris 10 X64 on VMware. I expect the old data extract
method will migrate without a problem but I would like to investigate using
a direct Ingres Net connection. The SAS consultant has asked for ODBC on
Solaris X64 - I'm getting him to check if they still have support for Ingres
Net.

According to SAS documentation, earlier versions supported CA-OpenIngres,
but the latest release notes do not mention Ingres so I expect I will end up
using ODBC. SAS have quoted existing customer sites using SAS with Ingres.
eg "... ability to draw data from virtually any source, we now have a single
portal through which to access data contained in our legacy Ingres database,
our new Oracle database and numerous other sources that all contribute to a
complete data view."

Here are some promising links I've found.

http://www.sas.com/success/statefleet.html
http://www.sas.com/success/gloucestershireconstab.html
http://support.sas.com/resources/sysreq/
http://community.ingres.com/wiki/Ingres_UNIX_ODBC


Paul

Hi Paul,

We have a customer who are extracting data to SAS from Ingres through
Ingres NET. They are in the process of upgrade/migrate Ingres from II
2.6 (not supported by SAS) to Ingres 9.2 on 64bit Linux and they have
successfully tested to extract data from Ingres 9.2.
Regards,
Magnus Gabrielson, Tieto Sweden