1. Administering Data Integration for Oracle Enterprise Performance Management Cloud
  2. EPM Integration Agent
  3. Installing and Configuring the EPM Integration Agent
  4. Configuring and Starting the EPM Integration Agent Process Description

Configuring and Starting the EPM Integration Agent Process Description

The steps below are a high-level description on configuring the EPM Integration Agent. It includes configuration steps and then steps for starting the EPM Integration Agent.

  1. Set up the JAVA_HOME environment variable.

    For more information, see Setting JAVA_HOME.

    Note:

    The EPM Integration Agent runs on Windows and Linux with Java 8, 11, and higher. The current version is Java 19. For more information about Java 8, see https://www.oracle.com/java/technologies/java8.html.

    Note:

    The EPM Integration Agent is only certified with Oracle Java. The EPM Integration Agent is not certified with Open JDK.

  2. From the Data Integration home page, download the EPMAgent ZIP file.

    For more information, see: Downloading the EPMAgent ZIP.

  3. Extract EPMAgent.zip.

  4. Create the cluster that will be used to direct how jobs are extracted when placed in a queue for execution.

    For more information, see Understanding Agent Clusters and Adding a Cluster.

    The default cluster name is EPMCLUSTER.

  5. By default, the EPM Integration Agent includes the JDBC drivers for Oracle.

    If you require the Microsoft JDBC driver for SQL Server, see Configuring the Microsoft JDBC Driver for SQL Server in the EPM Integration Agent.

    If you require JDBC drivers for other sources, then download and install the drivers.

  6. Create the Application folders.

    For more information, see Creating Application Folders.

  7. Use the EPM Agent Utility to encrypt the Oracle Enterprise Performance Management Cloud user password.

    Copy and save the encrypted password. (You add it as a parameter in the next step.)

    For more information, see Encrypting the EPM Cloud User Password.

  8. Configure the EPM Integration Agent startup parameters.

    For more information, see Configuring the EPM Integration Agent Startup Parameters.

  9. Run the EPM Integration Agent as a Windows service.

    For more information, see Running the EPM Integration Agent as a Windows Service.

    If you are not using a Windows service to start the agent, then instead use the bat file described in the next step.

  10. Start the EPM Integration Agent.

    For more information, see Starting the EPM Integration Agent.

  11. Configure synchronous mode.

    For more information, see Configuring Synchronous Mode.

  12. Select the integration flow.

    The integration flow can either be in synchronous mode or asynchronous mode. The mode defines how the agent interacts with the EPM Cloud: either by direct calls from the EPM Cloud to the EPM Integration Agent, or polling by the EPM Integration Agent to determine when an EPM Cloud request for data has been submitted.