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

Connecting DIPC ODI Studio to the Autonomous Data Warehouse

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

Connecting Oracle Data Sync to the Autonomous Data Warehouse Cloud using OCI

Introduction This post details the steps required to create connections in Oracle Data Sync to the Autonomous Data Warehouse Cloud (ADWC) using the JDBC Oracle Call Interface (OCI) driver. It is a companion and alternative to the A-Team post Data Sync and the Autonomous Data Warehouse Cloud (ADWC) which uses the JDBC Thin driver. For additional details about […]

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

Preparing to Connect to the Autonomous Data Warehouse

Introduction This post details generic common steps required before connections can be made to ADW. For additional details on ADW, visit the Autonomous Data Warehouse page. Updates Updated December 17, 2018. The method to download the client credentials changed slightly. Topics Obtaining the ADW Credentials Downloading Service Credentials from ADW Downloading Java JDK Overview of Oracle JDBC Drivers Using […]

Loading Data from Generic JDBC Sources into BICS

For other A-Team articles about BICS and Data Sync, click here Introduction Version 2.2 of the Data Sync tool was released September 2016 and added the ability to connect to a number of different data sources via JDBC. Setting up these Data Sources in Data Sync varies by the source.  Rather than create a single article […]

Loading Oracle Service Cloud (RightNow) Data into BICS with Data Sync

For other A-Team articles about BICS and Data Sync, click here Introduction Version 2.2 of the Data Sync tool was released September 2016 and added the ability to connect to a number of different data sources via JDBC. Setting up these Data Sources in Data Sync varies by the source.  Rather than create a single article to […]

Connect ODI to Oracle Database Cloud Service (DBCS)

As describe in the article Integrating Oracle Data Integrator (ODI) On-Premise with Cloud Services, if you are considering connecting to the Cloud and using Oracle DBCS – Oracle Database Cloud Service – one of the good news is that you can use ODI on-premise to do the work. There are 2 ways to connect: either […]

Understanding Where to Install the ODI Standalone Agent

Introduction   With no middle tier required in the ODI architecture, the most common question from people who are new to ODI is where to install the standalone agent: source, target or middle tier systems? We look here at different possible architectures and provide the best choices accordingly.  Understanding Where to Install the ODI Standalone […]

Using an External Database for your XML Schema, Part II: Optimizing the Use of the External Schema

Introduction Whether you are processing XML files or XML messages on JMS, ODI provides a JDBC driver that will translate the XML structure into a relational schema. By default, this schema is created in an in-memory database. While this approach will work extremely well for small XML files or messages, it can become challenging for […]

Using an External Database for your XML Schema, Part I: Understanding the ODI XML JDBC Driver

Introduction Whether you are processing XML files or XML messages on JMS, ODI provides a JDBC driver that will translate the XML structure into a relational schema. By default, this schema is created in an in-memory database. While this approach will work extremely well for small XML files or messages, it can become challenging for […]

Automating creation of JDBC Data Sources and DbAdapter plan updates and redeployment

That’s a long title… anyway, as part of the desire to have a fully automated continuous integration environment for SOA and BPM, there is another bridge that we need to cross. SOA/BPM Composites can contain dependencies on resources in the … Continue reading