1. Administering Data Integration for Oracle Enterprise Performance Management Cloud
  2. EPM Integration Agent
  3. EPM Cloud to On-premises Connectivity Using the EPM Integration Agent
  4. EPM Integration Agent Process Description

EPM Integration Agent Process Description

The steps are a high-level description on how to import a subset of data or metadata from your on-premises data sources and then load it directly to the Oracle Enterprise Performance Management Cloud using the EPM Integration Agent.

  1. In Data Integration, write a SQL query to extract the data from the source system.

    For more information, see Creating an SQL Query.

  2. Using the SQL, generate a sample data file with a header record.

    The column name in the header record must exactly match the column name or column alias in the SQL. The names are case-sensitive.

  3. In Applications, create an "On Premise Database" data source application and then select the sample data file.

  4. Map the source columns to identify how source dimensionality translates to target dimensionality.

  5. Assign integrations to different clusters. A cluster is a group of independent EPM Integration Agents. A cluster distributes incoming job traffic across a group of integrations.

  6. Run the integration.