18 EPM Integration Agent

You can extract data and metadata from your on-premises data source and then load the data directly to the Oracle Enterprise Performance Management Cloud using the EPM Integration Agent. The EPM Integration Agent executes a query against an on-premises relational database and then loads the data or metadata to the EPM Cloud. The EPM Integration Agent is defined as a data source for an integration. The EPM Integration Agent may also be extended by way of scripting to access other data sources including third-party REST APIs, non-relational sources, or any system or systems that can be accessed using a Jython, Groovy, or Java program.

The EPM Integration Agent can be deployed in two modes: synchronous and asynchronous. The mode determines how communication is opened between your on-premises data and the EPM Cloud. When an integration is executed in synchronous mode, the EPM Cloud initiates a direct call from the EPM Cloud to the appropriate agent based on the cluster assignment. When an integration is executed in asynchronous mode, the EPM Cloud queues for the integration job to execute. The agent polls at intervals and executes the jobs queued.

You can allocate the integration jobs to different clusters by defining cluster assignments. A cluster enables you to manage the distribution of integration jobs. When an integration job is initiated, the systems checks where a job has been assigned, determines the cluster, and assigns the job to that cluster. The order of precedence for executing a job is determined by the cluster.

This chapter is divided into two sections. The Installing and Configuring the EPM Integration Agent section describes the steps required to configure and deploy the EPM Integration Agent in your enterprise. The EPM Cloud to On-premises Connectivity Using the EPM Integration Agent section describes how to connect to and pull data from your on-premises data sources using the EPM Integration Agent paired with an on-premises data adapter. It also explains how to distribute integration jobs using clusters and assignments in synchronous and asynchronous modes.

Your Goal	Watch This Video
Learn how to integrate your source data using the EPM Integration Agent	Leveraging Source System Data With the EPM Integration Agent
Learn how to manage data using the EPM Integration Agent	Managing Data with the EPM Integration Agent