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 can also extract from these view objects. BI Apps customers have pre-created ODI mappings, that take the...
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...
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...
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. In the most recent 2.5 release, Data Sync added the ability to pull data directly from Fusion SaaS view objects. The same view objects that...
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...
Introduction This article discusses the best practices that users should follow when using Oracle Data Integration Platform Cloud (DIPC) - specifically Oracle...
Introduction This article discusses the best practices that users should follow when using Oracle Data Integration Platform Cloud (DIPC) - specifically Oracle Data Integrator (ODI) - to perform incremental updates in the Oracle Autonomous Data Warehouse Cloud Service (ADWC). ADWC is a fully-managed and pre-configured Oracle database cloud service that is tuned and optimized for data warehouse workloads. As an autonomous cloud service, ADWC does not require database...
Introduction This article discusses the best practices that users should follow when using Oracle Data Integration Platform Cloud (DIPC) - specifically Oracle Data Integrator (ODI) - to perform...
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.
Introduction Apache Flume is a distributed, reliable, and available system for efficiently collecting, aggregating and moving large amounts of log data from...
Introduction Apache Flume is a distributed, reliable, and available system for efficiently collecting, aggregating and moving large amounts of log data from many different sources to a centralized data store. The Oracle GoldenGate for Big Data Flume Handler is designed to stream change capture data from a Oracle GoldenGate trail to a Flume File Roll Sink. In this article we will setup the Oracle GoldenGate Big Data Flume Handler and configure data apply from Oracle 12c...
Introduction Apache Flume is a distributed, reliable, and available system for efficiently collecting, aggregating and moving large amounts of log data from many different sources to a...
Introduction When publishing data to Apache Kafka via the Oracle GoldenGate Big Data Kafka Handler, it is a good practice to establish secure connections in...
Introduction When publishing data to Apache Kafka via the Oracle GoldenGate Big Data Kafka Handler, it is a good practice to establish secure connections in order to protect sensitive data from un-authorized snooping. The Oracle Big Data Kafka Handler leverages encryption and authentication features built-in to Apache Kafka. In this article we shall detail the Oracle GoldenGate Big Data Apache Handler configuration settings to create secure connections. This document covers...
Introduction When publishing data to Apache Kafka via the Oracle GoldenGate Big Data Kafka Handler, it is a good practice to establish secure connections in order to protect sensitive data from...
