Resources

• Products & Solutions
• System Requirements
• Samples
• Install Center
• Third-Party Software Reference
• Documentation
  • What's New in SAS
  • Product Index A-Z
  • SAS Viya
  • SAS 9.4
  • SAS 9.3 and Earlier
• Papers
• Focus Areas

What's New Table of Contents

New Products in SAS 9.1: SAS Data Surveyor

The following SAS Data Surveyor products are new in SAS 9.1:

• SAS Data Surveyor for PeopleSoft
• SAS Data Surveyor for Oracle Applications
• SAS Data Surveyor for SAP
• SAS Data Surveyor for Siebel

SAS Data Surveyor for PeopleSoft

The SAS Data Surveyor for PeopleSoft consists of a set of software plug-ins that provide a faster and easier way for you to access and transform your PeopleSoft data using SAS ETL Studio and SAS Management Console. It enables you to extract metadata from PeopleSoft that you can use to query PeopleSoft records. These queries enable you to

• more easily locate and use your PeopleSoft data in SAS
• browse the extracted metadata
• search the metadata to locate records that contain specific values
• query the metadata to build SAS views of PeopleSoft tables and save these views as permanent SAS views, SAS data files, or SAS source code
• specify how you want to handle PeopleSoft effective dates and effective sequencing in the source data that you extract from PeopleSoft.

SAS Data Surveyor for Oracle Applications

The SAS Data Surveyor for Oracle Applications consists of a set of software plug-ins that provide a faster and easier way for you to access and transform your Oracle application data using SAS ETL Studio. It enables you to

• extract metadata from Oracle applications that you can use to query Oracle application tables. These queries enable you to more easily locate and use your Oracle application data in SAS.
• browse the extracted metadata.
• search the metadata to locate tables that contain specific values, query the metadata to build SAS views of Oracle application tables, and save these views as permanent SAS views, SAS data files, or SAS source code.

Software plug-ins for SAS Management Console enable you to select or define an Oracle application server, a library to access this server, and a library to reference the metadata after it is extracted from Oracle applications.

SAS Data Surveyor for SAP

The SAS Data Surveyor for SAP consists of several software plug-ins to SAS ETL Studio and SAS Management Console that enable you to

• extract metadata from your SAP BW system and write that metadata to SAS data sets.
• browse the extracted SAP BW metadata, write metadata about selected ODS objects and InfoCubes to your metadata repository, and create jobs that load the data from the ODS objects and InfoCubes into a specified SAS library.
• use Changed Data Capture (CDC) processing to identify and extract only the data in your ODS tables and InfoCubes that has changed since your last extraction.
• dynamically extract metadata from SAP R/3 system tables and write that metadata to SAS data sets or create a job that can be used to extract metadata from SAP R/3 hierarchies and groups.
• browse the extracted SAP R/3 metadata, select SAP R/3 data sources for your SAS ETL Studio data warehouse, and write metadata about those data sources to your metadata repository.
• use the SAP LIBNAME engine, which supports load balancing, user validation at logon, more efficient handling of projections, server-side joins, and directory processing.

After the SAP metadata is written to the metadata repository, you can use SAS ETL Studio to further analyze your SAP data.

SAS Data Surveyor for Siebel

The SAS Data Surveyor for Siebel consists of a set of software plug-ins to SAS ETL Studio that enables you to

• read metadata from tables in your Siebel database and browse the extracted metadata to analyze your Siebel tables and identify which tables contain the source data that you want to use in your SAS ETL Studio data warehouse.
• save metadata about selected Siebel tables into your metadata repository.
• use the Siebel Enterprise Integration Manager (EIM) to update the data in either the Siebel EIM tables or the base tables in your Siebel database, and specify whether you want to overwrite or append to the data in existing Siebel EIM tables.
• generate a job in SAS ETL Studio that you can use either to repeat or to schedule the process of writing data to the specified Siebel EIM tables.
• generate a Siebel Server Manager script to submit an EIM job that imports data from the EIM tables to the appropriate Siebel base tables.