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...
* This blog was last tested on Oracle Analytics Cloud Data Sync (2.6.1) by Jay Pearson (Oracle A-Team) + ADW 19c * For other A-Team articles about OAC and Data...
* This blog was last tested on Oracle Analytics Cloud Data Sync (2.6.1) by Jay Pearson (Oracle A-Team) + ADW 19c * 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 other relational databases. In the past, if you needed to transform the data as part of the load process, the only options were to do it in a SQL statement against the source database, or...
* This blog was last tested on Oracle Analytics Cloud Data Sync (2.6.1) by Jay Pearson (Oracle A-Team) + ADW 19c * For other A-Team articles about OAC and Data Sync, click here Introduction The Data...
* 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 to load that data into relational databases. Last year I covered an approach that could be used to secure the connections used by Data Sync by using an SSH tunnel (link to the article) In the 2.3...
* 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. Cross-database replication and migrations pose a...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. Cross-database replication and migrations pose a challenge to IT organizations due to the complexity involved in converting data types and with target database instantiation. In this series of articles we shall explore three options for migrating a Microsoft SQL Server Database to an Oracle Database. In Part 1, we'll use the Microsoft Import and Export Data Wizard to...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. Cross-database replication and migrations pose a challenge to IT organizations due to the...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. The target database instantiation, or initial load,...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. The target database instantiation, or initial load, process is key to a successful Oracle GoldenGate implementation. In this article we shall present best practices when instantiating a target Microsoft SQL Server database from a source SQL Server database when implementing Oracle GoldenGate. Main Article When planning a target database instantiation, there are several...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. The target database instantiation, or initial load, process is key to a successful Oracle...
The blog post "Load Data into Oracle HCM Cloud Using ICS" describes loading and importing XML based Talent Profile data into HCM using ICS. This post...
The blog post "Load Data into Oracle HCM Cloud Using ICS" describes loading and importing XML based Talent Profile data into HCM using ICS. This post supplements the aforementioned post by providing more detailed information on the HCM Talent Profile and its related HCM data objects. Some background information and a disclaimer A few weeks ago, I was handed over a text file and asked to do a POC using ICS to load the text file into Oracle HCM Cloud. That was my first contact...
The blog post "Load Data into Oracle HCM Cloud Using ICS" describes loading and importing XML based Talent Profile data into HCM using ICS. This post supplements the aforementioned post by...
Introduction This post supplements another post "Load Data into Oracle HCM Cloud Using ICS" by providing more details on creating NXSD schema for HDL format....
Introduction This post supplements another post "Load Data into Oracle HCM Cloud Using ICS" by providing more details on creating NXSD schema for HDL format. Oracle Fusion Apps (cloud or on-prem) provide text file based batch data loading capabilities through a SOAP API. This feature can be used for integrating external applications with HCM Cloud via ICS and/or SOACS. The text files are in different native formats depending on the specific Fusion application being...
Introduction This post supplements another post "Load Data into Oracle HCM Cloud Using ICS" by providing more details on creating NXSD schema for HDL format. Oracle Fusion Apps (cloud or...
