ODI 12c R2 (12.2.1.2.6) version latest features.

ODI 12c R2  (12.2.1.2.6) version latest features.

Big Data investments include Spark Streaming support,
 Apache Kafka and Apache Cassandra support, enhanced support around Hadoop Complex Types and
Storage Formats in addition to enhancements to ODI’s Big Data Configuration
Wizard.


New Flatten and Jagged Components

 Oracle Data Integrator introduces the Flatten component for mappings which allows complex sub-structures to be processed as part of a flat list of attributes. Oracle Data Integrator also introduces the Jagged component which converts Key-Value lists into named attributes for furtherprocessing.

Support for Cubes and Dimensions

Core ETL – ELT enhancements have been made; where ODI now provides support for two types of dimensional

objects: Cubes and Dimensions. Users can create and use Cubes and Dimensions objects directly in Mappings to

improve developer productivity with out of the box patterns that automate the loading of dimensional objects. This

also allows for improved Type 2 Slowly Changing Dimensions and brand new Type 3 Slowly Changing Dimensions

support with ODI.

12.1.3 features.

Design-Time Experience and Productivity
New Model and Topology Objects Wizard
The Create New Model and Topology Objects dialog in the Designer Navigator provides the ability to create a new
model and associate it with new or existing topology objects, if connected to a work repository. This dialog enables
you to create topology objects without having to use Topology editors unless more advanced options are required.

Orchestration of Oracle Data Integrator Jobs using Oozie

Oracle Data Integrator supports both the traditional Oracle Data Integrator Agent and Apache Oozie as the

orchestration engine for Jobs – including: mappings, packages, scenarios, and procedures. Apache Oozie allows

native execution on a Hadoop infrastructure without installing an Oracle Data Integrator agent for orchestration.

Users can utilize Oozie tooling to schedule, manage, and monitor the Jobs. Oracle Data Integrator uses Oozie’s

native actions to execute Hadoop processes and conditional branching logic.

Oracle Data Integrator Console Enhancements

Now security tasks can be done in ODI Console.

The overall look and feel of the Oracle Data Integrator Console has been improved. Additionally, security tasks

such as creating users or profiles can now be performed using the Console. Release Management activities can be

performed through the Console, and functionality related to Topology tasks has been enhanced.

Enhanced Big Data Support

Oracle Data Integrator’s previous 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. With this release, we continue to enhance this

functionality by allowing users to choose between Task and Session execution modes for Oozie workflow

generation. Users can choose between Task and Session execution modes for Oozie workflow generation. The

new Session mode allows support for transactions, scripting, and loops in packages. Oracle Data Integrator will

automatically choose the correct mode based on the executed object, or the mode can be manually selected.

Enhanced Hive Driver and Knowledge Modules

Oracle Data Integrator includes the WebLogic Hive JDBC driver that provides a number of advantages such as full

JDBC compliance and improved performance. All Hive Knowledge Modules have been rewritten to take advantage

of this new driver. Also, Knowledge Modules whose main purpose is to load from a source are now provided as

Loading Knowledge Modules, enabling them to be combined in a single mapping with other Loading Knowledge

Modules. A new class of “_direct load_” Loading Knowledge Modules also allows loading of target without

intermediate staging. Additionally, the table function component has been extended to support Hive constructs.

New/Updated Hive Component Style Knowledge Modules:

1. LKM SQL to HiveSQOOP
2. LKM SQL to File SQOOPDirect
3. LKM SQL to HBase SQOOPDirect
4. LKM HBase to SQLSQOOP
5. LKM File to SQLSQOOP
6. LKM Hive to SQLSQOOP
7. LKM File to Hive LOADDATA
8. LKM File to Hive LOAD DATA Direct
9. LKM HBase to HiveHBASE-SERDE
10. LKM Hive to HBase Incremental Update HBASE-SERDE Direct
11. IKM HiveAppend
12. LKM Hive to FileDirect
13. LKM Hive to OracleOLH-OSCH
14. LKM File to Oracle OLH-OSCH Direct
15. LKM Hive to OracleOLH-OSCH
16. LKM Hive to Oracle OLH-OSCH Direct
17. XKM Hive Sort

Cancelling of Import/Export and Reverse Engineering Operations

Oracle Data Integrator now provides the ability to cancel import/export and reverse engineering operations that may

run for a longtime.

Support for Analytic or Window Functions
Oracle Data Integrator supports Analytic or Window functions out of the box at the Mapping Level. Analytic functions
such as PERCENT_RANK, LAST, FIRST, or LAG can be used at the Mapping Expression level in any component.


Ability to View the List of Users Connected to the Studio/Repository
The Review User Activity menu item has been added to the Security Menu. This allows viewing, purging, and
saving of user activity record in the User Connections dialog. This is available in both the Oracle Data Integration
Studio and the Oracle Data Integrator Console.

Complex File Enhancements
Oracle Data Integrator’s Native Format builder utility is now included with Oracle Data Integrator Studio and allows
you to create nXSD files without having to leave the Oracle Data Integrator user interface

Complex File, File, LDAP, JMS Queue XML, JMS Topic XML, and XML Technology Enhancements

Oracle Data Integrator’s JDBC properties for Complex File, File, LDAP, JMS Queue XML, and XML technologies

are now displayed att the Data Server level along with default values where applicable and a description of those

properties, in an effort to enhance usability.