contributed by Mike Eisterer
On October 17th, 2013, Oracle announced the
release of Oracle Data Integrator 12c (ODI12c).
This release signifies improvements to Oracle’s Data Integration
portfolio of solutions, particularly Big Data integration.
Why Big Data = Big Business
Organizations are gaining greater insights and actionability
through increased storage, processing and analytical benefits offered by Big
Data solutions. New technologies and
frameworks like HDFS, NoSQL, Hive and MapReduce support these benefits now. As
further data is collected, analytical requirements increase and the complexity
of managing transformations and aggregations of data compounds and
organizations are in need for scalable Data Integration solutions.
ODI12c provides enterprise solutions for the movement,
translation and transformation of information and data heterogeneously and in
Big Data Environments through:
Working with Big Data using Knowledge Modules
developers with the ability to define sources and targets and visually develop
mappings to effect the movement and transformation of data. As the mappings are created, ODI12c leverages
a rich library of prebuilt integrations, known as Knowledge Modules (KMs).
These KMs are contextual to the technologies and platforms to be
integrated. Steps and actions needed to
manage the data integration are pre-built and configured within the KMs.
The Oracle Data Integrator Application Adapter for Hadoop
provides a series of KMs, specifically designed to integrate with Big Data Technologies. The Big Data KMs include:
Nothing to beat an Example:
demonstrate the use of the KMs which are part of the ODI Application Adapter
for Hadoop, a mapping may be defined to move data between files and Hive
is defined by dragging the source and target into the mapping, performing the
attribute (column) mapping (see Figure 1)
and then selecting the KM which will govern the process.
mapping example, movie data is being moved from an HDFS source into a Hive
table. Some of the attributes, such as
“CUSTID to custid”, have been mapped over.
proper KM can be assigned to define the technology for the mapping, it needs to
be added to the ODI project. The Big
Data KMs have been made available to the project through the KM import process. Generally, this is done prior to defining
Importing the Big Data Knowledge Modules
the import, the KMs are available in the Designer Navigator.
The Project View in Designer, Showing Installed IKMs
Once the KM
is imported, it may be assigned to the mapping target. This is done by selecting the Physical View
of the mapping and examining the Properties of the Target. In this case MOVIAPP_LOG_STAGE is the target
of our mapping.
Physical View of the Mapping and Assigning the Big Data Knowledge Module
to the Target
KMs may have been selected as well, providing flexibility and abstracting the
logical mapping from the physical implementation. Our mapping may be applied to other technologies
is now complete and is ready to run. We
will see more in a future blog about running a mapping to load Hive.
the quick ODI for Big Data Overview, let us take a closer look at what the IKM
File to Hive is doing for us. ODI
provides differentiated capabilities by defining the process and steps which
normally would have to be manually developed, tested and implemented into the
KM. As shown in figure 5, the KM is
preparing the Hive session, managing the Hive tables, performing the initial
load from HDFS and then performing the insert into Hive. HDFS and Hive options are selected
graphically, as shown in the properties in Figure 4.
Process and Steps Managed by the KM
Big Data being
the shape shifting business challenge it is is fast evolving into the deciding
factor between market leaders and others.
Now that an
introduction to ODI and Big Data has been provided, look for additional blogs
coming soon using the Knowledge Modules which make up the Oracle Data
Integrator Application Adapter for Hadoop:
information now, please visit the Oracle Data Integrator Application Adapter
for Hadoop web site, http://www.oracle.com/us/products/middleware/data-integration/hadoop/overview/index.html
Do not forget to tune in to the ODI12c Executive Launch webcast on the 12th to hear more about ODI12c and GG12c.