Oracle Data Integration Platform Cloud (DIPC): Configure VPN as a Service (VPNaaS) for On-Premises Connectivity

Introduction This document will walk you through how to configure Virtual Private Network as a Service (VPNaaS) with Oracle Data Integration Platform Cloud (DIPC) for connectivity between On-Premises Oracle database and Oracle Public Cloud (OPC). One major requirement for DIPC to be configured with VPNaaS is; DIPC must be provisioned to use IP Network instead of […]

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

Using Content & Experience Cloud content in a React app.

In this blog I will introduce an integration pattern to download content from Content & Experience Cloud and use that ‘off-line’. By off-line I mean that the content is downloaded before the application is built and is used statically as part of the application instead of dynamically calling the Content & Experience Cloud REST API. This blog […]

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

Functions-as-a-Service – What SOA Should Have Been

Introduction It wasn’t that many years ago that service-oriented architecture (SOA) was the hot, new, bleeding edge enterprise computing paradigm. Most organizations and vendors jumped on that bandwagon and everything became “service-oriented”. Organizations and vendors both made great claims about how SOA would revolutionize the way applications were built, the amount of reuse that would […]

Applying P4FA using FASPOT on Fusion Release 12

Introduction Patches for Fusion Applications (P4FA) are collections of one-off fixes and tech stack updates (e.g. Fusion MiddleWare, Database, Weblogic Server, etc.) compiled and certified for Fusion Applications where an installation of them improves system stability and performance substantially. Every Fusion Application release has its own set of P4FA patches and it is mandatory to apply […]

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. For additional details about Exadata Express, refer to Exadata Express Cloud Service. For additional details about ODI, refer to Oracle Data Integrator Overview. ODI Studio is assumed to be installed and configured. For information on installing ODI visit Installing and […]

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). 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 to be installed and configured. For information on installing ODI on Windows […]

Setup Oracle API Gateway on OCI-Classic in Oracle Public Cloud

This blog provides steps to get Oracle API Gateway up and running on Oracle cloud- OCI Classic VM We will see following steps: 1. Create compute instance on Oracle Cloud Infrastructure Classic (OCI-classic) 2. Create Logical gateway in API management console and Assign grants to add nodes 3. Connect OCI-classic instance using SSH and copy […]

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

Oracle File System – Storing files in the DBCS via NFS

Introduction Oracle Database Cloud Service can easily be configured to expose Oracle File Systems via Network File System (NFS). This is available starting with Oracle Database 12c Release 2. This feature allows a client to mount the NFS share without having to configure the Oracle Database File System DBFS Client – therefore simplifying the rollout […]