OAC Connection to On-Premise Essbase via Remote Data Connector

For other A-Team articles by Richard, click here Introduction This article walks through the steps to set up the Remote Data Connector (RDC), for Oracle Analytics Cloud, to connect to an On-Premise Essbase source.   Two methods will be described: A direct connection from the Data Visualization tool without the need to use a repository (RPD) […]

Restricting Access to Oracle Analytics Cloud by IP Range

For other A-Team articles by Richard, click here Introduction Customers may want to restrict access to their Oracle Cloud Services to a set of IP ranges, for instance to only allow connections coming from their corporate office.  That type of restriction is not possible within Oracle Analytics Cloud itself, but it possible to set up using […]

Connecting Oracle Analytics Cloud Essbase to the Autonomous Data Warehouse

Introduction The latest releases of Oracle Analytics Cloud (OAC)-Essbase now support connections to the Autonomous Data Warehouse (ADW). This post is a step-by-step guide to creating the connections. Links to documentation are provided for all steps where possible. Screen shots are provided for the ADW Connection steps. It is the latest addition to the A-Team Chronicles ADW […]

Using Catalog Manager with Oracle Analytics Cloud

Introduction The latest releases of Oracle Analytics Cloud (OAC) now support the use of Catalog Manager. Catalog Manager is a tool that lets you perform online and offline management of OAC Catalogs. This post describes how to use Catalog Manager with Oracle Analytics Cloud. It is a step-by-step guide if you wish to perform the steps […]

Creating a Dashboard Landing Navigation Page in Oracle Analytics Cloud (OAC) & Oracle Business Intelligence (OBI/OBIEE)

Background                                                                         Dashboard Landing Navigation Pages (also known as start page, landing page, default page, default dashboard, home page) can be […]

Completing the Migration from Business Intelligence Cloud Service to Oracle Analytics Cloud

Introduction This post is the second in a two-part series and details the tasks required to complete a migration from Business Intelligence Cloud Service (BICS) to Oracle Analytics Cloud (OAC) running on Oracle Cloud Infrastructure (OCI). For details on preparing for the migration to OAC see Preparing to Migrate from Business Intelligence Cloud Service to Oracle Analytics […]

Preparing to Migrate from Business Intelligence Cloud Service to Oracle Analytics Cloud

Introduction This post is the first in a two-part series and details the tasks required to prepare for a migration from Business Intelligence Cloud Service (BICS) to Oracle-Managed Oracle Analytics Cloud (OAC) running on Oracle Cloud Infrastructure (OCI). For details on completing the migration to OAC see Completing the Migration from Business Intelligence Cloud Service to […]

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

Creating a VPN Connection for Oracle Analytics Cloud on Oracle Cloud Infrastructure – Classic

Introduction This post details the steps required to create a Virtual Private Network (VPN) connection for Oracle Analytics Cloud (OAC) Data Visualization (DV) using Oracle’s VPN as a Service (VPNaaS). VPNaaS is deployed on Oracle Cloud Infrastructure – Classic (OCI-C). VPN is not available on Oracle Cloud Infrastructure (OCI) for Autonomous OAC yet. The specific use […]

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

Machine Learning with Oracle Database Advanced Analytics

TL;DR: Oracle DB + Oracle Data Mining + Oracle R Enterprise = Database Advanced Analytics (OAA) The Database Advanced Analytics option allows running Machine Learning algorithms within the database itself. The on-prem flavor of OAA is available as part of database Enterprise Edition 12c and upward releases. In OPC, OAA is available as part of […]

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

BI Cloud Connector – Deletion of Data Extract Files on UCM

Introduction This blog post is the continuation of the formerly shared article about BI Cloud Connector (BICC) Data Extraction File Downloading. In the previous blog post I gave an introduction into BICC and we discussed the options how to download the data extraction files from Storage Cloud or the internal built-in Universal Content Management (UCM) […]

Intro to Graphs at Oracle

Oracle has had a long history with graph technologies, with support of RDF Triplestores going back more than ten years. During that period property graphs were introduced to big data solutions and more recently to Oracle RDBMS as well. All graph technology at Oracle are available via the Spatial & Graph product line, which extends […]

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

Creating a Connection in Oracle Analytics Cloud 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 create a connection to the Autonomous Data Warehouse Cloud (ADWC) for Data Visualization projects. For additional details on ADWC, visit the Autonomous […]

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

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

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