Oracle Data Integrator Best Practices: Performing Incremental Updates in the Oracle Autonomous Data Warehouse Cloud

 Introduction This article discusses the best practices that users should follow when using Oracle Data Integration Platform Cloud (DIPC) – specifically Oracle Data Integrator (ODI) – to perform incremental updates in the Oracle Autonomous Data Warehouse Cloud Service (ADWC). ADWC is a fully-managed and pre-configured Oracle database cloud service that is tuned and optimized for […]

Oracle Data Integrator Best Practices: Performing the Initial Data Load of a Data Warehouse in the Oracle Autonomous Data Warehouse Cloud

Introduction This article discusses the best practices that users should follow when using Oracle Data Integration Platform Cloud (DIPC) – specifically Oracle Data Integrator (ODI) – to perform the initial data load of a data warehouse in the Oracle Autonomous Data Warehouse Cloud (ADWC). ADWC is a fully-managed and pre-configured Oracle database cloud service that […]

Configuring Oracle Data Integrator for Oracle Big Data Cloud: High-Availability Configuration

Introduction   This article discusses how to configure Oracle Data Integrator (ODI) for Oracle Big Data Cloud (BDC) using the ODI Enterprise or High-Availability installation.  ODI offers out of the box integration with Big Data technologies such as Apache Hadoop, Apache Spark, Apache Hive, Apache Pig, and Apache Kafka, among others.  ODI supports both distributions […]

Configuring Oracle Data Integrator for Oracle Big Data Cloud: Standalone Configuration

Introduction   This article discusses how to configure Oracle Data Integrator (ODI) for Oracle Big Data Cloud (BDC) using the ODI Standalone installation.  ODI offers out of the box integration with Big Data technologies such as Apache Hadoop, Apache Spark, Apache Hive, Apache Pig, and Apache Kafka, among others.  ODI supports both distributions of Hadoop:  […]

Configuring Oracle Data Integrator for Oracle Big Data Cloud: Environment Configuration

Introduction   This article discusses how to configure the Oracle Data Integrator (ODI) for Oracle Big Data Cloud (BDC) – specifically – how to configure the BDC environment for ODI, so users can design Big Data workloads with ODI and execute them on BDC.  ODI offers out of the box integration with Big Data technologies […]

Configuring Oracle Data Integrator for Oracle Big Data Cloud: Topology Configuration

Introduction   This article discusses how to configure the Oracle Data Integrator (ODI) for Oracle Big Data Cloud (BDC), specifically – how to configure the ODI Topology.  ODI offers out of the box integration with Big Data technologies such as Apache Hadoop, Apache Spark, Apache Hive, Apache Pig, and Apache Kafka, among others.  ODI supports […]

Using Oracle Data Integrator with Big Data Cloud

Introduction   This article presents an overview of how to use Oracle Data Integrator (ODI) with Oracle Big Data Cloud (BDC). ODI offers out of the box integration with Big Data technologies such as Apache Hadoop, Apache Spark, Apache Hive, and Apache Pig, among others. ODI supports both distributions of Hadoop: Hortonworks Data Platform (HDP), and […]

Oracle Data Integrator Best Practices: Using Check Knowledge Modules on both On-Premises and Cloud Computing

Introduction   This article discusses the best practices for selecting and using Oracle Data Integrator (ODI) Check Knowledge Modules (CKMs) on both on-premises data servers and cloud data services.  In traditional ETL tools, when an ETL data flow is designed, ETL developers must design steps to perform data validation and remove the records that do […]

Using Oracle Data Integrator Cloud Service (ODICS) to Integrate Field Service Cloud with Business Intelligence Cloud Service (BICS): An ODICS Perspective

Introduction   This article discusses how to use Oracle Data Integrator Cloud Service (ODICS) to integrate Oracle Field Service Cloud (FSC) with Business Intelligence Cloud Service (BICS).  ODICS provides pushdown data processing with high performance ETL for the Cloud. ODICS executes data transformations where the data lies without having to unnecessarily copy data to remote […]

Integrating Oracle Data Integrator (ODI) On-Premises with Cloud Services

 Introduction   This article presents an overview of how to integrate Oracle Data Integrator (ODI) on-premises with cloud services.  Cloud computing is now a service or a utility in high demand.  Enterprises have a mix of on-premises data sources and cloud services.  Oracle Data Integrator (ODI) on-premises can enable the integration of both on-promises data […]

Oracle Data Integrator Best Practices: Using Loading Knowledge Modules on both On-Premises and Cloud Computing

Introduction   This article discusses the best practices for selecting and using the Oracle Data Integrator (ODI) Loading Knowledge Modules (LKMs) on both on-premises and on cloud computing.  LKMs are code templates in ODI that can perform data upload operations from on-premises data servers to cloud services, between cloud services, or between on-premises data servers.  […]

Oracle Data Integrator Best Practices: Using Reverse-Engineering on the Cloud and on Premises

Introduction   This article discusses best practices on using the Reverse Engineering features of Oracle Data Integrator (ODI) on the cloud and on premises.  The first part of this article presents the various options available in ODI to reverse-engineer metadata from a data server.  Then, the article discusses performance considerations when running and executing reverse-engineering […]

Integrating Big Data Preparation (BDP) Cloud Service with Business Intelligence Cloud Service (BICS)

Introduction This article presents an overview of how to integrate Big Data Preparation Cloud Service (BDP) with Business Intelligence Cloud Service (BICS).  BDP is a big data cloud service designed for customers interested on cleansing, enriching, and transforming their structured and unstructured business data.  BICS is a business intelligence cloud service designed for customers interested […]

Using ODI Loading Knowledge Modules on the Oracle Database Cloud Service (DBCS)

Introduction   This article discusses how to use Loading Knowledge Modules (LKMs) in Oracle Data Integrator (ODI) to upload data into instances of the Oracle Database Cloud Service (DBCS).  LKMs are re-usable code templates within the ODI framework that can be used in ODI mappings to perform data upload operations. On cloud computing, Oracle offers […]

Configuring Oracle Data Integrator (ODI) for Amazon Elastic MapReduce (EMR)

Introduction This article demonstrates how to configure Oracle Data Integrator (ODI) for the Amazon Elastic MapReduce (EMR) cloud service.  Amazon EMR is a big data cloud service, available on the Amazon Web Services (AWS) cloud computing services. ODI is well documented to run on both the Cloudera and Hortonworks distributions of Hadoop.  ODI can also […]

Installing Oracle Data Integrator (ODI) on Amazon Elastic MapReduce (EMR)

Introduction This article demonstrates how to install Oracle Data Integrator (ODI) on the Amazon Elastic MapReduce (EMR) cloud service.  Amazon EMR is a big data cloud service, available on the Amazon Web Services (AWS) cloud computing services. ODI is well documented to run on both the Cloudera and Hortonworks distributions of Hadoop.  ODI can also […]

Preparing Amazon Elastic MapReduce (EMR) for Oracle Data Integrator (ODI)

Introduction This article demonstrates how to prepare the Amazon Elastic MapReduce (EMR) cloud service for the Oracle Data Integrator (ODI) installation.  Amazon EMR is a big data cloud service, available on the Amazon Web Services (AWS) cloud computing services. ODI is well documented to run on both the Cloudera and Hortonworks distributions of Hadoop.  ODI […]

Using Oracle Data Integrator (ODI) with Amazon Elastic MapReduce (EMR)

Introduction This article discusses how to use Oracle Data Integrator (ODI) with the Amazon Elastic MapReduce (EMR) cloud service.  Amazon EMR is a big data cloud service and a member of the Amazon Web Services (AWS) cloud computing services, offered by Amazon.com. In the big data space, ODI is certified on both Cloudera and Hortonworks […]

Using JMS Queues with Oracle Data Integrator (ODI)

Introduction   Oracle customers use Java Message Service (JMS) queues with Oracle Data Integrator (ODI) to consume, transform, and publish millions of JMS messages every day.  A new Oracle white paper called “Using JMS Queues with Oracle Data Integrator (ODI)” illustrates, step-by-step, how to use JMS queues with ODI. This white paper uses the airline […]

Configuring Oracle Data Integrator (ODI) with Oracle Partition Exchange

Introduction   This article describes the steps required to enable Oracle Partition Exchange in Oracle Data Integrator (ODI). The article features a new ODI knowledge module (KM), the IKM Oracle Partition Exchange Load, which uses the Oracle Partition Exchange technology to upload data, by partition or subpartition, into a partitioned table of an Oracle database. […]