Skip to content

Oracle EPM

INFO

The Oracle EPM connector is a Scripted API connector. Please refer to the Scripted API documentation for more details.

The Oracle EPM connector enables data synchronization between Oracle Enterprise Performance Management (EPM) and RAC/M Identity. It utilizes the Oracle EPM REST API to manage users, roles, and groups.

As of version 1.15.1.0 of the Scripted API Connector, the Oracle EPM script only supports read operations on the "Users", "Roles" and "Groups" objects.

Currently, the Oracle EPM connector returns only objects with known relations. For instance, it means that a user that has no groups and no roles will not be present in the results.

The Oracle documentation for this endpoint can be found here: Oracle EPM REST API overview.

Like all scripts used by the Scripted API connector, this script can be modified to meet specific requirements. You can refer to other reference scripts to see how scripts can be modified.

Supported Operations

The connector currently supports the following operations:

  • Read operations for Users, Roles, and Groups

Configuration

The following parameters are required for all Scripted API connectors:

ConfigurationDescription
Script PathPath to the Groovy script
API URLThe URL of the EPM API endpoint

Authentication

The Oracle EPM connector uses the Basic Auth (authentication using username and password) to authenticate to the API. This entails that configuration requires a few custom properties in order to allow the authentication flow to happen properly:

ConfigurationMust contain
Preferred Authentication Methodpassword
UsernameThe username of the account linked with the API Key
PasswordThe password of the account linked with the API Key
ThreadPoolSizeThe number of threads to use (default: All available threads)

These properties will provide sufficient information for the connector to authenticate and perform the required operations on the API.

Resource Paths

The connector uses the following API endpoints:

  • Users: /interop/rest/security/v2/report/usergroupreport
  • Roles: /interop/rest/security/v2/role/getavailableroles
  • Groups: /interop/rest/security/v2/report/usergroupreport