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, and Apache Pig, among others.  ODI supports both distributions of Hadoop:  […]

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, and Apache Pig, among others.  ODI supports both distributions of Hadoop:  Hortonworks Data […]

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, and Apache Pig, among others.  ODI supports both distributions […]

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

Loading Data from Oracle Field Service Cloud into Oracle Analytics Cloud using ODI and REST – Part III

Introduction In December, 2016 Oracle announced Oracle Data Integrator (ODI) release 12.2.1.2.6 which contains significant new features including RESTful services. This three-part series details a method of extracting and loading data from Oracle Field Service Cloud (OFSC) into Oracle Analytics Cloud (OAC). It is a companion to the A-Team post Loading Data from Oracle Field Service Cloud […]

Loading Data from Oracle Field Service Cloud into Oracle Analytics Cloud using ODI and REST – Part II

  Introduction In December, 2016 Oracle announced Oracle Data Integrator (ODI) release 12.2.1.2.6 which contains significant new features including RESTful services. This three-part series details a method of extracting and loading data from Oracle Field Service Cloud (OFSC) into Oracle Analytics Cloud (OAC). It is a companion to the A-Team post Loading Data from Oracle Field Service […]

Loading Data from Oracle Field Service Cloud into Oracle Analytics Cloud using ODI and REST – Part I

Introduction In December, 2016 Oracle announced Oracle Data Integrator (ODI) release 12.2.1.2.6 which contains significant new features including support for RESTful services. This three-part series details a method of extracting and loading data from Oracle Field Service Cloud (OFSC) into Oracle Analytics Cloud (OAC). It is a companion to the A-Team post Loading Data from Oracle Field […]

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

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

Using Oracle Data Integrator (ODI) to Load BI Cloud Service (BICS)

For other A-Team articles about BICS, click here Introduction Oracle Data Integrator (ODI) is a comprehensive data integration platform that covers most data integration scenarios.  It has long been possible to use ODI to load data into BI Cloud Service (BICS) environments, that use Database as a Service (DBaaS) as the underlying database. The recent 12.2.1.2.6 release […]

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

Best Practices – Data movement between Oracle Storage Cloud Service and HDFS

Introduction Oracle Storage Cloud Service should be the central place for persisting raw data produced from another PaaS services and also the entry point for data that is uploaded from the customer’s data center. Big Data Cloud Service ( BDCS ) supports data transfers between Oracle Storage Cloud Service and HDFS. Both Hadoop and Oracle […]

ODI on Compute Cloud Service: Step by Step Installation

Introduction We have seen in Connect ODI to Oracle Database Cloud Service (DBCS) how to connect ODI on premise to DBCS. But it is also possible to deploy ODI in the Cloud – either on the PAAS (on JCS) or the IAAS (on Compute Cloud Service). In cases where a JEE ODI Agent is not needed, […]

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