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 Scripting
  5. Integrating Oracle Autonomous Database Data Using the EPM Integration Agent
  6. Configuring the EPM Integration Agent to Connect to the Oracle Autonomous Database
  7. Deploying the EPM Integration Agent in a Cloud Infrastructure (OCI) Compute Instance

Deploying the EPM Integration Agent in a Cloud Infrastructure (OCI) Compute Instance

When loading or writing back data to and from the Oracle Autonomous Database, you can put the EPM Integration Agent in an Oracle Cloud Infrastructure (OCI) Compute instance.

The Oracle Cloud Infrastructure provides Compute instances so that you can provision and manage compute hosts. You can create instances as needed to meet your compute and application requirements such as providing the processing power and memory capacity for the virtual servers they host. After you create an instance, you can access it securely from your computer, restart it, attach and detach volumes, and terminate it when you're done with it. Any changes made to the instance's local drives are lost when you terminate it.

Deploying the EPM Agent on an Oracle Cloud Infrastructure Compute instance provides the following advantages:

  • Simple installation

  • No special network configuration is required such as a firewall or opening a port in an on-premises environment.

  • All data traffic is in the Cloud and there is no data transfer to the on-premises environment.

When a Compute instance is used, the agent establishes connectivity between the Oracle Enterprise Performance Management Cloud and the Oracle Autonomous Database. This approach provides customers with scalability and flexibility for their solution. You still need to create the integration definitions including the Oracle Autonomous Database adapter, SQL query, and mapping within Data Integration.