BookmarkSubscribeRSS Feed
Edwin
Calcite | Level 5
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?
5 REPLIES 5
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
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.
LinusH
Tourmaline | Level 20
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
Data never sleeps
Edwin
Calcite | Level 5
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
Patrick
Opal | Level 21
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
polingjw
Quartz | Level 8
One big advantage is the ability to utilize ORACLE hints. This paper is a good reference: www.nesug.org/proceedings/nesug05/io/io8.pdf

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 Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 5 replies
  • 807 views
  • 0 likes
  • 5 in conversation