|
What are SAS Data Surveyors? SAS Data Surveyors provide ETL designers with an easy-to-use environment for extracting, searching, navigating and understanding complex ERP data structures so data from those systems can be integrated with other data sources, analyzed or used in conjunction with SAS solutions.
Why are SAS Data Surveyors important? They enable organizations to quickly and efficiently integrate ERP data with other data sources, providing a complete view of the enterprise for business intelligence and reporting needs. The ability to find and understand information stored within these systems using a wizard-driven graphical interface that automatically tracks and stores metadata makes it easier to manage and maintain the intelligence creation process.
For whom are SAS Data Surveyors designed? SAS Data Surveyors are designed for ETL developers and decision support users seeking to integrate ERP data with other disparate data sources or exploit such data for decision support needs.
Key Benefits
- Save time, money and resources. SAS Data Surveyors allow users to quickly find necessary data without having to understand complex 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 various ERP applications.
- Reduce maintenance overhead. With SAS Data Surveyors, no custom coding is needed to get to the 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 ERP data into mission-critical business intelligence.
- Enhance SAP Business Intelligence. SAS offers SAP-certified integration, enabling your organization to gain the accurate, predictive insights provided with SAS analytics through SAP-certified interfaces and technology.
Key Features
- Access all your ERP data. SAS Data Surveyors expose data from ERP systems, including both SAP R/3 ERP systems and SAP BW systems also known as SAP Business Information Warehouse; Oracle Applications; PeopleSoft; and Siebel. You can explore metadata from your entire ERP suite without the need for specialized system knowledge.
- Powerful metadata search. The Metadata Search, incorporated in SAS Data Surveyors, allows IT users to search, browse and identify complex ERP data structures.
- Flexible searching options. SAS Data Surveyors provide flexible search capabilities that allow ETL developers to easily get the necessary information based on input from users. You can search by entity model, fields, columns and tables.
- Application specific transformations. Only SAS has specific transformations, such as the snowflake denormalization routines for SAP, which change the complex data structures of SAP BW into standard star schemas that are far more suitable for analysis; Effective Dating Transformations for PeopleSoft; and EIM to Base table transformation for Siebel.
- Automatic code generation. SAS Data Surveyors automatically generate the code necessary to retrieve the required data from your ERP applications.
- Integrated data quality. With SAS Data Surveyors' integration in SAS Data Integration Studio, it is a point-and-click process to run ERP applications' data through SAS data quality routines.
For a complete list of key benefits and features, refer to the specific SAS Data Surveyors:
|
|
Industries
Connectivity & Metadata
