Connecting ODICS and DIPC Studios to the Autonomous Data Warehouse Cloud

Introduction This post details the steps required to create connections in Oracle Data Integrator Cloud Service (ODICS) and 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 […]

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 Cloud

Introduction This post details the steps required to create connections in Oracle Data Integrator (ODI) to the Autonomous Data Warehouse Cloud (ADWC) (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

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

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

Preparing to Connect to the Autonomous Data Warehouse Cloud

Introduction This post details generic common steps required before connections can be made to ADWC. For additional details on ADWC, visit the Autonomous Data Warehouse Cloud page. Topics Obtaining the ADWC Credentials Downloading Service Credentials from ADWC Downloading Java JDK Overview of Oracle JDBC Drivers Using the Oracle Call Interface Obtaining the ADWC Credentials Obtain the cloud services username […]

Preparing to Connect to the Exadata Express Cloud Service

Introduction This post details common steps required before connections can be made to Exadata Express. For additional details on Exadata Express, visit the Exadata Express Cloud Service page. For additional details on OAC, visit the Analytics Cloud page. Topics Obtaining the Exadata Express Credentials Enabling Client Access Downloading Service Credentials from Exadata Express Downloading Java JDK Overview of Oracle JDBC Drivers Using […]

Data Sync and the Autonomous Data Warehouse Cloud (ADWC) and Exadata Express Cloud Service

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

UTL_Match and Soundex for ‘Fuzzy’ Matching of Data in an Oracle Database

For other A-Team articles by Richard, click here Introduction In today’s data-centric world, the BI professional is often faced with the problem of joining data sets from different sources. In a normalized relational database, you can typically just join column A to column B, and be on your way. Unfortunately that’s always not the case.  Take the […]

Using Date Based Partitioning for OTBI Extracts with Data Sync to Improve Performance

For other A-Team articles about BICS, OAC, and Data Sync, click here Introduction The Data Sync tool provides the ability to extract from both on-premise, and cloud data sources, and to load that data into BI Cloud Service (BICS), Oracle Analytics Cloud Service (OAC), and other relational databases. I have previously written about the tool’s ability […]