Connecting Oracle Data Integrator Cloud Service to the Autonomous Data Warehouse

Introduction This post details the steps required to create connections in Oracle Data Integrator Cloud Service (ODICS) on Oracle Cloud Infrastructure (OCI) to the Autonomous Data Warehouse (ADW). It demonstrates both the Thin and Oracle Call Interface (oci) versions of the Oracle JDBC driver. It is a companion post to Connecting Oracle Data Integrator Studio to the Autonomous Data Warehouse which uses ODI […]

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 […]

Connecting Oracle Data Integrator Studio to the Autonomous Data Warehouse

Introduction This post details the steps required to create connections in Oracle Data Integrator (ODI) on Windows to the Autonomous Data Warehouse (ADW). It is a companion to Connecting DIPC ODI Studio to the Autonomous Data Warehouse which uses ODI Studio in the Data Integration Platform Cloud (DIPC) and Connecting Oracle Data Integrator Cloud Service to the […]

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 […]

Oracle Data Integrator Cloud Service (ODICS) : Where to Run Studio

Oracle Data Integrator (ODI) is now available as a Cloud Service: Oracle Data Integrator Cloud Service (ODICS). For customers who are interested in a subscription model for their ODI installation and want to integrate and transform data in the Cloud, this is the solution. Start by deploying ODICS following the Oracle By Example document Provisioning […]

Deploying ODICS Studio on a Windows Image (Compute Cloud Service)

Based on our experience, in the on-premise world, most ODI Developers are using ODI Studio on Windows. So, we thought detailing how to deploy ODICS on a Windows Image on Compute might be useful. This can be used to connect to an ODICS Repository that has already been installed. PLEASE NOTE THAT THIS IS ONLY […]

Lift and Shift to Oracle Data Integrator Cloud Service (ODICS) : Moving your Repository to the Cloud

  Oracle Data Integrator (ODI) is now available as a Cloud Service: Oracle Data Integrator Cloud Service (ODICS). For customers who are interested in a subscription model for their ODI installation and want to integrate and transform data in the Cloud, this is the solution. Customers who already have ODI developments on premises will want […]