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...
Introduction There have been a lot of escalations to A-Team where Oracle GoldenGate outages could have been avoided if System and Database Administrators had...
Introduction There have been a lot of escalations to A-Team where Oracle GoldenGate outages could have been avoided if System and Database Administrators had been properly monitoring their environments. In this article we're going to discuss various areas that should be monitored regularly to avoid degradations in performance and unscheduled outages. The concepts, scripts, and information presented in this article are for educational purposes only. They are not supported by...
Introduction There have been a lot of escalations to A-Team where Oracle GoldenGate outages could have been avoided if System and Database Administrators had been properly monitoring...
For other A-Team articles by Richard, click here Introduction This article walks through the steps to set up a Cloud Storage Container, for use with the Fusion...
For other A-Team articles by Richard, click here Introduction This article walks through the steps to set up a Cloud Storage Container, for use with the Fusion SaaS BI Cloud Connector. This may be of particular interest to Oracle Analytics Cloud customers, wanting to use the new Data Replication functionality from Fusion SaaS (for more details, see this article). The process requires the use of Cloud Storage Classic Service. Existing OAC customers should have Storage Classic...
For other A-Team articles by Richard, click here Introduction This article walks through the steps to set up a Cloud Storage Container, for use with the Fusion SaaS BI Cloud Connector. This may be of...
Last Validation: August 1, 2019 for OAC Version 105.3 Introduction This post details the steps required in OAC versions 5.1+ to upload Autonomous Data Warehouse...
Last Validation: August 1, 2019 for OAC Version 105.3 Introduction This post details the steps required in OAC versions 5.1+ to upload Autonomous Data Warehouse (ADW) wallets and to create ADW data, replication and console connections. The wallets are used for Data Visualization (DV) data sets, DV Replications, Metadata (RPD) connection pools, and Thin Client Modeler (TCM) models. Data connections are used for DV data sets. Replication connections are used for DV...
Last Validation: August 1, 2019 for OAC Version 105.3 Introduction This post details the steps required in OAC versions 5.1+ to upload Autonomous Data Warehouse (ADW) wallets and to create ADW data,...
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...
For other A-Team articles by Richard, click here Introduction For good reason, the database of Fusion SaaS products is not available for ETL tools to work...
For other A-Team articles by Richard, click here Introduction For good reason, the database of Fusion SaaS products is not available for ETL tools to work directly against. The recommended approach to extract data for most use cases, is through the BI Cloud Connector tool. This pulls data from 'View Objects' in the Business Intelligence layer of Fusion SaaS. Other tools, the Analytics Cloud Data Replicator, and Analytics Cloud Data Sync tool, can also extract from these...
For other A-Team articles by Richard, click here Introduction For good reason, the database of Fusion SaaS products is not available for ETL tools to work directly against. The recommended approach to...
Introduction The Oracle GoldenGate (OGG) Passive-Alias Extract may be used for data replication between source databases located on servers in untrusted...
Introduction The Oracle GoldenGate (OGG) Passive-Alias Extract may be used for data replication between source databases located on servers in untrusted security zones and target database servers in trusted security zones. In this article we'll configure Alias Extracts on a trusted zone OGG instance that will interact with Passive Extracts on untrusted zone OGG instances for data capture and delivery to the trusted zone database server. The concepts, scripts, and information...
Introduction The Oracle GoldenGate (OGG) Passive-Alias Extract may be used for data replication between source databases located on servers in untrusted security zones and target database servers...
Last Validated July 15, 2019 Introduction This post details the steps required to download an Autonomous Data Warehouse (ADW) Client Credentials Zip File. This...
Last Validated July 15, 2019 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 Past Validations: February 26, 2019 for ADW 18c Published on: June 21, 2018 Versions Used Autonomous Data Warehouse DB Version 18.0.3.3, 18.4.0.0 Windows 7 SP 1 Downloading the ADW...
Last Validated July 15, 2019 Introduction This post details the steps required to download an Autonomous Data Warehouse (ADW) Client Credentials Zip File. This file is required by all...
