Infosys’ blog on industry solutions, trends, business process transformation and global implementation in Oracle.

« Oracle Stream Analytics | Main | Synopsis of EPM Cloud Updates - April 2020 »

EPM Agent Integration

Introduction:


The EPM integration agent is used for extracting data from on-premises and loading it into Oracle EPM Cloud applications. We can connect the on-premises data sources using SQL queries.


Download EPM Agent:


Login into PBCS application, goto Application and click on Data Exchange:

                    

A1.png


Click on Actions under Data Integration and choose Download Agent from the drop down list.


           
A2.png


Update parameter.ini file:

Extract the Zip folder and update the .ini file which is located under windows folder.

           
A3.png

        
A4.png


Extract the Zip folder and update the agentparams.ini file which is located under windows folder:


A5.png


Password Encryption

Use the encryptpassword.bat job to encrypt the password and update it in the agentparams.ini file:


           
A6.png

Create App folder:

Run the CreateAppFolder.bat file to create app folder.

A7.png


Download the SSL certificate


Access the Cloud service URL and Download the SSL certificate

Place the downloaded the certificate into cert folder.


A8.png

A9.png

Start the EPM Agent:

Set the EPM Agent home directory in cmd and run the EPMAgent.bat file


A10.png



Define SQL query in EPM Cloud:



Goto Actions and click on Query

Create new query with SQL


A11.png


A12.png



Creating SQL query using REST API


Launch SoapUI


A13.png

A14.png

REST API Project

Create new REST API project with EPM

Cloud Service URL

A15.png

SQL Query Parameter

Set the SQL query


A16.png

Update Authorization details

A17.png


A18.png

Create Target Application in  

Data Management


Create new target application with Data source option

Select On-Premise Data base and upload the file template.

Create Location and Import formats.

A19.png
A20.png


Create Data Integration
 Define Source and Target application in the data integration

  Define the mapping and save it.

  Run the data integration


A21.png


Trigger the data load rule in DM:


Execute data load rule

A22.png

Data Extraction from Database Source:

The data extracted successfully.


Picture23.png

Subscribe to this blog's feed

Follow us on

Blogger Profiles