Productos y Soluciones / Enterprise Data Access

SAS/ACCESS® Interface to Oracle

Una manera conveniente de tener acceso a sus aplicaciones de almacenamiento de datos.

Las aplicaciones de almacenamiento de datos, están diseñados para integrar la base de datos, el servidor y el almacenamiento en una sola unidad. Están diseñados para reducir o eliminar las complejidades asociadas con la instalación, configuración, puesta en marcha y administración del hardware, el sistema operativo y el software de appliances mientras que se procesan terabytes de datos con solicitudes de extrema escalabilidad.

SAS/ACCESS® Interface to Oracle Exadata es una solución inmediata que proporciona conectividad directa entre SAS y Oracle Exadata Database Machine para aprovechar las utilidades de Oracle Exadata y obtener cargas y extracciones optimizadas.


  • Integrate data stored in Oracle with data from other sources.
  • Access data directly, easily and securely with a native interface.
  • Gain faster performance and reduce network traffic.
  • Support both technical and business users.

Leer más


  • Seamless and transparent data access
  • Flexible query language support
  • Performance features
  • Metadata integration
  • Optimization

Leer más


  • Integrate data stored in Oracle with data from other sources. SAS/ACCESS engines provide seamless and transparent read/write/update access to more than 60 data sources, including relational and nonrelational databases, PC files and data warehouse appliances. SAS Data Surveyors are specialized engines specifically for accessing enterprise applications. This enables you to integrate data stored in your Oracle database with other data and easily use all of your enterprise data with SAS Analytics to gain new insights for your organization.
  • Access data directly, easily and securely with a native interface. No SQL expertise or custom coding of extractions is required. You get a high degree of control over data security because SAS/ACCESS honors and augments the native security of the target data source. SAS enables a transparent approach by making data sources appear as though they are a native SAS data type, which facilitates interaction with SAS procedures, the SAS DATA step and SAS solutions. In addition, users are also able to interact directly with the data source using native data source capabilities.
  • Gain faster performance and reduce network traffic. SAS/ACCESS to Oracle provides the ability to push down complex Oracle-specific SQL queries, joins and functions to target data source processing. This reduces network traffic and speeds data access. SAS/ACCESS Interface to Oracle also provides API-level integration with Oracle's bulk-load utilities, further speeding loads.
  • Support both technical and business users. These out-of-the-box access solutions require minimal training and knowledge transfer. Business users will typically use SAS reporting and analytical capabilities, which can seamlessly access third-party data. Technical users may also access the data transparently, or they can interact directly with the data sources using SQL or other database-specific query languages.


Seamless and transparent data access
  • Broad coverage of data sources and platforms enables you to integrate data from across your organization.
  • Includes the option to access data without detailed knowledge of the database or SQL. The appropriate SQL queries are generated from the interface and passed to the data source for execution.
  • Includes the option to use SQL if so desired.
  • Has the ability to create federated queries that span multiple data sources. The queries are surfaced as database objects that can be used with all SAS solutions.
  • Makes use of security mechanisms inherent in the database.
Flexible query language support
  • A transparent access option surfaces data with minimal knowledge of the data or the SQL needed for access.
  • A custom SQL option lets users create their own SQL statements or modify automatically generated SQL.
  • Mapping of statements or functions specific to SAS to database-specific statements or functions enables all appropriate SQL statements to be processed directly inside the database, providing the best possible performance.
Performance features
  • Multithreaded read interface uses threaded kernel technology and native APIs.
  • Data read and writes are highly optimized with buffering, compressions, threading, etc.
  • Includes support for automatic partitioning.
  • Has the ability to pass functionality to the database.
  • Has the ability to directly control join-processing capabilities.
  • Includes temporary table support:
    • Create a temporary table that can be accessed by multiple SAS processes. This provides performance gains when the same data is required for different steps in a session.
    • Use temporary tables for heterogeneous joins.
  • Includes transparent support for bulk-load options. There is no need to understand different bulk loaders. Just set the SAS bulk-load option to "yes" and SAS uses the most appropriate capabilities.
  • Delivers industry-leading security, high availability and scalability with Oracle Database 11g, which has been significantly enhanced to take advantage of the Oracle Exadata Storage Servers.
Metadata integration
  • Database metadata can be accurately maintained within the SAS Metadata Repository.
  • Data jobs are registered via the SAS Metadata Server so they can be used in a variety of SAS solutions. Register data once, then use it in many places.
  • Supports native storage options, including temporary tables, materialized views and partitioned tables.
  • Translates native database data to the appropriate SAS data type for optimized processing.
  • Includes national language support.

Requerimientos del sistema

Host Platforms
  • HP/UX on Itanium: 11iv3 (11.31)
  • HP/UX on PA-RISC: 11iv3 (11.31)
  • IBM AIX on POWER architectures: 6.1 and 7.1
  • IBM z/OS: V1R10 and higher
  • Linux (32-bit): Novell SuSE 10 and 11; RHEL 5 and 6
  • Linux x64 (64-bit): Novell SuSE 10 and 11; RHEL 5 and 6
  • Microsoft Windows (32-bit): Windows XP Professional, Windows Vista*, Windows 7**, Windows Server 2003 family, Windows Server 2008 family
  • Microsoft Windows on x64 (64-bit): Windows XP Professional for x64, Windows Vista* for x64, Windows 7** for x64, Windows Server 2003 family for x64, Windows Server 2008 family for x64
  • Solaris on SPARC: Version 10 Update 8
  • Solaris on x64 (x64-86): Version 10 Update 8

* NOTE: Windows Vista supported editions are: Enterprise, Ultimate and Business.
** NOTE: Windows 7 supported editions are: Enterprise, Ultimate and Professional.

Desea más información?

Para hablar con un representante de SAS de inmediato, llame al 01800 1127 727 de 9:00 a.m. a 6:00 p.m. o solicite más información online.

}ro*0gCD!5+r؎b'~K΀Xf.DU;{Cl7.C̍7ѶdK.K34ݍnߎ_{׋.˨  YDI/3v+i94FNeb^ļhrz.9h8E&2]bhhgVGlb AA V)k@H<9ͫ^'/^B&:QCuWćBΔ3Cߙ̻wZc*˄eVQx4<-e"̼U RHqd ÈOm۲6vcX_o5ml56նUAXn]' ߮>3r kb2-4N;4;~ a`a0Cf/f:޼N ]ǻ$s+a4tYc ֙ Ê|ø1X%<.s+X}IZ_@ߦFz5wDv쨷o+bY!DuТ.o㰜` |0GxhӂIKs$1MXM@9Uߪ7v츶9=7lo+@DXIq\f! ̀~X,䯆}"zczKֈ iW];V~'ڡW%ll֡t0p3xH.ќ짊¬͍͍q`I|d~gfqFf "W :0yDrH~>Bág`یn>#^р\t韠? Ů AjojZpB5zkhV/x| )R= uyT|KjسՖ_"I5Kٶo}VhN\oguyB䘃QQ f9ת8Ý*תs}:Lȷ|LdFӬ'=0Ͱޭ>(Q uYXdncޯ.d£kE|~(;^xl#V*.Qc-N<{}^9pK?"P79?<3GN\*:rzB6}{H,@$\[N Q\ese'i6rQRRҥ. mJeakӐ!rMM>`fpś>@^H ׁۿ*NYnŔڍB{bUv޾] N_l|`, jE85"A`'2nmX,0m Qy~Cݐ->䐷OІ!au-_ÚE(^yc+ЂBT{9nXG#BNDKZX}zޜ޵[{&p'KsؠXżoz;ui/PiVt ֊"  (m\q>Bw }$nc+"[! DeQ[ v %8QEġŸEq[Ēhxj wԠNfOa" y FEzDU`vMʾ BO`S't(CuJKUs'>zne/cqƨ(9!)IKOMߦ 9^J6K>EY19a]¸scfc%.hNhPfR\LjI8'ٗ+ȪML=Xy:86S$0=aBkt/96{AV,Vc=N$+H Jq# /s$2 15" X 1kuOnj*,ypQL~3YO>^C P< >P_tO7'4ݸi`i))eQÑXN E bd2d:ZL L4?Z9X::A"m$][6ZG=>4¡\GgX%U׭VB&{נF>_TZ=Ġ;ЀGŘ<*Ə?pQ1~TGxG)Ʊ):JՔTtc$/@kv<"W9<{C ʳc j˻§~EJm~b= #mZEuI=qU~#2j{3m?wr sZmuAj8J'{s-gdݑz!_8%UF xVx&m'ǧ3QJNtc (@H:gzG 61e d;=:82q\jQ2Y, >ڲ8Jjщ`GeL) /:t"ʞ8F7!ϒ2k·ZSs\T׾.B1S F ٳR ZI/bB^ ժ U=u~~M[WLC]oGw-Q"4>_|5kc~ 6Z3T8$[>Ml TGNQ16"&If!?i.!㸭hLrДb~@#dHM8ܬfRMd4S 9&ŸZ^.,ߍO(p 7(icrVcJԂGX+ƀx趩Pa ![]98p,j"<|7z&ƩVaPwv.3)Bpx{ܐ̍osNܟWi\!pʂ;Џm35 ӉzԾ+X=TXkq¢Cr Aqb:DH ky!0YH!7ǁ'&#z kP~ƚM/KAOק ].! le;`LNNXrsI 3saHN@= N} /)I^tcu{Ko4# _kbKiyfD x3ٱ3A g:`ԉ;0nK?`z,57`qbTkjUn1f"Bg7_9Gn±mF2pp6s/-복+Ð1] P)(HO[$7[] 7ˠ2t+zɑy.Hfc1l9G;8F/wPAWaJ/8f6JANQFlmNsՅaQRu:w$Q\2._/ωM2eq"~IF"Fb7ُ1(SÐV\e4iQrPNs6w85Mc$,"R!ɵtx86@iwIk.>?'f2rE†fbƈw,Z opp!C?&kV#ҁbc/ +uhd?fAo:Z~9zފ>or7-ܽ-shɎ:ԷYZA䨓7X\x?턕գKSuQԹj6V%^ǒTM PӦ}^a7ڇ.W|/^DqY4w H\[ePA('s`<^Q Ճu *䊺1ơ0Qp0&qJݢ`q| C~ltp&EB*{&̽=w;۶ yku;@?_O4`JLW LT\Ӏ%`?叼U*hKrD1 ms~ c?sоqE^l+S͙}$t ;z43 u<6ru@RH޳lx-L]98l_c;0R]aViR$YNsz/j0n5b peʹ|Y'97*&/R S*HvϢ0}bsgbY=>_| ZffZ{ަ:@o-O94Q0 yMb ݮIZeZtIZx&>e/TUNW@[AnzWJ0NM1muh3kfC)A _ӄ,*W<8UvFs (i $_^xtǷ&<I!Rd(b g4Ĕd  ;S iV8LfݴqDݛFkDjʨyoT8FL rhUi=u4\4^ Z"4:)j [g<Z I~ kTq0Dcj4ǠK!וBæ5ĂPE+lAlղ1]zvcc/D.^ 2x\=0>ߐd($v Nф뻺Xι-aů hЃ݇~+n7Wi,i(yP/qn_sltl}ܟ֢?%M-N L(#2@ßF A  lt!]! l޷>ޕF:Ci$EVGD?`H0 08TFxTOc;[s;mQ\d'?"87e!s@?Q]2txWJ1w3ň(O[Itμ'V"F'GPC*ff ۢ tDAHoD(m (H~_"S >흘H7:A$~9qO%-NڑWD&9Ca1MNxd{ 8g@,_K87SMn"/:&KZ}Oυthe5к9v*oc2;9:)eK<Ͼ.-K%]i`F:(C_B^B>>ǥ2bKS2|trDH NA^+L{tev{5fn{?UN=FcuuckkSyET/A# >LyGgp/'D'daK).:1]lnQhG*cB9ꚺ( =w6T)t2Z hiE_DtCw#,OC)!NU %?\Wfapå ڰ+J{,ƯSzX1Nz~ q?~C{('rb(' E A[)C!# F/ :t0W=!ߊҎ& `3C:C!`#BV٣z89P צޥa[ (s6[R}2F?J)jҤW.]| F}9xCJ().pu~ uV* d]$vH]£-r}Xp)%r8A> Icn#?0zz3 > 23dQ{/,crAژUK硐ސau=G;<7l^LK: 3+T>}zc:#`WThGic}g2ɪpI"|#`\spﭯuֱq|sy K_*ܘxAFgڄ/Nrqē9Y&,>,u4+@Vd2R8Y[ec ֪_f |Xd W/..X|Ґsִ ;SN!رBoM7_JtװXIGa CX%PO~A8o|0p}(ar\ )O,I?6JL{nOy$i!F>)܀-xW5>3r)C @Z*u! G'׬a%\oFIdha6C ]3:J:E|{ !Pw%"=c sD&e},p3?T۴o.-auku}ul4kAw 9`KA:C" AFFlm2kD55Hҗ|ٛn*3JP'*/j"͊wUBn8,,hF)x!ߌY(պE6-⵿/yl~#,q?HښKM UOnlդıƦĊ>lE4hؔﭱiqHƦ/Fo1ҸO#ex&ETv*o8RxcԷB2>/]I 5lnlA _|G;yY u:H"4?pmޟ1 E z^#R7 n;}XđsX6כFkBޜg=Эw榱h4x3z$L{&{ \97qJ܈\?1q4/N>/7Vp[kM9_GqK$<:9^A{Ch %1cҼi{k+RMܩjPϋkGkf?\M]%vގ+yŔxyɕ9<`TȠ!gP`PwbɆ1DL,b p*h+li :`6dÌP{$i2ώ%>>yn5՟=ZNӣ1AM:tŪ<>_eTЊwTB^-.vĮ[tŇf|FQ/Co4F_%U0JM5IqhfQdkBRm&%7n%b9FGbҨ,M߽bQ,#AX~k&!j hDD'C?F\߿D)ICf#} V$0B>^pQlސ8E=-?6 a]kCO(F(D\*!tl )w{ B.x]zG7K~mjYO\kM * B77;,af7:^^x4 bVĤBE-t:]vux{L p1Z@MDxȔz,(|wyd)" >.SݐM*iRzot<.ٸԅsdi\}̠}0o')u$u q!@%/v\S.y S^ T1@t$b. `I?{*?HH⯠G(s'rc?xV~%Dej\|g.Bsx@.c6}{JQ '7̊ѩNJ NsTE20按.q^%U?wsXxx?tE/ =:~V9.pW[>]N>ELbwI?RȠcvZxqEɕC KݭN''ʱ;a~1 b078EYGEؙ*st@b'uֆ?t9qMMwc"Mwi.4/)FG3UW%E A e+;ē9D+S"hnQ\4IPł M?98)Wă9&LA[%[%X-Uk >AvCH6L@<؜(|Iel!4MWe_"x>BS!y b34k  /)aipɢ!z|F''$ ĠVLǰ"Ms,%P47ڱ2 _FvCu@rƓ&emǣu&XD*9橓% (5/GiIf6]in-/#0zŒ-R}[n㫍3un-ٶN00`R V ޡ>s"H2%HV];zaݪ@RWh!fjQ.&?ޭ]EnW^O]wYd((7O..uA\QKq3%#N0?JbA?čTGL%0=;",W^uj 5|,NhG3c?r!pڙ{q̕ l5>:oa4Ay~ņ=Qf~3њ lKd/u]I)Kiޒ/K⫎a(CױX [Ͼm./qZE\8T!~y!`Q`byo sarO!^;} 'XZZJ\oI'"VHk!NG:Wݓ[DB0 GBQhr+!VqAfibK2 OiB?τc`EH͋=QNؑQ*bwC9Oha :ٺuVy?}b4%Yu Ʉ$ 6sѻ!O]rpV u'u*N%LS7-Ezb?!>sf 2+/\Hdtd:,".Q DлfcX]lN,6qv:~t/~ߎEE8]}$FyM~hW~*):{t)^.:.5U\ʥWD[˝Ҵ.$#WLxEMv<=j~YtQ?m?tMvZ-=JzSm?nSzo}rص<20Ə_GE)Y$Lw&CZzܟi[zyL-*[I&^HJ(P]~L֑&jO@.76wnr>VJFm0~Fz{g26 Z[6W7,ZLMňmׁY@KI舁b5^vBY?" qHN]ZKnMP3V\!NAѺ fdܯf{{VnhZo1{s֚tc}.љ1ނuC[]p`S6gj:DANhy ueUٯJfXݕϩ׍Dȼn,îs|a=zvX9(c C{̂a-QrOK3mLIU.s_Drf j0?jS?koIۥ$GAUKzb&v`fDWMeL;x5/L8247n똀4[p1sYͮ5OjҚ1jR!BEK<9JO!4W S 0ml5:[Qс8u9D^e{߿=~zX\}[u^=} DGO׎NVͣIj57[G[[U,q.a<_cg1UTP[48L"b9nEm^aZH]E0n:`?rtqLCzQ]} DIXVq)VmIU6dG2~loƏ>,(6.HxX>k4ZI~zcm}1y}ҙHXW_ɽrA*J~+zsGR b<ɉJ󽘫6=93(\x,?0+:kh756ڭAmF-@5R_R?r5m t