Jay Pearson
Consulting Solutions Architect, Business Intelligence
Recent Blogs
Configuring Oracle Analytics Cloud (OAC) with Data Gateway to connect ...
Background This article outlines the steps to configure Oracle Analytics Cloud (OAC) with Data Gateway to connect to Teradata. At the time of writing, the supported data source for Teradata as outline here is Remote Data Connectivity. Remote Data Connectivity includes both Data Gateway and Remote Da...
Connecting to multiple Oracle Autonomous Databases (in the same ...
Background * This blog was last tested on OAC 5.9 + ADW 19c + ATP 19c * This article walks through the steps to configure an Oracle Analytics Cloud (OAC) BI Repository (RPD) file to connect to both an Autonomous Data Warehouse (ADW) and an Oracle Autonomous Transaction Processing (ATP) database in t...
Using BICS Data Sync to extract data from Oracle OTBI either cloud or ...
The A-Team Chronicles blog post you were trying to access has expired. The reason for the expiration is that the content is no longer relevant or the Oracle on-line documentation has been updated to reflect the content of the blog. Regards, A-Team Chronicles Administration...
Invoking Oracle REST Data Services (ORDS) in Oracle Analytic Cloud ...
* This blog was last tested on OAC Version 5.9 + ADW 18c * Background This article walks through the steps to invoke Oracle REST Data Services (ORDS) in Oracle Analytics Cloud (OAC) Data Visualization (DV). Possible Use Cases: * Write-back * Running DML statements (insert, update or delete etc.) * P...
Querying OAC and FAW Data Models Remotely Using JDBC
Background * This blog was last tested on OAC 105.8.0-133 (Version 5.8) + ADW 18c + Oracle Analytics Client Tools 5.8.0 [aka Oracle BI Administration Tool Version 12.2.5.8.0] + SQuirreL SQL Client Version 4.1.0 + Windows 10 Pro 64-bit OS * This article walks through the steps to query an Oracle Anal...