Connecting ODICS and DIPC Studios to the Exadata Express Cloud

Introduction This post details the steps required to create connections in Oracle Data Integrator Cloud Service (ODICS) and Data Integration Platform Cloud (DIPC) to the Exadata Express Cloud. 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 Exadata Express Cloud which uses ODI Studio on Windows. For […]

Connecting ODICS and DIPC Studios to the Autonomous Data Warehouse Cloud

Introduction This post details the steps required to create connections in Oracle Data Integrator Cloud Service (ODICS) and Data Integration Platform Cloud (DIPC) to the Autonomous Data Warehouse Cloud (ADWC). 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 […]

Connecting Oracle Data Sync to the Exadata Express Cloud using OCI

Introduction This post details the steps required to create connections in Oracle Data Sync to the Exadata Express Cloud 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) and Exadata Express Cloud Service which uses the JDBC Thin driver. For […]

Extracting Data from Oracle Analytics Cloud using REST

Introduction This post provides a simple method of extracting data from Oracle Analytics Cloud (OAC) using Business Intelligence Publisher (BIP) REST web services. Refer to REST API for Oracle BI Publisher for details. It builds upon and uses the analysis from the post ‎Extracting Data from Oracle Analytics Cloud using SOAP A key differentiator in OAC and OBIEE […]

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 Exadata Express Cloud

Introduction This post details the steps required to create connections in Oracle Data Integrator (ODI) to the Exadata Express Cloud (referred to as Cloud Service in the remainder of the post). It is a companion post to Connecting ODICS and DIPC Studios to the Exadata Express Cloud which uses ODI Cloud Services. For additional details about Exadata […]

Connecting Oracle Data Integrator Studio to the Autonomous Data Warehouse Cloud

Introduction This post details the steps required to create connections in Oracle Data Integrator (ODI) to the Autonomous Data Warehouse Cloud (ADWC) (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 to the Autonomous Data Warehouse Cloud

Introduction This post details the steps required to create a connection in DVD to ADWC. It is a companion to these other ADWC posts: Preparing to Connect to the Autonomous Data Warehouse Cloud Creating an Oracle Analytics Cloud RPD Connection to the Autonomous Data Warehouse Cloud Connecting an Oracle Analytics Cloud RPD to the Autonomous Data Warehouse Cloud […]

Creating a Connection in Data Visualization Desktop to the Exadata Express Cloud Service

Introduction This post details the steps required to create a connection in DVD to the Exadata Express Cloud Service. For additional details on Exadata Express, visit the Exadata Express Cloud Service page. For additional details on Data Visualization Desktop (DVD), visit the Oracle Data Visualization Desktop page. Topics Preparing Windows Preparing Data Visualization Desktop Preparing the Data Warehouse Cloud Service (DWCS) Wallet […]

Connecting an Oracle Analytics Cloud RPD to the Exadata Express Cloud Service

Introduction This post details the steps required to prepare an OAC instance for an RPD with an Exadata Express Cloud Service data source connection. It uses the RPD created with the steps in Creating an Oracle Analytics Cloud RPD Connection to the Exadata Express Cloud Service. For additional details on Exadata Express, visit the Exadata Express Cloud Service page. For […]

Creating a Connection in Oracle Analytics Cloud to the Exadata Express Cloud Service

Introduction This post details the steps required to create a connection to the Exadata Express Cloud Service for Data Visualization projects. For additional details on Exadata Express, visit the Exadata Express Cloud Service page. For additional details on OAC, visit the Analytics Cloud page. Topics Before you Begin Preparing Windows to Upload Files Preparing OAC for an Exadata Express Connection Preparing the […]

Creating a Connection in Oracle Analytics Cloud to the Autonomous Data Warehouse Cloud

Introduction This post details the steps required to create a connection to the Autonomous Data Warehouse Cloud (ADWC) for Data Visualization projects. For additional details on ADWC, visit the Autonomous Data Warehouse Cloud page. For additional details on OAC, visit the Analytics Cloud page. Topics Before you Begin Preparing Windows to Upload Files Preparing OAC for an ADWC Connection Preparing the DWCS Wallet […]

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

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 RPD created with the steps in Creating an Oracle Analytics Cloud RPD Connection to the Autonomous Data Warehouse Cloud. For additional details about ADWC, visit the Autonomous Data Warehouse Cloud page. For additional […]

Creating an Oracle Analytics Cloud RPD Connection to the Exadata Express Cloud Service

Introduction This post details the steps required to create an Exadata Express data source connection using the OAC Developer Client Tool on Windows. It also prepares a complete RPD ready for uploading to OAC. For additional details on Exadata Express, visit the Exadata Express Cloud Service page. For additional details on OAC, visit the Analytics Cloud page. Topics Preparing Windows for an […]

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

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

Preparing to Connect to the Autonomous Data Warehouse Cloud

Introduction This post details generic common steps required before connections can be made to ADWC. For additional details on ADWC, visit the Autonomous Data Warehouse Cloud page. Topics Obtaining the ADWC Credentials Downloading Service Credentials from ADWC Downloading Java JDK Overview of Oracle JDBC Drivers Using the Oracle Call Interface Obtaining the ADWC Credentials Obtain the cloud services username […]

Preparing to Connect to the Exadata Express Cloud Service

Introduction This post details common steps required before connections can be made to Exadata Express. For additional details on Exadata Express, visit the Exadata Express Cloud Service page. For additional details on OAC, visit the Analytics Cloud page. Topics Obtaining the Exadata Express Credentials Enabling Client Access Downloading Service Credentials from Exadata Express Downloading Java JDK Overview of Oracle JDBC Drivers Using […]

Extracting Data from Oracle Analytics Cloud using SOAP

Introduction This post provides a simple method of extracting data from Oracle Analytics Cloud (OAC) using web services. It uses Oracle Business Intelligence Web Services as documented in Fusion Middleware Integrator’s Guide for Oracle Business Intelligence Enterprise Edition The simple method (using HTTP) is not secure and should only be used in a development environment. […]

Securing Subject Areas in Oracle Analytics Cloud

Introduction This post documents how to secure Oracle Business Intelligence Repository Metadata (RPD) subject areas in Oracle Analytics Cloud (OAC). It uses an example of two subject areas; Financials and Projects. The Projects subject area is secured via application roles and presentation services privileges. Only users with the correct role(s) can view the subject area […]

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