Oracle® Cloud

What's New for Oracle Data Integrator Cloud

E93725-01

January 2019

What’s New for Oracle Data Integrator Cloud

As soon as new and changed features become available, Oracle Data Integrator Cloud Service (ODICS) instances are upgraded in the data centers where Oracle Cloud services are hosted. You don’t need to request an upgrade to be able to use the new features—they come to you automatically. Here’s an overview of new features and enhancements added recently to improve your ODICS experience.

Topics:

This section summarizes the new features and significant product changes for ODICS 19.1.1 release, which includes Oracle Data Integrator 12.2.1.3.1 running on Java Cloud Service 19.1.1.

New and Changed Features for Oracle Data Integrator Release 12c (12.2.1.3.1)

Oracle Data Integrator 12c (12.2.1.3.1) introduces new functionality in the following areas:

These key investment areas ensure that Oracle Data Integrator (ODI) will continue to accompany customers throughout their technological transformation and modernization process.

Oracle Object Storage and Oracle Object Storage Classic

Oracle Object Storage and Object Storage Classic offers fast, reliable and secure cloud storage and now Oracle Data Integrator can seamlessly integrate with them on Oracle Cloud Infrastructure (OCI).

ODI comes with a set of Knowledge Modules (KMs) and ODI Tools that can used in Mappings and Packages to connect to Oracle Object Storage and Object Storage Classic for uploading, downloading and deleting files/objects onto/from local directory or the Hadoop Distributed File System (HDFS).

For more details, see Oracle Object Storage and Oracle Object Storage Cloud documentation.

Autonomous Databases: Autonomous Data Warehouse and Autonomous Transaction Processing

Oracle Data Integrator now comes with optimized Loading and Integration Knowledge Modules (KMs) that are certified with Oracle Autonomous databases:

  • Oracle Autonomous Data Warehouse Cloud (ADWC)

  • Oracle Autonomous Transaction Processing (ATP)

Oracle Data Integrator seamlessly integrates with ADWC and ATP. By integrating ODI with Autonomous databases, you can get the full performance of Oracle Data Integrator and Oracle databases, in a fully-managed environment that is tuned and optimized for various workloads. The same set of Knowledge Modules are used for both ADWC and ATP and also leverage the new native integration with Oracle Object Storage and Oracle Object Storage Classic.

In addition to being able to load data directly into ADWC or ATP, Oracle Data Integrator users can benefit from the native integration between Oracle Autonomous Data Warehouse and Oracle Object Storage to enable extremely fast data transfer into ADWC or ATP. ODI can then automate the complete loading process of Oracle Autonomous Data Warehouse Cloud (ADWC) and Oracle Autonomous Transaction Processing (ATP).

For more details, see Oracle Autonomous Data Warehouse Cloud and Oracle Autonomous Transaction Processing documentation.

Oracle Enterprise Resource Planning (ERP) Cloud

This release also adds a new Technology and Knowledge Modules for Oracle Enterprise Resource Planning (ERP) Cloud, a suite of cloud applications for finance, project management, procurement, risk management and other core day-to-day activities important in every business, regardless of size, industry or geography. Oracle Data Integrator (ODI) seamlessly integrates with Oracle Enterprise Resource Planning (ERP) Cloud and helps organizations integrate their ERP data into their data warehouses, data marts or data lakes. This native integration also allows ODI users to load data into Oracle ERP Cloud.

For more details, see Oracle Enterprise Resource Planning Cloud documentation.

New and Changed Features for Oracle Data Integrator Release 12c (12.2.1.3.0)

Oracle Data Integrator 12c (12.2.1.3.0) introduces the following enhancements:

Cloud and Big Data remain key investment areas and ensure that Oracle Data Integrator will continue to accompany customers throughout their technological transformation and modernization process.

Big Data

Big Data continues to evolve within Oracle Data Integrator with advances including:

  • Spark Knowledge Modules Improvements — In this release, the focus has been on generating high performing and easily readable Spark code that will stand up to any handwritten scripts. In addition, the Spark Knowledge Modules (KMs) are now leveraging the latest Apache Spark 2.x features such as Dataframes. SparkSQL is also leveraged where applicable to speed up the ODI processes running on Spark.

  • Spark KMs Support in Knowledge Module Editor — The Spark KMs are now fully supported in the Knowledge Module editor and can be tailored to your own specific requirements.

  • Hadoop Complex Types Enhancements — ODI 12.2.1.2.6 introduced Complex Types support for Hive and HDFS (batch mode) technologies. ODI 12.2.1.3.0 further improves this functionality for Spark Streaming with Complex Types support in Apache Kafka as well as in HDFS.

  • Big Data Configuration Wizard — The Big Data Configuration Wizard has been improved with newer templates for the latest Cloudera’s Distribution including Apache Hadoop (CDH) releases.

Cloud

Cloud improvements include:

  • Certification with Salesforce.com — Oracle Data Integrator is fully certified with Salesforce.com and now includes a JDBC driver for this technology out of the box.

Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Access to Oracle Support

Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.

Oracle Cloud What's New for Oracle Data Integrator Cloud

E93725-01

Copyright © 2019, , Oracle and/or its affiliates. All rights reserved.

Documentation that describes new features and functions available in Oracle Data Integrator Cloud.

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:

U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.