This article has been deprecated. Refer to the Oracle GoldenGate 19c Security Guide for information on properly securing your Oracle GoldenGate...
This article has been deprecated. Refer to the Oracle GoldenGate 19c Security Guide for information on properly securing your Oracle GoldenGate installations. https://docs.oracle.com/en/middleware/goldengate/core/19.1/securing/index.html
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
Validation Content validated on 4/14/2021 with ODI Version 12.2.1.4.200721.1540 Introduction This article discusses the best practices for selecting and using...
Validation Content validated on 4/14/2021 with ODI Version 12.2.1.4.200721.1540 Introduction This article discusses the best practices for selecting and using Oracle Data Integrator (ODI) Check Knowledge Modules (CKMs) on both on-premises data servers and cloud data services. In traditional ETL tools, when an ETL data flow is designed, ETL developers must design steps to perform data validation and remove the records that do not pass validation. The task of designing and...
Validation Content validated on 4/14/2021 with ODI Version 12.2.1.4.200721.1540 Introduction This article discusses the best practices for selecting and using Oracle Data Integrator (ODI) Check...
Introduction By default Oracle GoldenGate handles data for date data types without any user intervention. However, there are times when you may need to...
Introduction By default Oracle GoldenGate handles data for date data types without any user intervention. However, there are times when you may need to manipulate this data based upon end use requirements. Oracle GoldenGate has numerous built-in functions that allows users to test and manipulate data. In this article we shall present the column-conversion functions used to work with dates and timestamps: @DATE, @DATEDIFF, and @DATENOW. Main Article Oracle GoldenGate provides...
Introduction By default Oracle GoldenGate handles data for date data types without any user intervention. However, there are times when you may need to manipulate this data based upon end...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. When working with Teradata customers, we are always...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. When working with Teradata customers, we are always asked for recommendations of how to instantiate the target Teradata database. There are numerous ways to accomplish this; including various third-party applications that most customers have in-house. In this article, we will demonstrate a zero down-time data replication implementation from an Oracle 12c Pluggable...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. When working with Teradata customers, we are always asked for recommendations of how to...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. In Part 1 of this article, we performed a...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. In Part 1 of this article, we performed a zero-downtime migration of a live Microsoft SQL Server Database to an Oracle Pluggable Database using the Microsoft SQL Server Import and Export Wizard and Oracle GoldenGate. In this part, we will do the same zero-downtime migration using Oracle SQL Developer to create the target schema and instantiate the tables, and use Oracle...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. In Part 1 of this article, we performed a zero-downtime migration of a live Microsoft SQL...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. In Part 1 of this article, we performed a zero-downtime migration of a live Microsoft SQL Server Database to an Oracle Pluggable Database using the Microsoft SQL Server Import and Export Wizard and Oracle GoldenGate. In Part 2, we performed the same zero-downtime migration using Oracle SQL Developer and Oracle GoldenGate. In this part, we again perform the same...
* This blog was last tested on Oracle Analytics Cloud Data Sync (2.6.1) + ADW 19c by Jay Pearson (Oracle A-Team) * For other A-Team articles about OAC and Data...
* This blog was last tested on Oracle Analytics Cloud Data Sync (2.6.1) + ADW 19c 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, then load that data into a relational database. Since Data Synch 2.3, functionality was added that provides the ability to transform the data as part of the load process. This functionality is...
* This blog was last tested on Oracle Analytics Cloud Data Sync (2.6.1) + ADW 19c by Jay Pearson (Oracle A-Team) * For other A-Team articles about OAC and Data Sync, click here Introduction The Data...
