SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

ODBC or SAS/Access connectivity from AIX to Midas Plus server

Reply
New Contributor
Posts: 4

ODBC or SAS/Access connectivity from AIX to Midas Plus server

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?

@agdesilva
Super User
Posts: 3,111

Re: ODBC or SAS/Access connectivity from AIX to Midas Plus server

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.

Respected Advisor
Posts: 3,895

Re: ODBC or SAS/Access connectivity from AIX to Midas Plus server

To add to

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.

Ask a Question
Discussion stats
  • 2 replies
  • 532 views
  • 6 likes
  • 3 in conversation