03-19-2015 08:20 PM
I use SAS EG (4.3) to connect to our SAS AIX server running 9.2. I wanted to access data from Midas Plus (a Xerox product used in healthcare). SAS EG can access these data using the ODBC connection on my PC (the KB_SQL ODBC driver). But it is suggested that the SAS server connect to Midas server for large amounts of data and better control via programming.
I used EG to basically copy tables into the project. This is not ideal. I was told by our SAS Unix Admin that there is no way to connect Midas Plus (32 bit) with our 64 bit AIX SAS server directly. Is this correct? A 64bit SAS server cannot use SAS/Access and ODBC to connect to our Midas server? If my SAS UNIX administrator is correct I will continue to drag data into my EG Projects. But I feel that this connectivity should exist, that the SAS/Access product we have on the AIX machine which connects us to Teradata, DB2 and Oracle, can be adjusted to include ODBC. Does anyone know if this is possible?
03-27-2015 11:32 PM
I did a quick Google search on the KB_SQL ODBC driver and it appears to work on Windows only. If this is correct and there is no other compatible ODBC driver that will work on AIX then I suspect your SAS Unix Admin is right.
03-28-2015 12:33 AM
The Midas Plus homepage Integrated Medical Software and Solutions for Hospital Administrative Data Analysis has unfortunately a purely marketing focus and doesn't provide technical information.
This is not about the SAS/Access to ODBC engine but about what ODBC drivers Midas provides in order for any other application to connect to it - and it appears there isn't any for AIX 64bit.