Introduction Oracle GoldenGate for SQL Server allows users to capture changes made to a specific set of tables in one database and deliver those changes to...
Introduction Oracle GoldenGate for SQL Server allows users to capture changes made to a specific set of tables in one database and deliver those changes to corresponding tables in another database in near real time. Main Article Replication can serve several purposes in database information management: Replication can provide a backup of specified table data in the event of problems with the primary database. If the site is dual active, and one system becomes unavailable, the...
Introduction Oracle GoldenGate for SQL Server allows users to capture changes made to a specific set of tables in one database and deliver those changes to corresponding tables in another database in...
Introduction Oracle GoldenGate is often used in mission-critical systems with stringent high availability requirements. In an Oracle to Oracle scenario, minimal...
Introduction Oracle GoldenGate is often used in mission-critical systems with stringent high availability requirements. In an Oracle to Oracle scenario, minimal latency between the source and the destination databases is important to achieve minimal downtime and minimal data loss in case of a failover. In an Oracle Real Application Cluster (RAC) configuration access to the database is not dependent on the availability of any one of the servers in the cluster. Oracle...
Introduction Oracle GoldenGate is often used in mission-critical systems with stringent high availability requirements. In an Oracle to Oracle scenario, minimal latency between the source and...
Introduction The goal of this paper is to describe the concepts related to globalization and provide best practice guidelines when configuring Oracle GoldenGate...
Introduction The goal of this paper is to describe the concepts related to globalization and provide best practice guidelines when configuring Oracle GoldenGate (OGG). Main Article We will begin by defining character set and discuss the various usage contexts of character sets which are referred to when configuring OGG. The complete document can be found on the Oracle Support site under the document ID:1500608.1
Introduction The goal of this paper is to describe the concepts related to globalization and provide best practice guidelines when configuring Oracle GoldenGate (OGG). Main Article We will begin...
Introduction This document is intended to help you implement the best practice for creating a heartbeat process that can be used to determine where and when lag...
Introduction This document is intended to help you implement the best practice for creating a heartbeat process that can be used to determine where and when lag is developing between a source and target system. Main Article This document will walk you thru the step-by-step process of creating the necessary tables and added table mapping statements needed to keep track of processing times between a source and target database. Once the information is added into the data flow,...
Introduction This document is intended to help you implement the best practice for creating a heartbeat process that can be used to determine where and when lag is developing between a source...
Introduction When working with new Oracle GoldenGate (OGG) customers we always get two questions: How can I ensure the referential integrity of my data? How can...
Introduction When working with new Oracle GoldenGate (OGG) customers we always get two questions: How can I ensure the referential integrity of my data? How can I ensure transactions are applied to my target database in the proper order? The key is to understand the difference between referential and transactional data, and how they relate to OGG. Main Article What is Referential Integrity? Definition: Referential integrity is a relational database concept which states that...
Introduction When working with new Oracle GoldenGate (OGG) customers we always get two questions: How can I ensure the referential integrity of my data? How can I ensure transactions are applied to my...
Introduction In the case of migrating from one WebCenter Content instance to another, there are several different tools within the system to accomplish that...
Introduction In the case of migrating from one WebCenter Content instance to another, there are several different tools within the system to accomplish that migration depending on what you need to move over. This post will focus on the use case of needing to move a specific set of folders and their contents from one instance to another. And the folder architecture in this example is Folders_g. Although Framework Folders is the recommended folders component for WebCenter...
Introduction In the case of migrating from one WebCenter Content instance to another, there are several different tools within the system to accomplish that migration depending on what you need...
Introduction This is Part 1 of the B2B Life-Cycle Management Series. The series will discuss the best practices around various aspects of the complete B2B...
Introduction This is Part 1 of the B2B Life-Cycle Management Series. The series will discuss the best practices around various aspects of the complete B2B agreement life cycle. This post will discuss the first part which is related to the import of data artifacts into the repository. The specific use case discussed here is for CPAs related to ebXML data but the concepts are fairly generic and the process can be extended to any document or protocol. Main Article Background B2B...
Introduction This is Part 1 of the B2B Life-Cycle Management Series. The series will discuss the best practices around various aspects of the complete B2B agreement life cycle. This post will discuss...
