By Madhu Nair on Jun 26, 2014
Continuing the constant innovation that goes into each Oracle Data Integrator release, this release focuses on supporting Big Data standards that we have seen sweeping the market.
Big Data Heterogeneity
Recognizing the need to integrate data from various forms and sources ODI without losing productivity ODI delivers the following capabilities. Having been chosen as the strategic Extract, Load and Transform (EL-T) standard for Oracle, (ODI is being used as the de facto standard for Oracle applications) it is natural that the product’s latest avatar focuses on some of the most impactful features for our customers. Some of the new Big Data features include
a. JSON support,
b. Hadoop SQOOP integration and
c. Hadoop HBase Integration.
ODI now supports data loading from relation databases to HDFS, Hive and HBase and from HDFS and Hive into relational databases.
All the data movement features are further enhanced through the use of ODI’s Knowledge Modules. Knowledge Modules are easy out of the box functional components that can be easily customized and used to get your project off the ground quicker with easy reusability and productivity gains. As an example, there are Knowledge Modules that write to Hive and helps append data to existing data files.
Enhanced Security and Performance:
All the focus on Big Data does not mean a lesser focus on classic product features. ODI 12.1.3 comes with upgraded Federal Information Processing Standard (FIPS) compliant security standards for all its passwords and sensitive information.
It also has increased performance in two ways. ODI can now load target tables using multiple parallel connections and an improved control for data loading allows users to customize concurrency of jobs that can be run.