Deploying Oracle Remote Data Connector in Tomcat for Oracle Analytics Cloud

Introduction This post describes deploying Oracle Remote Data Connector (RDC) for Tomcat in a Compute instance running on Oracle Cloud Infrastructure (OCI) for use by Oracle Analytics Cloud (OAC). RDC is used primarily in cases where data sources are not accessible using a public IP address. It supplements the official RDC documentation found here and here with […]

OAC Remote Data Connector with Jetty

For other A-Team articles by Richard, click here Introduction The Remote Data Connector (RDC) allows the Oracle Analytics Cloud service to connect to on-premise data sources. There are now 2 versions. The initial version required that a web-sever, either weblogic or tomcat, be used on premise for the tool to work.  That version is still available, […]

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

Implementing Data Level Security in Oracle Analytics Cloud using Identity Cloud Service

Introduction This post describes implementing Data Level Security in Oracle Analytics Cloud (OAC) using Identity Cloud (IDCS) groups. It focuses on what steps are needed. Links to relevant documentation are provided for details on how to perform the steps. One case for using IDCS satisfies a corporate requirement specifying that the assigning of users to […]

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

Set up Fusion SaaS BI Cloud Connector (BICC) to use Cloud Storage

For other A-Team articles by Richard, click here Introduction This article walks through the steps to set up a Cloud Storage Container, for use with the Fusion SaaS BI Cloud Connector. This may be of particular interest to Oracle Analytics Cloud customers, wanting to use the new Data Replication functionality from Fusion SaaS (for more details, […]

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

Last Validation: April 2, 2019 for OAC Client version 105.2, OAC 105.2.0-307 and ADW 18.4.0.0 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, […]

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

A production pattern for frequent updates with PGX

Oracle’s PGX (Property Graph analytiX) is an in-memory representation of Oracle Property Graph data. Analytics against the data are parallelized and as such can be extremely fast (especially compared to typical database queries). Such powerful analytics are ideal for recommendations or real-time accept/reject financial transactions for example. A list of the built-in analytics can be […]

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