1. User's Guide
  2. Introduction to Smart View
  3. Supported Data Source Providers

Supported Data Source Providers

Oracle Smart View for Office supports connections to several EPM Cloud and EPM System data sources, along with Oracle Essbase, Oracle Analytics Cloud, and Oracle Business Intelligence Enterprise Edition data sources.

Related Topics:

See also Supported Smart View Extensions.

EPM Cloud Data Sources

Oracle Enterprise Performance Management Cloud includes:

  • Account Reconciliation

    Smart View connected to Account Reconciliation requires the Reconciliation Compliance extension.

  • Enterprise Profitability and Cost Management

  • Financial Consolidation and Close

  • FreeForm

  • Narrative Reporting

    Smart View connected to Narrative Reporting requires the Narrative Reporting extension.

  • Planning

  • Planning Modules

  • Profitability and Cost Management

  • Reporting Settings

  • Sales Planning

  • Strategic Modeling

    Smart View connected to Strategic Modeling requires the Strategic Modeling extension.

  • Strategic Workforce Planning

  • Tax Reporting

EPM System Data Sources

Oracle Enterprise Performance Management System includes:

  • Oracle Hyperion Enterprise Performance Management Workspace

  • Essbase as part of EPM Workspace

  • Oracle Hyperion Financial Management

  • Oracle Hyperion Planning

  • Oracle Hyperion Reporting and Analysis, also referred to as Reporting Settings

    Includes Oracle Hyperion Financial Reporting (requires the Financial Reporting extension for Smart View), and Oracle Hyperion Web Analysis.

  • Oracle Hyperion Financial Data Quality Management, Enterprise Edition

  • Oracle Hyperion Profitability and Cost Management

  • Oracle Hyperion Strategic Finance

    Smart View connected to Strategic Finance requires the Strategic Finance extension.

Essbase Cloud Data Sources

  • Oracle Essbase on Oracle Cloud Infrastructure via Marketplace includes:

    • Essbase 19c

    • Essbase 21c

    Smart View connected to Essbase cloud works with the Cube Designer extension.

  • Oracle Analytics Cloud - Essbase

Essbase On-Premises Data Sources

Oracle Essbase on Independent Deployments includes:

  • Essbase 11g

  • Essbase 21c

Oracle Analytics Cloud Data Sources

Smart View supports Oracle Analytics Cloud.

Smart View connected to Oracle Analytics Cloud requires the Oracle BI EE extension.

Oracle BI EE Data Sources

Smart View supports Oracle BI EE.

Smart View connected to Oracle BI EE requires the Oracle BI EE extension.

Notes about Supported Data Sources

In this guide:

  • References to Financial Reporting apply to both the on-premises and EPM Cloud versions of Financial Reporting.

  • About Essbase:

    • Essbase on Oracle Cloud Infrastructure via Marketplace is referred to as "Essbase cloud."

    • Essbase on Independent Deployments is referred to as "Essbase on-premises."

    • When a guideline or caveat applies to both Essbase cloud and Essbase on-premises, then simply "Essbase" is used.