Introduction 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...
Introduction 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 zero-downtime migration, this time using only Oracle GoldenGate to instantiate the Oracle tables and...
Introduction 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...
For other A-Team articles about BICS and Data Sync, click here Introduction The Data Sync tool provides the ability to extract from both on-premise, and cloud...
For other A-Team articles about BICS 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 BI Cloud Service (BICS), Oracle Analytics Cloud Service (OACS), and other relational databases. In the 2.3 release of Data Sync, new functionality was added that provided the ability to transform the data as part of the load process. This new functionality is covered in more...
For other A-Team articles about BICS 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...
For other A-Team articles about BICS 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 BI Cloud Service (BICS), Oracle Analytics Cloud Service (OACS), 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 as a post-session...
For other A-Team articles about BICS 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 BI Cloud Service (BICS), Oracle Analytics Cloud Service (OACS), and other 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 release of Data Sync, the ability...
Introduction Cross-database replication and migrations pose a challenge to IT organizations due to the complexity involved in converting data types and with...
Introduction 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 export the source SQL Server Database, create and instantiate the target Oracle Database Schema,...
Introduction 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...
Introduction The target database instantiation, or initial load, process is key to a successful Oracle GoldenGate implementation. In this article we shall...
Introduction 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 questions you must first ask yourself: 1. Are we taking the source database off-line, or will...
Introduction 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...
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...
Acknowledgement First of all, I would like to thank my A-Team colleague Christian Weeks for providing a few ingenious work-arounds for some limitations in the...
Acknowledgement First of all, I would like to thank my A-Team colleague Christian Weeks for providing a few ingenious work-arounds for some limitations in the current version of ICS (16.4.5). These work-arounds will be discussed in detail in the later sections of this article. I would also thank another A-Team member, Angelo Santagata, who provided assistance with the proof of concept effort behind this article, and my manager, Pete Farkas, for reviewing this article and...
Acknowledgement First of all, I would like to thank my A-Team colleague Christian Weeks for providing a few ingenious work-arounds for some limitations in the current version of ICS (16.4.5). These...
