Introduction A question that often comes up is how many Master Repositories should be created for a proper ODI architecture. The short answer is that this will...
Introduction A question that often comes up is how many Master Repositories should be created for a proper ODI architecture. The short answer is that this will depend on the network configuration. This article will elaborate on this very simplistic answer and will help define best practices for the architecture of ODI repositories in a corporate environment. How Many ODI Master Repositories Should We Have? Master and Work Repositories Before delving into the specifics of...
Introduction A question that often comes up is how many Master Repositories should be created for a proper ODI architecture. The short answer is that this will depend on the network...
Introduction Unlike "bigADF", the current row in ADF Mobile is not preserved across pages that bind to the same data collection in your data control. The...
Introduction Unlike "bigADF", the current row in ADF Mobile is not preserved across pages that bind to the same data collection in your data control. The standard approach to preserve row currency is labor intensive and not straightforward. In this article we will explain a more advanced technique to preserve the row currency which is more elegant and less work and can be easily removed once this has become a native feature in ADF Mobile. Main Article The typical use case...
Introduction Unlike "bigADF", the current row in ADF Mobile is not preserved across pages that bind to the same data collection in your data control. The standard approach to preserve row currency is...
Introduction When ODI developers connect to the ODI studio, they can edit the connection parameters. In particular, they can manually select the Work Repository...
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 steps to make sure that only authorized repositories are listed in the ODI login detail window. Restricting...
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...
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...
