Using Oracle Cloud Infrastructure Database services with Transparent Data Encryption (TDE) provides a high level of security and protection for customer data....
Using Oracle Cloud Infrastructure Database services with Transparent Data Encryption (TDE) provides a high level of security and protection for customer data. The common issue related to TDE observed by many customers is simply related to the TDE password. Users creating new services change the sys password and are not aware what the TDE password is and they are therefore not able to create new master keys or rekey current environments. What can they do then? All...
Using Oracle Cloud Infrastructure Database services with Transparent Data Encryption (TDE) provides a high level of security and protection for customer data. The common issue related to TDE observed...
As part of Oracle Spatial and Graph in Oracle Database, Oracle delivers advanced RDF Semantic Graph data management and analysis. With native support for World...
As part of Oracle Spatial and Graph in Oracle Database, Oracle delivers advanced RDF Semantic Graph data management and analysis. With native support for World Wide Web Consortium (W3C) standards; RDF, OWL and SPARQL. Application developers benefit from the industry’s leading open, scalable graph data platform on Oracle Database with triple-level security, and high performance and availability. For this example we will look at enabling a Bare Metal based Oracle Enterprise...
As part of Oracle Spatial and Graph in Oracle Database, Oracle delivers advanced RDF Semantic Graph data management and analysis. With native support for World Wide Web Consortium (W3C)...
Introduction This post describes deploying Oracle Remote Data Connector (RDC) for Tomcat in a Compute instance running on Oracle Cloud Infrastructure (OCI) for...
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 screen images and links to additional references. A step-by-step example is provided for those desiring to perform...
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...
Introduction The latest releases of Oracle Analytics Cloud (OAC)-Essbase now support connections to the Autonomous Data Warehouse (ADW). This post is a...
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 library A-Team ADW Posts Updates Validated February 8, 2019 for OAC-Essbase version 105.1.1-9 and ADW...
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....
Introduction This post details the steps required to import into the Autonomous Data Warehouse (ADW) using the Oracle Data Pump Import utility on Oracle Cloud...
Introduction This post details the steps required to import into the Autonomous Data Warehouse (ADW) using the Oracle Data Pump Import utility on Oracle Cloud Infrastructure (OCI). Versions OCI Compute Oracle-Linux-7.6-2018.11.19-0 Instant Client 18.3.0.0.0 for Linux x86-64 (64-bit) ADW DB 18.0.3.3 SQL Developer 18.3.0.277 Assumptions An Oracle Cloud Account and an OCI Tenancy Access to an ADW instance Administrator Credentials to both of the above An export...
Introduction This post details the steps required to import into the Autonomous Data Warehouse (ADW) using the Oracle Data Pump Import utility on Oracle Cloud Infrastructure (OCI). Versions...
Introduction This post details the steps required to create connections in Oracle Data Integrator Cloud Service (ODICS) on Oracle Cloud Infrastructure (OCI) to...
Introduction This post details the steps required to create connections in Oracle Data Integrator Cloud Service (ODICS) on Oracle Cloud Infrastructure (OCI) to the Autonomous Data Warehouse (ADW). It demonstrates both the Thin and Oracle Call Interface (oci) versions of the Oracle JDBC driver. It is a companion post to Connecting Oracle Data Integrator Studio to the Autonomous Data Warehouse which uses ODI Studio on Windows and Connecting DIPC ODI Studio to the Autonomous...
Introduction This post details the steps required to create connections in Oracle Data Integrator Cloud Service (ODICS) on Oracle Cloud Infrastructure (OCI) to the Autonomous Data Warehouse (ADW). It...
For other A-Team articles by Richard, click here Introduction In the recent Oracle Analytics Cloud release, exciting new SaaS data replication functionality was...
For other A-Team articles by Richard, click here Introduction In the recent Oracle Analytics Cloud release, exciting new SaaS data replication functionality was added. This allows Oracle Analytics Cloud (OAC and OAAC), to replicate data, on a schedule, from a number of Oracle's SaaS offerings. For many use cases, this will mean that a separate extract and load processes, is no longer required. In this initial release, the sources that can be replicated are: - Oracle Fusion...
For other A-Team articles by Richard, click here Introduction In the recent Oracle Analytics Cloud release, exciting new SaaS data replication functionality was added. This allows Oracle Analytics...
TL;DR: Oracle DB + Oracle Data Mining + Oracle R Enterprise = Database Advanced Analytics (OAA) The Database Advanced Analytics option allows running Machine...
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 DBCS High Performance Edition in OCI Classic, a High Performance Edition of DB System in OCI, and as part of Autonomous Data Warehouse...
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...
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...
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 found at: https://docs.oracle.com/cd/E56133_01/latest/reference/algorithms/index.html. This...
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...
