Products & Solutions / Enterprise Data Access

SAS® Data Surveyor for Oracle Applications

Easily integrate data from Oracle’s Business Suite into your business analytics

With SAS Data Surveyor for Oracle Applications, you can browse, search, read, write and update data from Oracle's Business Suite. Including enterprise application data in your business analytics process is critical to empowering and driving accurate business decisions.

Easy-to-use wizards, metadata search features, packaged transformations and integrated data quality tools enable you to integrate relevant data to build the intelligence needed to optimize processes and decisions throughout your organization.

Benefits

  • Easily include data from enterprise applications in your analytics and business intelligence.
  • Maintain data security and integrity using native interfaces.
  • Manage data on an enterprise scale.

Read more

Features

  • Secure, easy access and integration of data from Oracle applications
  • Powerful metadata integrations and search capabilities
  • Centralized environment for enterprise data integration and data quality
  • Flexible query language and search support

Read more

How SAS® Is Different

  • Integrated and optimized for SAS environments. SAS Data Surveyor for Oracle Applications provides an easy-to-use method for integrating enterprise application data into business intelligence. SAS Data Surveyor for Oracle Applications is designed specifically for SAS environments, making it highly optimized in a way that no other solution can be.
  • Extensive data source and platform support. SAS provides the broadest level of support for third-party data sources, running on a broad range of platforms. Customers can trust that data from their ERP and CRM applications, running on any platform, will be integrated into their SAS Business Analytics environment. SAS is committed to supporting the most current releases of data sources and platforms, and is constantly expanding capabilities to support new and emerging data sources and platforms.
  • Flexibility. SAS Data Surveyor for Oracle Applications offers customers the ultimate flexibility by supporting both business and technical users with a simple and easy way to access the data. A single solution that can be used by business and technical users gives organizations the ability and flexibility to adapt to changing analytical requirements and dynamic business demands.

Benefits

  • Easily include data from enterprise applications in your analytics and business intelligence. With SAS Data Surveyor for Oracle Applications, users can quickly find necessary data without having to understand the underlying application data structure. An easy-to-use interface and powerful metadata search capabilities enable data integration designers to search, browse and quickly locate relevant information.
  • Maintain data security and integrity using native interfaces. A wizard-driven graphical user interface helps manage, maintain and build the data integration process, making it easy to integrate data from your Oracle systems into the SAS environment. Custom coding is not needed to access and use enterprise application data from Oracle Applications. 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. Certified application interfaces are used to maintain data security and integrity.
  • Manage data on an enterprise scale. Accessing relevant enterprise application data is only one facet of organizational data. SAS is the only software that enables you to manage data on an enterprise scale, allowing the integration of all data sources on all platforms. SAS provides the perfect environment for turning operational data into mission-critical business intelligence.

Features

Secure, easy access and integration of data from Oracle applications
  • Integrates data from Oracle Enterprise Business Suite, leveraging certified application interfaces.
  • Provides support for Enterprise Business Suite 11i.
  • Includes multiple language support.
  • Provides search and clarification of Oracle EBS data without affecting ERP system performance; metadata caching function offloads metadata browsing to the SAS application server.
  • Supports Oracle Enterprise Business Suite's secure and data access models, including organizational roles.
Powerful metadata integrations and search capabilities
  • Reads the Oracle Enterprise Business Suite data dictionary, enabling you to explore metadata structures without extensive knowledge of Oracle.
  • Integration with SAS Metadata Server extends the Oracle Business Suite metadata to a common, open metadata framework allowing for consistent analysis and information sharing across the enterprise.
  • Performs metadata decomposition, enabling users to search using business terms and understand how the business objects relate to the underlying data.
  • Provides multiple search capabilities, such as schema, business application area, tables, columns and fields in native languages.
Centralized environment for enterprise data integration and data quality
  • Integrates with other data sources, including DB2, other Oracle Enterprise Business Suite data, SAP, SQL Server and many more.
  • Leverages SAS solutions to seamlessly add data quality to the data integration process.
  • Provides a point-and-click process to run Oracle EBS application data through SAS data quality routines.
  • Integration with SAS Metadata Server creates a centralized metadata repository environment that enables consistent analysis, management and information sharing of all of your enterprise data across all platforms.
Flexible query language and search support
  • Enables data integration developers to obtain necessary information based on input from users.
  • Includes many predefined business services, including accounts payable, bank accounts, bank branches, checks, invoices and payment history, for faster implementation.

System Requirements

Server environment
  • Linux (32-bit): Novell SuSE 10 and 11; RHEL 5 and 6
  • Microsoft Windows (32-bit): Windows XP Professional, Windows Vista*, Windows 7**, Windows Server 2003 family, Windows Server 2008 family
  • Microsoft Windows on x64 (64-bit): Windows XP Professional for x64, Windows Vista* for x64, Windows 7** for x64, Windows Server 2003 family for x64, Windows Server 2008 family for x64
Client environment
  • Microsoft Windows (32-bit): Windows XP Professional, Windows Vista*, Windows 7**
Required software
  • Base SAS®

* NOTE: Windows Vista supported editions are: Enterprise, Ultimate and Business.
** NOTE: Windows 7 supported editions are: Enterprise, Ultimate and Professional.

Ready to learn more?

Call us at 1-800-727-0025 (US and Canada) or request more information.