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 Autonomous Analytics to Exadata Express

Introduction This post details the steps required to upload an Exadata Express 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 Modeler (TCM) models. Data connections are used for DV data […]

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 Autonomous Analytics to the Autonomous Data Warehouse

Introduction This post details the steps required 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 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: June 21, 2018 Published on: June 21, 2018 Versions Used Autonomous Data Warehouse 18.1.5 Windows 7 […]

Extracting Data from Fusion SaaS via View Objects with Data Sync

For other A-Team articles by Richard, click here Introduction The Oracle Data Sync tool provides the ability to extract from both on-premise, and cloud data sources, and to load that data into Oracle Analytics Cloud Service (OAC), Oracle Autonomous Analytics Cloud Service (OAAC), and other oracle relational databases, or into Essbase. In the most recent 2.5 […]

Using Data Sync to Extract and Load Data from Fusion SaaS using the BI Cloud Connector (BICC) and UCM

For other A-Team articles by Richard, click here Introduction The Oracle Data Sync tool provides the ability to extract from both on-premise, and cloud data sources, and to load that data into Oracle Analytics Cloud Service (OAC), Oracle Autonomous Analytics Cloud Service (OAAC), and other oracle relational databases, or into Essbase. In the most recent release, […]

Connecting DIPC ODI Studio to the Autonomous Data Warehouse Cloud

Introduction This post details the steps required to create connections in the 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 Warehouse Cloud which uses ODI Studio on Windows. […]

Resources for learning RDF Semantic Graph (Part 1)

Continuing my series on graph databases (see: Intro to Graphs at Oracle) I thought it would be useful to provide a “cheat sheet” for bootstrapping your learning of RDF Semantic Graph technologies. I’m starting with RDF since it has been around longer, is a W3C standard, has more in-depth training available, and the lessons learned […]

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

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

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

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 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

Deprecation Recent enhancements to OAC have made this post obsolete.  The most current post is found Here. 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 […]

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

Deprecation Recent enhancements to OAC have made this post obsolete.  The most current post is found Here. 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 […]

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

Deprecation Recent enhancements to OAC have made this post obsolete.  The most current post is found Here. 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 […]

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

Deprecation Recent enhancements to OAC have made this post obsolete.  The most current post is found Here. 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 […]

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