SAS Data Surveyor for Oracle Applications by tzv97744


									                                                                                      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        difficult to manage. To retrieve the         plications allows users to quickly
designers the ability to extract,        data needed from Oracle Applica-            find 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.
                                         your business.

SAS     9
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              identified, 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 offloads 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, fields,    all relevant information about Oracle      Multiple language support
framework. Integrating Oracle Ap-               Users can find 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 specifically 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
                                            Required software
Technical Requirements                      SAS Data Integration Server or
                                            SAS Enterprise Data Integration Server
Client environment
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+

Server environment
SAS Servers, including Base SAS and
SAS Metadata Server, can be installed
on one or more hardware systems in a
multitier configuration.
• AIX (64-bit), Release 5.1+
• HP/UX (64-bit), Release 11i+*
• HP/UX Itanium (64-bit), Release 11i+
• 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

                    �                                 ��������������������

To top