Welcome to All Things Data Integration: Announcements, Insights, Best Practices, Tips & Tricks, and Trend Related...

Welcome Oracle Management Pack for Oracle Data Integrator! Let’s maximize the value of your Oracle Data Integrator investments!

Sandrine Riley
Product Management - Data Integration Solutions at Oracle

To help you make the most of Oracle Data Integrator, and to
deliver a superior ownership experience in an effort to minimize systems
management costs, Oracle recently released Oracle Management Pack for Oracle Data
. This new product leverages Oracle Enterprise Manager Cloud Control's advanced
management capabilities to provide an integrated and top-down solution for your
Oracle Data Integrator environments. Management
Pack for Oracle Data Integrator supports both 11g ( and higher) and 12c
versions of Oracle Data Integrator.

Management Pack for Oracle Data Integrator provides a
consolidated view of your entire Oracle Data Integrator infrastructure. This enables users to monitor and manage all
their components centrally from Oracle Enterprise Manager Cloud Control.

Performance Monitoring
and Management

Management Pack for Oracle Data Integrator streamlines the
monitoring of the health, performance, and availability of each and all
components of an Oracle Data Integrator environment – this includes Master and
Work Repositories, Standalone and JEE agents, as well as source and target Data

Figure 1 – Management Pack for Oracle Data Integrator - Dashboard

Through an easy-to-use graphical interface, administrators and
operators are able to quickly asses the status of their Oracle Data Integrator
environments. The Dashboard page
provides a summary of the health of each Oracle Data Integrator components, and
clearly highlights potential issues with links for drill-down such that users
can easily further investigate and assess more details.

Figure 2 – Management Pack for Oracle Data Integrator–
Repositories Page

The Repositories page clearly offers key database statistics and
performance metrics, where users can easily track the growth of the repository
tablespace and purge the Oracle Data Integrator logs when needed – one of
Oracle Data Integrator’s best practices!

Figure 3 – Management Pack for Oracle Data Integrator– Database
Execution Details Page

The Load plan Executions/Sessions page allows developers and
operators to view the entire Oracle Data Integrator Sessions activities and
review detailed execution statistics; such as the overall duration of
processes, or the number of inserts, updates, deletes performed. Users can click to access database details on
Oracle, or to view a relevant entire SQL statement generated by Oracle Data

Figure 4 - Management Pack for Oracle Data Integrator– Agents Details

The Agents Page provides the list of Oracle Data Integrator
Agents and the ability to drill down into each one. Recently triggered alerts or warnings can
also be viewed. Overall metrics for agent
performance, with quick links to session details are provided.


To ensure that the configurations of all critical Oracle Data
Integrator components in production environments are consistent with staging or
test environments, Management Pack for Oracle Data Integrator provides
Configuration Snapshots to save working configurations into the Management
Repository or into an external XML file. These snapshots can then be compared with the active configuration in
staging or test environments, or against any historical snapshot. Configuration Comparison is the next logical
step which thus allows you to ensure the consistency of configurations in your
application environment. Going one step
further, Configuration History keeps track of all configuration changes, which
can help in diagnosing performance problems that may be related to
configuration changes along the way.

Service Level

Management Pack for Oracle Data Integrator allows for a
proactive method to monitor Oracle Data Integrator environments at all
levels. Many out of the box metrics are
automatically collected for each Oracle Data Integrator component
(repositories, agents, sources, targets…) which then provides users the ability
to set up alerts based on critical or warning thresholds. Notifications can be provided to users in
various ways through emails or Simple Network Management Protocol (SNMP)

Historical Analysis
and Reporting

While real-time metrics certainly come in handy, there is also
something to be said for historical collection of data! Management Pack for Oracle Data Integrator
stores collected metrics and configurations data in a central repository
–allowing users to thus analyze the metrics in various incremental views that
include; last 24 hours, last 7 days, last 31 days. In addition, customizable service and system
dashboard functionality allows users to create reports on various services and
systems for service level availability, usage, performance, and business
indicators – all in an effort to facilitate strategic trend analysis and

In a nutshell,
Oracle Management Pack for Oracle Data Integrator benefits include: reducing
the costs associated with monitoring the overall Oracle Data Integrator
infrastructure and providing visibility into complex Oracle Data Integrator
deployments across the enterprise
, minimizing troubleshooting and performance tuning efforts
as well as improving the
overall ability to efficiently monitor Service Level Agreement compliance using
powerful alerting capabilities.

Oracle Management Pack for Oracle Data Integrator
is a new Management Pack, licensed separately. From an installation perspective it is packaged in the Fusion Middleware
plug-ins for Enterprise Manager (version and higher) and comes with
the base Enterprise Manager 12c download. There is no separate installation
file to download.

Try it out! Getting Started with Oracle Fusion
Middleware Management Plug-in

Join the discussion

Comments ( 1 )
  • Kalyana Chakravarthy Monday, February 15, 2016


    Is the dashboard available for


    Kalyana Chakravarthy

Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.