Importing into the Autonomous Data Warehouse using Oracle Data Pump

Introduction This post details the steps required to import into the Autonomous Data Warehouse (ADW) using the Oracle Data Pump Import utility on Oracle Classic Infrastructure (OCI). Versions OCI Compute    Oracle-Linux-7.6-2018.11.19-0 Instant Client     18.3.0.0.0 for Linux x86-64 (64-bit) ADW DB            18.0.3.3 SQL Developer 18.3.0.277 Assumptions An Oracle Cloud […]

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 Oracle Analytics Cloud Version 5.x to the Autonomous Data Warehouse

Introduction This post details the steps required in OAC version 5 (18.3+) to upload Autonomous Data Warehouse (ADW) wallets and to create ADW data, replication and console connections. The wallets are used for Data Visualization (DV) data sets, DV Replications, Metadata (RPD) connection pools, and Thin Client Modeler (TCM) models. Data connections are used for […]

Downloading Autonomous Data Warehouse Credentials

Introduction This post details the steps required to download an Autonomous Data Warehouse (ADW) Client Credentials Zip File. This file is required by all clients connecting to ADW. For additional details on ADW, visit the Autonomous Data Warehouse page. Updates Latest Validation: December 17, 2018 Published on: June 21, 2018 Versions Used Autonomous Data Warehouse DB Version 18.0.3.3 Windows […]

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

Adding Web Service Trusted Certificates to a Wallet in Oracle Database Cloud Service

Introduction This post documents how to add trusted TLS/SSL certificates to an Oracle Database as a Service (DBaaS) wallet. It uses an example of an Oracle Business Intelligence Cloud Service (BICS) REST API call to Delete Cached Data as documented in REST APIs for Oracle BI Cloud Service. This call is issued from PL/SQL and […]

Oracle Service Cloud Bulk Data Import – Best Practices

This blog is part of the series of blogs the A-Team has been running on Oracle Service Cloud (OSvC). In the previous blog I went through an introduction to the Bulk APIs in OSvC and briefly touched upon throughput considerations(If you haven’t, please read that first). In this blog I build on the previous post […]