Configuring the EPM Integration Agent on a Compute Instance

After you have created an Oracle Cloud Compute instance, you need to connect to it, and then transfer and install the EPM Integration Agent and other related components.

Note:

This implementation uses the Secure Shell (SSH) client software to establish a secure connection and log in as a opc user.

Before you begin creating compute instance system, you need the following:

  • An Oracle Cloud user account that has access rights to manage Compute instances in the given compartment, to use the given VCN and subnet, and to view information about the dedicated database you will be connecting to.

  • The name of the compartment, VCN and subnet to use when creating the Oracle Cloud Compute instance. Your autonomous database administrator or tenancy administrator should be able to provide you this information.

  • For installing and configuring the EPM Integration Agent on the Compute instance, you will need the following files:

    • EPMAgent.zip
    • Wallet
    • SSL certificate for use with the Oracle Enterprise Performance Management Cloud
  • WinSCP for transferring files. WinSCP is a free download available at: https://winscp.net/eng/index.php

To configure the EPM Integration Agent on a Compute instance:

  1. Connect to the Compute instance with the host name, user name, password or SSH key.

    For more information about connecting to the Compute Instance, see Connecting to the Compute Instance Using Putty or Connecting to the Compute Instance Using WSCP.

    Additional connection information is available at Connecting to an Instance.

  2. Install Oracle Java on Oracle Linux running in your OCI compute shape by using RPMs available from the OCI yum service.

    For instructions on installing Oracle Java, see How to Install Oracle Java in Oracle Cloud Infrastructure.

  3. Log into WinSCP with the host name, user name, and password, and then click Login.

    WinSCP opens in a directory structure similar to Windows File Explorer.

  4. Transfer the following files by dragging and dropping them from your source directory to a directory on the Compute instance:

    • EPMAgent.zip.

      The latest EMPAgent.zip is available for download from your local network from Data Integration. For more information, see Downloading the EPMAgent ZIP.

    • Wallet—The wallet files store the client credentials from the Autonomous Database Service Console.

      For more information about the wallet, see Connecting to the Oracle Cloud Infrastructure.

    • SSL certificate—Certificate used with the EPM Cloud.

      The certificate is required to enable an encrypted connection between the EPM Cloud and the EPM Integration Agent.

      Optionally, you can also use the scp command line utility to securely copy files and directories between your local system to a remote system. The SCP command syntax uses the following format: scp [OPTION][user@]SRC_HOST:]file1 [user@]DEST_HOST:]file2

      Here are sample scp commands that you might use when transferring the EPM Integration Agent components required for this configuration on Linux and Mac.

      scp -i /Users/Oracle/Documents/oci/ssh-key-private.key epmagent.jar opc@<OCI INSTANCE PUBLIC IP ADDRESS>:/home/opc/epmagent.jar

      scp -i /Users/Oracle/Documents/oci/compute/ssh-key- private.key epm.cer opc@<OCI INSTANCE PUBLIC IP ADDRESS>:/home/opc/epm.cer

      scp -i /Users/Oracle/Documents/oci/compute/ssh-key- private.key Wallet-epm.zip opc@<OCI INSTANCE PUBLIC IP ADDRESS>:/home/opc/Wallet-epm.zip

  5. Extract the EPMAgent.zip in your destination folder.

    Typically, the destination folder is <AGENT_HOME>.

  6. Copy the wallet to a configuration directory or create a wallet directory at <EPMAgentDevData\config> or <EPM_APP_DATA_HOME> and then unzip it.

  7. Copy the certificate to the <EPM_AGENT_HOME/cert> directory.

  8. Start the agent on the Compute instance.

    For more information, see Starting the EPM Integration Agent.