Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. Oracle GoldenGate for Oracle Databases provides for...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. Oracle GoldenGate for Oracle Databases provides for the replication of DDL operations. In most environments DDL replication is used only where the source and target tables structures are the same. The challenge comes when the source and target tables have a dissimilar table structure; as may exist in a Data Warehouse or Reporting Database. In this article we shall...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. Oracle GoldenGate for Oracle Databases provides for the replication of DDL operations. In...
* This blog was last tested on Oracle Analytics Cloud Data Sync (2.6.1) + ADW 18c by Jay Pearson (Oracle A-Team) * For other A-Team articles by Richard, click...
* This blog was last tested on Oracle Analytics Cloud Data Sync (2.6.1) + ADW 18c by Jay Pearson (Oracle A-Team) * For other A-Team articles by Richard, 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 a variety of data sources such as Oracle Autonomous Data Warehouse (ADW). This article will walk through the steps to set up the connection to ADW, and show how to create a...
* This blog was last tested on Oracle Analytics Cloud Data Sync (2.6.1) + ADW 18c by Jay Pearson (Oracle A-Team) * For other A-Team articles by Richard, click here Introduction The Data Sync tool...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. Oracle GoldenGate (OGG) supports DDL capture and...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. 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...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. Oracle GoldenGate (OGG) supports DDL capture and apply for the Oracle and MySQL databases...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. Oracle GoldenGate (OGG) version 12.2 introduced an...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. 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...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. Oracle GoldenGate (OGG) version 12.2 introduced an automatic heartbeat integrated into the...
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...
* This blog was last tested on Oracle Analytics Cloud Data Sync (2.6.1) by Jay Pearson (Oracle A-Team) * For other A-Team articles about OAC and Data Sync,...
* This blog was last tested on Oracle Analytics Cloud Data Sync (2.6.1) by Jay Pearson (Oracle A-Team) * For other A-Team articles about 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 load into relational databases. Previous A-Team blogs describe how to use Data Sync to extract data from OTBI, both cloud and on-premise, and to load into a relational database. Data Sync allows...
* This blog was last tested on Oracle Analytics Cloud Data Sync (2.6.1) by Jay Pearson (Oracle A-Team) * For other A-Team articles about OAC and Data Sync, click here Introduction The Data Sync tool...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. Securing platforms, applications, and data from...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. Securing platforms, applications, and data from unauthorized access is of great importance to IT organizations. In this article we shall detail the product features and best practices for securing your Oracle GoldenGate environment. The concepts presented in this article are for educational purposes only. Before applying any changes presented in this article to your...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. Securing platforms, applications, and data from unauthorized access is of great importance to...
Introduction Oracle GoldenGate for HP Nonstop provides capabilities for the manipulation of transactional data and the replication of selected TMF Audited...
Introduction Oracle GoldenGate for HP Nonstop provides capabilities for the manipulation of transactional data and the replication of selected TMF Audited Enscribe, SQL/MP, SQL/MX, and Non-Audited Enscribe data to a variety of applications and platforms. In this article we shall present a series of "best practices" for the configuration and operation of Oracle GoldenGate when replicating HP Nonstop TMF Audited data. Main Article Properly configuring your Oracle GoldenGate...
Introduction Oracle GoldenGate for HP Nonstop provides capabilities for the manipulation of transactional data and the replication of selected TMF Audited Enscribe, SQL/MP, SQL/MX, and...
This blog has been retired. The DBaaS and BICS are both on Classic and current versions are unavailable to test with. Use this for a command line method:...
This blog has been retired. The DBaaS and BICS are both on Classic and current versions are unavailable to test with. Use this for a command line method: https://docs.oracle.com/database/121/DBSEG/asoappf.htm#DBSEG610 And this for a GUI method: https://docs.oracle.com/database/121/DBIMI/walet.htm#DBIMI160
