F A C T S H E E T
SAS Data Surveyor for Oracle Applications
Providing the environment to turn Oracle Applications
data into mission-critical intelligence
What does SAS Data Surveyor As enterprise resource planning Key benefits
for Oracle Applications do? (ERP) products have evolved, they’ve • Save time, money and resources.
SAS Data Surveyor for Oracle Ap- become even more complicated and SAS Data Surveyor for Oracle Ap-
plications gives data integration difﬁcult to manage. To retrieve the plications allows users to quickly
designers the ability to extract, data needed from Oracle Applica- ﬁnd necessary data without hav-
search, navigate and understand tions applications, transform it and ing to understand complex Oracle
complex Oracle Applications data generate new information takes a lot Applications data structures. An
structures so that Oracle Applica- of complex, custom coding. And with easy-to-use interface and power-
tions data can be integrated with each new request for more or differ- ful metadata search capabilities
other data sources, analyzed or
ent information, the amount of custom enable data integration designers
used in conjunction with SAS solu-
coding grows. As a result, getting the to search, browse and quickly lo-
tions. It provides the ability to find
data needed from Oracle Applications cate relevant information from the
and understand the information
stored within Oracle Applications systems requires employees with thousands of tables and dozens of
from a wizard-driven graphical user expert knowledge, expensive con- database schemas in Oracle Appli-
interface that automatically tracks sultants, or both. cations. You don’t need expensive
and stores metadata for easier man- consultants or ERP experts to get
ageability and maintainability of the On top of those expenses, discon- the data your organization needs to
intelligence creation process. nected islands of organizational data generate information.
and data management processes
• Reduce maintenance overhead.
Why is SAS Data Surveyor for mean tools from multiple vendors are
With SAS Data Surveyor for Oracle
Oracle Applications important? needed to extract information from
Applications, no custom coding is
It enables organizations to quickly various databases, ERP systems and
needed to get to Oracle Applica-
and efficiently integrate Oracle other sources. Managing multiple
tions data. Instead, all relevant
Applications data with other data data integration tools strains resourc-
sources to provide a complete view extraction information is stored as
es and adds to the cost and complex-
of the enterprise for business intel- centralized metadata that is easily
ity of training and maintenance.
ligence and reporting needs. managed and maintained, and
routines can be reused by other
SAS Data Surveyor for Oracle Ap-
For whom is SAS Data Surveyor developers and engineers.
plications helps you locate, identify,
for Oracle Applications designed? • Manage data on an enterprise
understand and extract the com-
SAS Data Surveyor for Oracle scale. Accessing relevant ERP
plex data structures locked within
Applications is designed for data information is just one facet of
Oracle Applications. With easy-to-use
integration developers and decision organizational data. SAS is the
wizards, powerful metadata search
support users seeking to integrate only software that enables you
data from Oracle Applications with capabilities, packaged transformations
to manage data on an enterprise
other disparate data sources or and integrated data quality tools, SAS
scale, allowing the integration and
exploit Oracle Applications data for Data Surveyor for Oracle Applications
management of all data sources on
decision support needs. gives you the power to quickly and
all platforms. It provides the perfect
easily integrate ERP data with other
environment for helping you turn all
organizational data to build the intel-
Oracle Applications data into mis-
ligence necessary to successfully run
sion-critical business intelligence.
Product overview Easy access of Oracle complex ERP data structures. Using Integrated data quality Key Features
SAS Data Surveyor for Oracle Ap- Applications data Oracle Applications’ own metadata, With seamless integration into SAS
plications is integrated into SAS Data SAS Data Surveyor for Oracle Ap- such as column names and descrip- Data Integration Studio, it is a point- Reads Oracle Applications data dictionary
Integration Studio, a wizard-driven plications enables you to explore tive texts, the required data is easily and-click process to run Oracle • Enables you to easily explore metadata and data structures without extensive knowledge
graphical user interface that helps metadata from your entire Oracle identiﬁed, so users can create the Applications data through SAS data of Oracle Applications.
manage, maintain and build data Applications suite without the need data sources they need to populate quality routines to ensure quality and Business metadata decomposition
integration processes. The SAS Data for specialized Oracle Applications the enterprise data warehouse in a consistency. • Ability to search metadata using business terms and understand how the business objects
Surveyor’s ability to locate, identify, knowledge. SAS provides data timely fashion. relate to the underlying data.
understand and extract data from integration designers and knowledge Integrated metadata framework
Open metadata framework
Oracle Application, along with its tight workers with a way to easily navigate Flexible searching options The tight integration and use of the
• Integration with SAS Open Metadata Server extends Oracle Applications metadata to a
integration into SAS Data Integration the thousands of tables and dozens Multiple search capabilities, such as SAS Open Metadata Server extends
common, open framework, allowing for consistent analysis and information sharing
Studio, make it a powerful enterprise of database schemas that make up Schema, Business Application Area, Oracle Applications metadata within across the enterprise.
data integrator. Oracle Applications. Metadata cach- Tables, Columns and Fields in native an open metadata framework, allow-
ing ofﬂoads the searching and un- languages, allow data integration ing for a consistent view of all data Metadata caching
• Offloads metadata browsing to the SAS Application server so ERP system performance
SAS Data Surveyor for Oracle Ap- derstanding of the data locked within developers to get the necessary in- and information across the enter-
is not affected.
plications places Oracle Applications Oracle Applications to SAS. formation based on input from users. prise. SAS Metadata Server stores
metadata in a common metadata You can search by entity model, ﬁelds, all relevant information about Oracle Multiple language support
framework. Integrating Oracle Ap- Users can ﬁnd the information they columns and tables. Applications data structures as • Lets you view metadata in your own language. There is no need to look at acronyms.
plications metadata within an open, are looking for without severely im- metadata so that it can easily be used Metadata search and management
common metadata architecture pacting the operational system. Automatic code generation and reused from one location. This • Powerful metadata search tool allows IT to understand complex ERP data structures and
enables Oracle Applications data to SAS Data Surveyor for Oracle Ap- promotes easy maintenance because gives users the tools necessary to populate the enterprise data warehouse in a timely fashion.
be turned into true intelligence by Powerful metadata search plications automatically generates all information resides in a centralized
Understanding of Oracle Applications metadata and complex data hierarchies
exposing Oracle Applications rules The Metadata Search, incorporated the code necessary to retrieve the re- metadata repository and no source
• Find and decompose data in Oracle Applications.
and data to the entire SAS Enterprise in SAS Data Surveyor for Oracle quired data from Oracle Applications. code needs to be touched.
Intelligence Platform. The SAS Enter- Applications, allows data integration Data warehousing integration
prise Intelligence Platform supports designers and decision support spe- Improved ETL performance Integrated environment for • Integration with SAS Data Integration Studio for automatic code generation, seamless data
the complete process of creating and cialists to search, browse and identify Using native Oracle database calls enterprise data integration quality integration and fast integration with the enterprise data warehouse.
delivering consistent, enterprise-level assures that Oracle’s SQL is used Integrate your Oracle Applications GUI-based code generation
intelligence. when processing the Oracle Applica- data with other vital information and • Save time writing code with an interactive GUI-based code generator.
tions data. use the powerful SAS environment to • Integrated with SAS Data Integration Studio, SAS Data Surveyor automatically generates the
manage all your enterprise data inte- code necessary to retrieve required data from Oracle Applications applications.
gration processes. Additionally, you
Integration with other data sources
can make use of SAS’ other powerful • Integrate with other data sources, including Oracle, DB2, other Oracle Applications data,
capabilities, including scalable stor- Siebel, SAP, PeopleSoft, SQL Server and many more.
(Below) Search Oracle Applications by Business Areas to age designed speciﬁcally for analytic
quickly find relevant tables and columns. and business intelligence, an inte- Data quality integration
• Directly add data quality to your data integration processes.
grated business intelligence platform
• Point-and-click process to run Oracle Applications data through SAS data quality routines
and best-in-class analytics. SAS is
to ensure quality and consistency.
the only company that enables you to
manage data on an enterprise scale,
allowing the integration of all data
sources on all platforms. Because
you only have to manage one data
integration solution, resources are
not strained and you can reduce the
(Above) Integration with SAS Data Integration Studio cost and complexity of training and
enables you to easily combine Oracle Applications with maintenance.
other data sources, and helps you create and manage
data integration processes.
SAS Data Surveyor for Oracle Applications
Technical Requirements SAS Data Integration Server or
SAS Enterprise Data Integration Server
All SAS clients run in a Windows desktop Supported Oracle Applications
environment. Oracle Applications 11i and higher
• Windows (x86-32): Windows 2000
Professional, Windows XP Professional
• Internet Explorer 5.5+
SAS Servers, including Base SAS and
SAS Metadata Server, can be installed
on one or more hardware systems in a
• AIX (64-bit), Release 5.1+
• HP/UX (64-bit), Release 11i+*
• HP/UX Itanium (64-bit), Release 11i+
• HP/UX PA-RISC
• OS/390, Version 2, Release 10*
• Solaris (64-bit) 8, 9, 10 on SPARC
• Windows (x86-32): Windows 2000
Professional, Windows XP Professional,
Windows NT 4 Server*
• z/OS, Version 1
* Note: SAS Metadata Server must be
installed on an alternate supported