In this post, I will highlight the 5 things that you need to know while creating a connection in Oracle EPM Cloud. I will be focusing on connections to invoke internal REST APIs.
You create a connection by navigating to “Tools > Connections”.
Provider Type
The first thing you need to be aware of is the provider type. Depending on the type of connection you are creating, you need to know which option to select. For invoking internal REST APIs, you need to select “Other Web Service Provider” option.
URL for the Connection
Let’s look into the URL for the connection. You can utilize REST APIs to perform tasks in the local EPM instance like invoking a business rule, executing job etc.
If you look at EPM REST APIs documentation, you will get the URL format. It looks like below.
https://<SERVICE_NAME>-<TENANT_NAME>.<SERVICE_TYPE>.<dcX>.oraclecloud.com
/aif/rest/{api_version}/{path}To make better sense, let’s look at the REST API end point for invoking a data pipeline.
