Introduction Oracle GoldenGate (OGG) supports DDL capture and apply for the Oracle and MySQL databases only. Because of this, maintenance tasks for other...
Introduction Oracle GoldenGate (OGG) supports DDL capture and apply for the Oracle and MySQL databases only. Because of this, maintenance tasks for other databases require a lot of coordination and typically an extended OGG outage. In this article we shall discuss one option for automating the capture, delivery, and execution of DDL operations using OGG for Microsoft SQL Server. The techniques discussed may also be used for other databases supported by OGG. The concepts,...
Introduction Oracle GoldenGate (OGG) supports DDL capture and apply for the Oracle and MySQL databases only. Because of this, maintenance tasks for other databases require a lot of coordination and...
Introduction Oracle GoldenGate (OGG) version 12.2 introduced an automatic heartbeat integrated into the application. In this article we shall demonstrate how to...
Introduction Oracle GoldenGate (OGG) version 12.2 introduced an automatic heartbeat integrated into the application. In this article we shall demonstrate how to enable the OGG heartbeat in an Oracle to Oracle replication environment, demonstrate the additional information made available via heartbeat, and demonstrate how to manage and modify heartbeat across the replication environment. The concepts, scripts and information presented in this article are for educational...
Introduction Oracle GoldenGate (OGG) version 12.2 introduced an automatic heartbeat integrated into the application. In this article we shall demonstrate how to enable the OGG heartbeat in an Oracle...
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...
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 following example. In one database we have an employee called Peter Parker. In the other database, we see 4 different rows of data...
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...
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...
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 to extract data from OTBI, both cloud and on-premise, and to load into BICS or OAC (that article is here). New functionality has...
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...
Introduction This article discusses how to configure Oracle Data Integrator (ODI) for Oracle Big Data Cloud (BDC) using the ODI Enterprise or...
Introduction This article discusses how to configure Oracle Data Integrator (ODI) for Oracle Big Data Cloud (BDC) using the ODI Enterprise or High-Availability installation. ODI offers out of the box integration with Big Data technologies such as Apache Hadoop, Apache Spark, Apache Hive, Apache Pig, and Apache Kafka, among others. ODI supports both distributions of Hadoop: Hortonworks Data Platform (HDP), and Cloudera Enterprise Data Hub (CDH). Additionally, ODI can...
Introduction This article discusses how to configure Oracle Data Integrator (ODI) for Oracle Big Data Cloud (BDC) using the ODI Enterprise or High-Availability installation. ODI offers out of the...
Introduction This article discusses how to configure Oracle Data Integrator (ODI) for Oracle Big Data Cloud (BDC) using the ODI Standalone installation. ODI...
Introduction This article discusses how to configure Oracle Data Integrator (ODI) for Oracle Big Data Cloud (BDC) using the ODI Standalone installation. ODI offers out of the box integration with Big Data technologies such as Apache Hadoop, Apache Spark, Apache Hive, Apache Pig, and Apache Kafka, among others. ODI supports both distributions of Hadoop: Hortonworks Data Platform (HDP), and Cloudera Enterprise Data Hub (CDH). Additionally, ODI can also be used on...
Introduction This article discusses how to configure Oracle Data Integrator (ODI) for Oracle Big Data Cloud (BDC) using the ODI Standalone installation. ODI offers out of the box integration with...
Introduction This article discusses how to configure the Oracle Data Integrator (ODI) for Oracle Big Data Cloud (BDC) – specifically - how to configure the...
Introduction This article discusses how to configure the Oracle Data Integrator (ODI) for Oracle Big Data Cloud (BDC) – specifically - how to configure the BDC environment for ODI, so users can design Big Data workloads with ODI and execute them on BDC. ODI offers out of the box integration with Big Data technologies such as Apache Hadoop, Apache Spark, Apache Hive, Apache Pig, and Apache Kafka, among others. ODI supports both distributions of Hadoop: Hortonworks Data...
Introduction This article discusses how to configure the Oracle Data Integrator (ODI) for Oracle Big Data Cloud (BDC) – specifically - how to configure the BDC environment for ODI, so users can...
Introduction This article discusses how to configure the Oracle Data Integrator (ODI) for Oracle Big Data Cloud (BDC), specifically - how to configure the ODI...
Introduction This article discusses how to configure the Oracle Data Integrator (ODI) for Oracle Big Data Cloud (BDC), specifically - how to configure the ODI Topology. ODI offers out of the box integration with Big Data technologies such as Apache Hadoop, Apache Spark, Apache Hive, Apache Pig, and Apache Kafka, among others. ODI supports both distributions of Hadoop: Hortonworks Data Platform (HDP), and Cloudera Enterprise Data Hub (CDH). Additionally, ODI can also be...
Introduction This article discusses how to configure the Oracle Data Integrator (ODI) for Oracle Big Data Cloud (BDC), specifically - how to configure the ODI Topology. ODI offers out of the box...
Introduction This article presents an overview of how to use Oracle Data Integrator (ODI) with Oracle Big Data Cloud (BDC). ODI offers out of the box...
Introduction This article presents an overview of how to use Oracle Data Integrator (ODI) with Oracle Big Data Cloud (BDC). ODI offers out of the box integration with Big Data technologies such as Apache Hadoop, Apache Spark, Apache Hive, and Apache Pig, among others. ODI supports both distributions of Hadoop: Hortonworks Data Platform (HDP), and Cloudera Enterprise Data Hub (CDH). Additionally, ODI can also be used on other distributions of Hadoop such as Amazon Elastic...
Introduction This article presents an overview of how to use Oracle Data Integrator (ODI) with Oracle Big Data Cloud (BDC). ODI offers out of the box integration with Big Data technologies such as...
