topic Re: Why purchase SAS/ACCESS to ORACLE in SAS Programming

Why purchase SAS/ACCESS to ORACLE

Edwin — Thu, 03 Jun 2010 07:33:30 GMT

We already have licenses for SAS/ACCESS to OLEDB and SAS/ACCESS to ODBC.
What are the benefits when we additionally purchase a SAS/ACCESS to ORACLE license ?

I tried to find extra functionality within the documentation but it's hard to find any specific differences.

One difference could be performance - access through OLEDB can be slower but will this be significant (in reading from and writing to the database)?
Are there other benefits when using the ACCESS to ORACLE license?

Re: Why purchase SAS/ACCESS to ORACLE

sbb — Thu, 03 Jun 2010 11:16:50 GMT

You might find useful reference information on the SAS support website at http://support.sas.com, either using the website SEARCH facility or consider the Google advanced search argument below:

+"sas/access" +oracle +"ole db" +comparison site:sas.com

Scott Barry
SBBWorks, Inc.

Re: Why purchase SAS/ACCESS to ORACLE

LinusH — Thu, 03 Jun 2010 17:36:55 GMT

Sounds a bit odd looking for a reasons for buying a product. It usually starts with some kind of need.
If you aren't clear on what the demands are, I suggest that you start off by using OLEDB/ODBC, and see how that works.

/Linus

Re: Why purchase SAS/ACCESS to ORACLE

Patrick — Mon, 07 Jun 2010 13:37:42 GMT

I have to agree with Linus.

Anyway:
The Oracle Access module would give you a better performance and optimised access.
I also believe that SAS SQL code is better translated into ORACLE SLQ code. Also things like bulk loading might not be possible without the ORACLE Access module.

If you want to know more: I'm sure that SAS sales and pre-sales are more than happy to list all the advantages you would get with the Access for Oracle module 😉

HTH
Patrick

Re: Why purchase SAS/ACCESS to ORACLE

Edwin — Thu, 10 Jun 2010 11:53:46 GMT

Linus,

I agree. It does sound odd.

We already purchased the Oracle license on top of the OLEDB and ODBC licenses (but our company's contracts representative, can't tell me the exact reason). I would have suggested exact the same if I would have been asked on beforehand.

With current financial circumstances we won't easily get the resources to buy an additional SAS license I would like.
But maybe if we can trade-in this Oracle license for another, I could build a case to get the other license. So I'm looking for possible drawbacks when using OLEDB instead of ACCESS to Oracle.

Edwin

Re: Why purchase SAS/ACCESS to ORACLE

polingjw — Tue, 20 Jul 2010 19:45:11 GMT

One big advantage is the ability to utilize ORACLE hints. This paper is a good reference: www.nesug.org/proceedings/nesug05/io/io8.pdf