BookmarkSubscribeRSS Feed
shrutiravi
Calcite | Level 5


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

3 REPLIES 3
LinusH
Tourmaline | Level 20

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.

Data never sleeps
shrutiravi
Calcite | Level 5

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...

Patrick
Opal | Level 21

@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#p0r68n8gtyzjqen1ddl...

 

If you need certainty then contact SAS TechSupport.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 1709 views
  • 0 likes
  • 3 in conversation