Connecting Data Visualization Desktop Version 5 to the Autonomous Data Warehouse

Introduction This post details the steps required in Data Visualization Desktop (DVD) version 5 (12.2.5+) to upload Autonomous Data Warehouse (ADW) wallets and to create ADW data connections. For DVD Version 4 ADW Connections refer to Creating a Connection in Data Visualization Desktop Version 4 to the Autonomous Data Warehouse Cloud For additional details on ADW, visit the […]

Connecting Oracle Analytics Cloud Version 5 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 […]

Connecting Oracle Analytics Cloud Version 4 to the Autonomous Data Warehouse

Introduction This post details the steps required in OAC version 4 (versions 18.2.x and less) to upload an Autonomous Data Warehouse (ADW) wallet and create data and console connections in Oracle Autonomous Analytics (OAAC) or Oracle Analytics Cloud (OAC). The wallet is used for Data Visualization (DV) data sets, Metadata (RPD) connection pools, and Thin Client […]

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

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) to the Autonomous Data Warehouse Cloud (ADW) (referred to as Cloud Service in the remainder of the post). For additional details about ADWC, refer to Autonomous Data Warehouse Cloud. For additional details about ODI, refer to Oracle Data Integrator Overview. ODI Studio is assumed […]

Creating a Connection in Data Visualization Desktop Version 4 to the Autonomous Data Warehouse Cloud

Introduction This post details the steps required to create a connection in DVD Version 4 (versions 12.2.4 and earlier) to the Autonomous Data Warehouse (ADW). If using DVD Version 5 (12.2.5+) refer to Connecting Data Visualization Desktop Version 5 to the Autonomous Data Warehouse For additional details on ADW, visit the Autonomous Data Warehouse Cloud page. For additional details on […]

Connecting an Oracle Analytics Cloud RPD to the Autonomous Data Warehouse Cloud

Deprecation Recent enhancements to OAC have made this post obsolete.  The latest OAC4 post is Here. The OAC5 post is Connecting Oracle Analytics Cloud Version 5 to the Autonomous Data Warehouse Introduction This post details the steps required to prepare an OAC instance for an RPD with an Autonomous Data Warehouse Cloud (ADWC) data source connection. It uses the […]

Creating an Oracle Analytics Cloud RPD Connection to the Autonomous Data Warehouse

Introduction This post details the steps required to create an Autonomous Data Warehouse (ADW) data source connection using the Oracle Analytics Cloud (OAC) Developer Client Tool on Windows. It also prepares a complete RPD ready for uploading to both Autonomous and Classic OAC. For additional details about ADW, visit the Autonomous Data Warehouse page. For additional details on OAC, […]

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

Loading Data from Oracle Field Service Cloud into Oracle BI Cloud Service using REST

Introduction This post details a method of extracting and loading data from Oracle Field Service Cloud (OFSC) into the Oracle Business Intelligence Cloud Service (BICS) using RESTful services. It is a companion to the A-Team post Loading Data from Oracle Field Service Cloud into Oracle BI Cloud Service using SOAP . Both this post and […]

Loading Data from Oracle Identity Cloud Service into Oracle BI Cloud Service using REST

Introduction This post details a method of extracting and loading data from Oracle Identity Cloud Service (IDCS) into the Oracle Business Intelligence Cloud Service (BICS). It builds upon the A-team post IDCS Audit Event REST API which details the REST API calls used. One use case for this method is for analyzing trends regarding audit events. […]

Loading Data from Oracle Field Service Cloud into Oracle BI Cloud Service using SOAP

Introduction This post details a method of extracting and loading data from Oracle Field Service Cloud (OFSC) into the Oracle Business Intelligence Cloud Service (BICS). A compelling reason to use such a method is when data is required that is not in the standard daily extract. Such data might be planning (future) data or data […]