* This blog was written for Classic Cloud Storage and has not been re-tested on the latest software due to being superseded by OCI Object Storage. For...
* This blog was written for Classic Cloud Storage and has not been re-tested on the latest software due to being superseded by OCI Object Storage. For instructions on "Setting up Oracle Fusion SaaS Business Intelligence Cloud Connector (BICC) to use Oracle Cloud Infrastructure (OCI) Object Storage" see this article. - Jay Pearson (A-Team) * For other A-Team articles by Richard, click here Introduction Set up Oracle Fusion SaaS Business Intelligence Cloud Connector (BICC) to...
* This blog was written for Classic Cloud Storage and has not been re-tested on the latest software due to being superseded by OCI Object Storage. For instructions on "Setting up Oracle Fusion SaaS...
Last Validation: October 19, 2020 for OAC 5.8 Introduction This post details the steps required in OAC versions 5.1+ to upload Autonomous Data Warehouse (ADW)...
Last Validation: October 19, 2020 for OAC 5.8 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 Metadata (RPD) connection pools, and Thin Client Modeler (TCM) models. Data connections are used for DV data sets. Replication connections are used for DV replications. Console connections are used for TCM models and RPD models...
Last Validation: October 19, 2020 for OAC 5.8 Introduction This post details the steps required in OAC versions 5.1+ to upload Autonomous Data Warehouse (ADW) wallets and to create ADW data,...
* This blog was last tested on OAC 105.8.0-133 (Version 5.8) + Source Fusion 20D (11.13.20.10.0) + Infrastructure (OCI) Object Storage + Target ADW 18c - by Jay...
* This blog was last tested on OAC 105.8.0-133 (Version 5.8) + Source Fusion 20D (11.13.20.10.0) + Infrastructure (OCI) Object Storage + Target ADW 18c - by Jay Pearson (A-Team) * For other A-Team articles by Richard, click here Introduction Oracle Analytics Cloud (OAC) has built-in functionality for SaaS data replication. This allows OAC 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...
* This blog was last tested on OAC 105.8.0-133 (Version 5.8) + Source Fusion 20D (11.13.20.10.0) + Infrastructure (OCI) Object Storage + Target ADW 18c - by Jay Pearson (A-Team) * For other A-Team...
* This blog was last tested on Fusion 21B by Jay Pearson (Oracle A-Team) * For other A-Team articles by Richard, click here Introduction For good reason, the...
* This blog was last tested on Fusion 21B by Jay Pearson (Oracle A-Team) * 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 can also extract from...
* This blog was last tested on Fusion 21B by Jay Pearson (Oracle A-Team) * For other A-Team articles by Richard, click here Introduction For good reason, the database of Fusion SaaS products is not...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. The Oracle GoldenGate (OGG) Passive-Alias Extract may...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. 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...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. The Oracle GoldenGate (OGG) Passive-Alias Extract may be used for data replication between...
Last Validated December 7, 2020 Introduction This post details the steps required to download an Autonomous Data Warehouse (ADW) Client Credentials Zip File....
Last Validated December 7, 2020 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. Validation December 7, 2020 February 26, 2019 Downloading the ADW Credentials Login to the Oracle Cloud Infrastructure (OCI) The URL is in the form: https://console.< Your Region...
Last Validated December 7, 2020 Introduction This post details the steps required to download an Autonomous Data Warehouse (ADW) Client Credentials Zip File. This file is required by all...
* This blog was last tested on Oracle Analytics Cloud Data Sync (2.6.1) + Fusion 20D (11.13.20.10.0) by Jay Pearson (Oracle A-Team) * For other A-Team articles...
* This blog was last tested on Oracle Analytics Cloud Data Sync (2.6.1) + Fusion 20D (11.13.20.10.0) by Jay Pearson (Oracle A-Team) * For other A-Team articles by Richard, click here Introduction The Oracle Data Sync tool provides the ability to extract from both on-premise, and cloud data sources, and to load that data into Oracle Analytics Cloud Service (OAC), Oracle Autonomous Analytics Cloud Service (OAAC), and other oracle relational databases, or into Essbase. Data Sync...
* This blog was last tested on Oracle Analytics Cloud Data Sync (2.6.1) + Fusion 20D (11.13.20.10.0) by Jay Pearson (Oracle A-Team) * For other A-Team articles by Richard, click here Introduction The...
Validation Content validated on 4/14/2021 with ODI Version 12.2.1.4.200304.2238 ADW Version Oracle Database 19c Enterprise Edition Release - Production Version...
Validation Content validated on 4/14/2021 with ODI Version 12.2.1.4.200304.2238 ADW Version Oracle Database 19c Enterprise Edition Release - Production Version 19.5.0.0.0 Introduction This article discusses the best practices that users should follow when using Oracle Data Integrator Marketplace (ODI) - to perform incremental updates in the Oracle Autonomous Data Warehouse Cloud Service (ADW). ADW is a fully-managed and pre-configured Oracle database cloud service that is...
Validation Content validated on 4/14/2021 with ODI Version 12.2.1.4.200304.2238 ADW Version Oracle Database 19c Enterprise Edition Release - Production Version 19.5.0.0.0 Introduction This article...
This blog has been retired. Please see...
This blog has been retired. Please see https://docs.oracle.com/en/middleware/fusion-middleware/data-integrator/12.2.1.3/odimp/getting-started-oracle-cloud-marketplace.html#GUID-1793F6A6-8581-465D-BBE3-8F0C8ADD6536 for the new ODI Marketplace usage.
