Validation Content validated on 5/6/2021 with ODI Version 12.2.1.4.200721.1540 Oracle DB System 19.7.0.0 Introduction When ODI developers connect to the ODI...
Validation Content validated on 5/6/2021 with ODI Version 12.2.1.4.200721.1540 Oracle DB System 19.7.0.0 Introduction When ODI developers connect to the ODI studio, they can edit the connection parameters. In particular, they can manually select the Work Repository that they will connect to. Repository access can be password protected, but for security reasons it is best to not even list repositories that users should not have access to. This post will detail the necessary...
Validation Content validated on 5/6/2021 with ODI Version 12.2.1.4.200721.1540 Oracle DB System 19.7.0.0 Introduction When ODI developers connect to the ODI studio, they can edit the connection...
Introduction This document will walk you through how to configure Oracle GoldenGate Veridata with Secured Shell (SSH) tunneling protocol in a Linux environment....
Introduction This document will walk you through how to configure Oracle GoldenGate Veridata with Secured Shell (SSH) tunneling protocol in a Linux environment. Main Article The example configuration in this document was done using 3 separate servers. A Veridata server (veridata-ole), a second server acting as a database source server (db-source-ole) running Veridata agent locally, and a third server acting as a database target server (db-target-ole) running Veridata agent...
Introduction This document will walk you through how to configure Oracle GoldenGate Veridata with Secured Shell (SSH) tunneling protocol in a Linux environment. Main Article The example configuration...
Introduction This script is intended to query the database by schema to identify current configuration and identify any unsupported data types or types that may...
Introduction This script is intended to query the database by schema to identify current configuration and identify any unsupported data types or types that may need special considerations for GoldenGate in a DB2 environment. Main Article The complete script can be found in the Oracle Support Site under document ID 1438514.1.
Introduction This script is intended to query the database by schema to identify current configuration and identify any unsupported data types or types that may need special considerations for...
Introduction This script is intended to query a MySQL database to identify current configuration and identify any data types or types that may need special...
Introduction This script is intended to query a MySQL database to identify current configuration and identify any data types or types that may need special considerations for Oracle GoldenGate in a MySQL environment. Main Article The complete script can be found in the Oracle Support Site under document ID:1501176.1
Introduction This script is intended to query a MySQL database to identify current configuration and identify any data types or types that may need special considerations for Oracle GoldenGate in...
Introduction Oracle GoldenGate is the strategic replication solution for Oracle Database and for heterogeneous databases. Given the strategic nature of Oracle...
Introduction Oracle GoldenGate is the strategic replication solution for Oracle Database and for heterogeneous databases. Given the strategic nature of Oracle GoldenGate, Oracle Streams will continue to be supported, but will not be enhanced. For this reason, some Oracle Streams customers may prefer to migrate their replication environments to Oracle GoldenGate. Main Article The goal of this document is to provide a step-by-step explanation of the migration process for a...
Introduction Oracle GoldenGate is the strategic replication solution for Oracle Database and for heterogeneous databases. Given the strategic nature of Oracle GoldenGate, Oracle Streams will continue...
Introduction In a Database Vault Environment, the Oracle GoldenGate Extract and Replicat users will require additional permissions in order to access Redo Log...
Introduction In a Database Vault Environment, the Oracle GoldenGate Extract and Replicat users will require additional permissions in order to access Redo Log Information, System views and Table Data. Main Article Both Extract and Replicat will require access to the table data. Extract may need to fetch certain data and Replicat will need to apply data to the target tables. In order to do this, the OGG user must have Access to the Database Vault (DV) Realm. The DV Realm is...
Introduction In a Database Vault Environment, the Oracle GoldenGate Extract and Replicat users will require additional permissions in order to access Redo Log Information, System views and Table...
Introduction In systems where you dont have direct access to the source system you can now take advantage of remote data mining using Oracle Archive log files...
Introduction In systems where you dont have direct access to the source system you can now take advantage of remote data mining using Oracle Archive log files only. You can use this method of data extraction against the Source Oracle Database, Standby database, Meta data database or even BCV copy of the source database. One advantage of extracting from archive log files is that the whole process can be offloaded to another system and literally have zero impact on the...
Introduction In systems where you dont have direct access to the source system you can now take advantage of remote data mining using Oracle Archive log files only. You can use this method of data...
Introduction In a multi-master database environment where the occurrence of conflicts is possible during replication, it is highly desirable to have a conflict...
Introduction In a multi-master database environment where the occurrence of conflicts is possible during replication, it is highly desirable to have a conflict management scheme which is enforced as an exception rather than as a norm. Typically, the chances of conflicts occurring during replication are low and hence, checking for conflicts every time before a record is applied on the target is not efficient. However, at the same time it is highly important to ensure that...
Introduction In a multi-master database environment where the occurrence of conflicts is possible during replication, it is highly desirable to have a conflict management scheme which is enforced as...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. Oracle GoldenGate's flexible architecture provides...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. Oracle GoldenGate's flexible architecture provides built-in functionality for the transformation of captured transactional data. This data manipulation may take place anywhere in the Oracle GoldenGate stream; but is most commonly performed in the Change Data Apply (Replicat) process during data apply to the target. Main Article In this document we shall use this...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. Oracle GoldenGate's flexible architecture provides built-in functionality for...
