Photo by Alina Grubnyak on Unsplash

Invoke Oracle EPM Data pipeline using REST API

Arun Raj
2 min readAug 25, 2023

--

Data pipeline was a feature introduced in Oracle EPM in the June 2023 monthly updates. In this article I will show you how to invoke a Data Pipeline using EPM REST API.

Click the links below to read my articles on Data Pipeline:

Configuring the Data Pipeline

When you configure the data pipeline, you have to provide the following information:

  • Pipeline Name
  • Pipeline Code: This cannot be changed later.
  • Maximum Parallel Jobs

Pipeline code is what we will be using to identify the pipeline during the REST API call.

Invoking the Pipeline using REST API

The data pipeline REST API can be used to invoke the Data Pipeline. The details of API can be found here.

  • REST API End point: /aif/rest/{api_version}/jobs
  • API Version: V1

While invoking the REST API, you need to pass the below payload.

The most import parameters to be passed in the payload are:

  • jobName: This is the Pipeline code
  • jobType: “pipeline”

--

--

Arun Raj

Mostly write about Oracle Cloud ERP and EPM related Topics. Interested about emerging AI technologies, Python and Low Code Tools