SAS^® Data Surveyor for Oracle Applications

In the Spotlight SAS Data Surveyor for Oracle Applications Fact Sheet •   Product Overview •   Key Benefits •   Complete Features List •   Technical Requirements

What is SAS Data Surveyor for Oracle Applications? SAS Data Surveyor for Oracle Applications provides ETL designers with the ability to extract, search, navigate and understand complex Oracle Applications data structures so that Oracle Applications data can be integrated with other data sources, analyzed or used in conjunction with SAS solutions. The ability to find and understand information stored within Oracle Applications using a wizard-driven graphical interface that automatically tracks and stores metadata makes it easier to manage and maintain the intelligence creation process.

Why is SAS Data Surveyor for Oracle Applications important? It enables organizations to quickly and efficiently integrate Oracle Applications data with other data sources to provide a complete view of the enterprise for business intelligence and reporting needs.

For whom is SAS Data Surveyor for Oracle Applications designed? SAS Data Surveyor for Oracle Applications is designed for ETL developers and decision support users seeking to integrate data from Oracle Applications with other disparate data sources or exploit Oracle Applications data for decision support needs.

Key Benefits Save time, money and resources. SAS Data Surveyor for Oracle Applications allows users to quickly find necessary data without having to understand Oracle Applications data structures. An easy-to-use interface and powerful metadata search capabilities enable ETL designers to search, browse and quickly locate relevant information from the thousands of tables and database schemas in Oracle Applications. Reduce maintenance overhead. With SAS Data Surveyor for Oracle Applications, no custom coding is needed to get to Oracle Applications data. Instead, all relevant extraction information is stored as metadata that is easily managed and maintained, and routines can be reused by other developers and engineers. Manage data on an enterprise scale. SAS is the only software that enables you to manage data on an enterprise scale, allowing the integration and management of all data sources on all platforms. It provides the perfect environment for helping you turn all Oracle Applications data into mission-critical business intelligence. Key Features Access all your Oracle Applications data. SAS Data Surveyor for Oracle Applications allows you to explore metadata from your entire Oracle Applications suite without specialized Oracle Applications knowledge. SAS provides ETL designers and knowledge workers with a way to easily navigate the thousands of tables and dozens of database schemas that make up Oracle Applications. Powerful metadata search. The Metadata Search, incorporated in the SAS Data Surveyor for Oracle Applications, allows ETL designers and decision support specialists to search, browse and identify complex ERP data structures. Flexible searching options. Multiple search capabilities, such as Schema, Business Application Area, Tables, Columns and Fields in native languages, allow ETL developers to get the necessary information based on input from users. You can search by entity model, fields, columns and tables. Automatic code generation. SAS Data Surveyor for Oracle Applications automatically generates the code necessary to retrieve the required, necessary data from Oracle Applications applications. Integrated data quality. With integration into SAS Data Integration Studio, it is a point-and-click process to run Oracle Applications data through SAS data quality routines. For a complete list of key benefits and features, refer to the SAS Data Surveyor for Oracle Applications fact sheet .