Allowing Non-Administrators to Execute Jobs in the Pipeline

Non-administrators can now execute an individual Pipeline job type using proxy administrator user credentials. Optionally, non-administrator users can also view Pipelines in read-only mode (cannot edit or create a pipeline) depending on the user group access granted to them in Location Security.

To create a proxy server user credential, an administrator with a service administrator role (can grant user roles), specifies a proxy admin username on the Create Pipeline page.  If the proxy user name is different than the service administrator's username, then the system prompts the user to enter a password.

If the user executing a job is a non-administrator and no proxy admin user credentials are specified, the system executes all jobs as non-administrator users. In this case, the Pipeline can only include jobs that do not require a service administrator to execute them, for example an integration job. If jobs require an service administrative to execute them and a non-administrator without a proxy administrator user credentials attempts to execute them, then the Pipeline process fails.

Applies to: Enterprise Data Management, Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm,  Planning

The new proxy administrator user credential options are shown below:

Image Shows The Create Pipeline Page.

Image Shows The Create Pipeline Page

Location Security is an additional framework in which service administrators can secure access to the Pipeline. When Location Security is enabled, Data Integration evaluates the user groups by location to which a user has been assigned and determines the following view access:

  • When location security is enabled, non-administrators can view Pipeline jobs in ready-only mode and run individual jobs in the Pipeline based only on the users groups by location to which they have been assigned in Location Security. (The service administrator can create, edit, and run any job type in the Pipeline.)
  • When location security is not enabled, non-administrators can view all Pipeline jobs in read-only mode and run any individual job in the Pipeline. (The service administrator can create, edit, and run any job type in the Pipeline.)

Business Benefit: You can now enable non-administrator to execute and monitor the Pipeline for which they have process ownership. The access to Pipeline can be restricted using Location Security consistent with better control access to appropriate non-administrative users.

Steps to Enable

In Data Integration, from the Actions menu, select System Setting, then in the Enable Pipeline Execution for Non-Admin option, select Yes. 

Key Resources

  • System Settings in Administering Data Integration for Oracle Enterprise Performance Management Cloud