Viewing the Data Integration Home Page

Service administrators see all integrations and Pipelines on the Data Integration home page. When location security is enabled, Power users see only integrations and Pipelines assigned to the locations to which they have been granted. Otherwise, Power user can view all integrations and Pipelines.

Features include:

Feature Description
Search

Search the list of integrations based on selected text in any of the fields.

For example, if you type File, the system returns all integrations when the name "File" appears in the Name, Location, Source, or Target fields.

(Sort)

Sort the list of integrations based on a condition.

Available conditions:

  • Name
  • Location
  • Source
  • Target
  • Last Executed
  • Result

Sort results can be listed in Ascending order Image shows the Sort Ascending icon. (A to Z) or Descending order Image shows Sort Descending icon (Z to A).

Image shows the Add icon.

Enables you to add a new integration or a new Pipeline.

When working with integrations and a service administrator assigns the Data Integration – Run role to a user, the user can view the details of an integration but not edit or change the integration definitions. For more information, see Data Integration Roles in Administering Access Control for Oracle Enterprise Performance Management Cloud

When location security is enabled, non-administrators can view Pipeline jobs in ready-only mode (cannot edit or create a Pipeline) 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.)

Image shows the Delete Integration icon.

Delete an integration.

When you select an integration to be deleted, a Delete Confirmation page displays with the following message: " Deleting the integration <integration name> will delete all related artifacts like dimension mapping, member mapping and any data loaded using the integration. Do you want to proceed?"

Image shows the Refresh icon.

Refresh the home page.

Image shows Action menu.

Provides quick access to key Data Integration functions including:

  • Process Details

    See Viewing Process Details

  • Applications: Gateway to integrate data between source systems and target applications, and apply business rules. See Registering Applications.

  • Period Mapping: Define and manage various kinds of calendars (for example, monthly, weekly, or daily) based on your business and statutory requirements. See Managing Period Mappings.

  • Category Mapping: Define and manage category mappings, which enables you to categorize and map source system data to a target Scenario dimension member. See Managing Category Mappings.

  • System Settings: Use system settings to set, update, or clear system level options that apply to the entire system. See System Settings.

  • Locations: Use Locations to view all locations used in your integrations and Pipeline. You can filter the locations displayed and optionally delete any used locations. See Viewing Locations
  • Agent, Query, and Download Agent options (EPM Integration Agent). See EPM Integration Agent.

  • File Browser: Launch the File Browser from which you can navigate to the inbox, outbox, and select files. See Using the File Browser.

Image shows the POV Period Drop_Down.

Enables you to select and save the POV period used when running an integration. If no POV period is selected, then the system defaults to the last used period based on browser cache.

You can select another period when an unlock icon (Image shows the unlock icon. appears next to it.

(Data Integration detail)

Show the detail of each integration including:

  • Status—Indicates the status of each integration. To show the process details of the integration, click on the status icon.
    • Image shows Success icon.—Integration was executed successfully.
    • Image shows the Failed icon.—Integration execution failed.
    • Image shows the New Integration icon.—New Integration
    • Image shows Pending status.—Integration was processed with warnings.
  • Type: Identifies the type of feature including:

    • Image shows the Integration job type icon.—Integration job type
    • Image shows the Pipeline icon.—Pipeline job type
  • (Data Integration) Name
  • (Data Integration) Location
  • Source
  • Target
  • Last Executed
  • Actions (…)—Go to workflow processes including:
    • General
    • Map Dimensions
    • Map Members
    • Options
    • Process Details
    • Workbench
  • (Run Integration/Pipeline) Run Integration icon