topic Re: SAS 9.3 and Oracle 12c database compatibility in SAS Data Management

SAS 9.3 and Oracle 12c database compatibility

shrutiravi — Thu, 15 Jun 2017 06:00:31 GMT

Hi everyone,

I am questioned about the possibility and compatibility of Oracle 12c server database, in SAS 9.3 version.

We only need to extract data from Oracle 12c database using SAS DI Studio 4.6

Please help.

Best regards and thanks everyone.

Ravi

Re: SAS 9.3 and Oracle 12c database compatibility

LinusH — Thu, 15 Jun 2017 08:23:44 GMT

The system requirements says 10g or later. One can assume that Oracle should be backward compatible.

If you already have SAS/ACCESS to Oracle, testing for verification would be the way to go.

If you need to purchase the extra module from SAS, have them verify compatibility in the sales process.

Re: SAS 9.3 and Oracle 12c database compatibility

shrutiravi — Thu, 15 Jun 2017 09:22:19 GMT

Thanks for quick response...

I have SAS/ACCESS Interface to ODBC. Will it do for Oracle.

Currently we are using MS SQL Server as data source

Thanks...

Re: SAS 9.3 and Oracle 12c database compatibility

Patrick — Thu, 15 Jun 2017 10:03:47 GMT

@shrutiravi

If your SAS compute tier is under Windows then I'd expect that you've got everything you need.

ODBC will have some functional restrictions and performance will likely be lower as compared to using the native SAS/Access to Oracle interface.

From the docu:

"ODBC functionality is provided by three components: the client interface, the ODBC driver manager, and the ODBC driver. SAS provides the SAS/ACCESS interface to ODBC, which is the client interface. For PC platforms, Microsoft developed the ODBC Administrator, which is used from the Windows Control Panel to perform software administration and maintenance activities. The ODBC driver manager also manages the interaction between the client interface and the ODBC driver. On UNIX platforms, a default ODBC driver manager does not exist and SAS does not provide a driver manager with SAS/ACCESS to ODBC. For UNIX platforms, you should obtain an ODBC driver manager from your ODBC driver vendor."

http://support.sas.com/documentation/cdl/en/bidsag/65687/HTML/default/viewer.htm#p0r68n8gtyzjqen1ddl4r2q3eh4v.htm

If you need certainty then contact SAS TechSupport.