Tuesday Jan 26, 2016

ODI 12c KMs are now available for Oracle Hyperion Planning and Essbase

Oracle Essbase and Oracle Hyperion Planning Knowledge Modules (KMs) are now available for Oracle Data Integrator 12.2.1. The patches containing the KMs are available for download on My Oracle Support. Patch# 20109114 contains Oracle Essbase KMs and Patch# 21903914 has Oracle Hyperion Planning KMs. The KMs support latest version (11.1.2.4) of these Hyperion Applications.  All the features available in their corresponding 11g KMs are available in these 12c KMs as well.

Friday Dec 18, 2015

Oracle Management Pack for Oracle Data Integrator for Enterprise Manager 13.1 is out! Make the most of the value of your Oracle Data Integrator investments!

We’ve mentioned before that 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’s Management Pack for Oracle Data Integrator is a great addition! As a quick refresher: this 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 (11.1.1.7.0 and higher) and 12c versions of Oracle Data Integrator (12.1.2, 12.1.3 and 12.2.1).

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.


In review, important capabilities include:

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 Servers.

Configuration Management

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

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) options.

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 reporting.

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. (For additional detail and to review another blog on the subject, click here.)

Oracle Management Pack for Oracle Data Integrator is licensed separately. From an installation perspective it is packaged in the Fusion Middleware plug-ins for Enterprise Manager (version 12.1.0.4 and higher) and comes with the base Enterprise Manager 12c or 13c download. There is no separate installation file to download. More information can also be found here.

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

Monday Dec 07, 2015

Big Data Preparation Cloud Service

Preparing Complex Data For Use

Even in the most well designed big data projects, a larger portion of the effort and cost is spent in preparing complex data ready for analysis. Big Data Preparation Cloud Service (BDPCS) flips that equation. Minimizing the data preparation time helps unlock the value of complex data quickly. However, data preparation is not just a series of sorting, prepping and standardization operations. When done right, it is a crucial step to enrich data. To unearth insights and prepare a data enrichment pipeline that can then be operationalized to deliver higher quality and vastly insightful data to downstream applications.

Oracle Big Data Preparation Cloud Service is part of the comprehensive Cloud Platform for Big Data that Oracle announced during Open World.

Built for Analysts, Data Scientists and Data Experts

BDPCS utilizes a non technical, web based interface to guide the data preparation effort. This is keeping in view that data preparation should not be dependent on technical skills but business expertise. This brings data science closer to the business experts, data analysts and data scientists. Natural Language Processing based algorithms surfaces recommendations that can be then applied as business and enrichment rules to the data set. These recommendations are presented as "plain english" texts that can then be modified and updated.

Build on Apache Spark, Big Data Preparation Cloud Service also includes a responsive visual element that profiles the data sets for even further analysis and standardizations. Using Big Data Preparation Cloud Service, experts can now pull data, mash them up, enrich the data and publish it quickly. This allows them to iterate through many analysis that generally take weeks or sometime months to co ordinate with the IT and technology teams.

Differentiators

Data preparation and data wrangling is attracting a lot of investment as Data Science enters the next stage of refinement. Big Data Preparation Cloud Service brings certain critical elements that puts it ahead of its competition.

It brings recommendation driven user experience

It utilizes Natural Language Processing classifications and enrichment, and

It has extensive automation capabilities.

For more details about Oracle Big Data Preparation Cloud Services visit our homepage here.

Tuesday Nov 03, 2015

Oracle Data Integrator 12.2.1 and Big Data

Oracle Data Integrator 12.2.1 brings a number of Big Data features such as Spark and Pig language generation support, executing ODI jobs in the Oozie workflow engine, and all new knowledge modules with improved Hive support. 

We provided a first release of most Big Data features as a patch 12.1.3.0.1 on top of the 12.1.3 release, and have included it now as part of the 12.2.1 release. In addition, we provided further improvements to the initial feature set, such as new Oozie Execution modes. You can now choose between Task and Session execution modes for Oozie workflow generation. The new Session mode allows support for transactions, scripting, and loops in packages and will run a session in a single Oozie action, whereas the Task mode uses a separate Oozie action for each ODI task. ODI will automatically choose the correct mode based on the executed object or the mode can also be manually selected.

ODI provides developer productivity and can future-proof your investment by overcoming the need to manually code Hadoop transformations to a particular language.  You can logically design your mapping and then choose the implementation that best suits your use case. 

Friday Oct 23, 2015

Announcing Oracle Data Integrator (ODI) 12.2.1 – Focus on Big Data and Lifecycle Management Innovations

Oracle Data Integrator 12.2.1 makes its debut today, with new and enhanced functionality in many aspects of its core capabilities. Take a look here for the latest details – and read on for some highlights:

Big Data

Back in April we proudly announced the availability of Oracle Data Integrator for Big Data. The release brought together a series of advanced Big Data updates and features that Oracle Data Integration is rolling out for customers to help take their Hadoop projects to the next level with support for Apache Spark, Apache Pig, and orchestration using Oozie. Today, we continue to enhance this functionality by allowing users to choose between Task and Session execution modes for Oozie workflow generation.