Invoke EPM Pipeline from a Pipeline

Invoke EPM Pipeline from a Pipeline

This is a common question I get aksed numerous times. Hey Arun, Is it possible to invoke a pipeline from a pipeline?

Read along to understand if it is possible.

The Short Answer

The short answer is Yes. It is possible to invoke a pipeline from a pipeline. Although, there are no out of the box job types to invoke a pipeline from another pipeline, there is another easy way.

  1. Create a Groovy Business Rule to invoke Pipeline B
  2. In Pipeline A, add the Groovy Business Rule as a job type in one of the stages

With this approach, you are able to invoke a Pipeline from another pipeline.

Groovy Business Rule to invoke a Pipeline

I have made a video about this. You can check it out down below.

Create a Pipeline. Let's call it FILEOPEX. Here is the code to invoke the Pipeline.


Article content

  • Pipeline is the connection name
  • FILEOPEX is the pipeline code

Refer to the video to learn more about how to create the connection.

Make sure to save and deploy the Groovy BR.

Add Groovy BR to the Pipeline

Go ahead and create a pipeline and create a stage. In the stage, add a new job type. Let's name this Pipeline as "Invoke Pipeline".


Article content

I have created one stage and added a Business job Type to the stage. For the Business Rule job type, I have selected the Groovy Business Rule I created.

When I run the "Invoke Pipeline" pipeline, the Groovy Business Rule is executed, which inturn, invokes the FILEXOPEX Pipeline. This mimics invoking a pipeline from a pipeline.

That is all is needed to invoke a Pipeline form a pipeline. I keep saying Groovy is a game changer and you shoud be adopting it. Hopefully, this example is pushes you one step closer to learning Groovy.

You can enhance the BR to include parameters to be passed.

Conclusion

Hopefully, I was able to answer the question. Groovy, Pipeline and REST APIs are a powerful combination.

Let me know if you have questions.

Great post - I remember being one of the people to ask you this when you first started talking about pipelines.

Neha Kumar

Oracle EPM Consultant | Team Lead | Essbase| EPM Automate | PBCS | Groovy | Smart View | Coder | Educator

11mo

Very informative 💡. Thank you for sharing,

To view or add a comment, sign in

Others also viewed

Explore topics