BookmarkSubscribeRSS Feed

Please provide support for the use of JDBC 'drivers' in SAS/Access.  Providing support for the use of the "generic" JDBC API would provide indirect support for many databases, across many platforms. The cost of providing such support is low, since JDBC is already used for the Hadoop-specific interface.    Having this support would allow us to use the JDBC drivers supplied by many database vendors to process their data in SAS;   SAS could later, if they desired, provide vendor-specific interfaces as they have for DB2 for example, but the JDBC support would allow customers a way to access data prior to that happening. 

This also would be a boon to z/OS customers who sometimes have to use other middleware to access databases on distributed servers.  One site I work at has successfully used the MSSQL JDBC driver from z/OS to read SQL Server data - but not in SAS.

5 Comments
Al_CUA
Fluorite | Level 6
SASKiwi
PROC Star

SAS/ACCESS to JDBC became available in SAS 9.4 M6.

Al_CUA
Fluorite | Level 6

Thanks  

I have added my comment to the wrong request. I am looking to access SAS datasets via a 3rd party tool, using JDBC.

LinusH
Tourmaline | Level 20

I think it's confusing since in this ballot you mention SAS/ACCESS. Access SAS data from other sw is a "totally" different approach/area - so I think you should create a new ballot to clarify this.

Al_CUA
Fluorite | Level 6

Hi 

 Yes, it is different. I have added my comment to the wrong request. I am looking to access SAS datasets via a 3rd party tool, using JDBC.