* This blog was last tested on Oracle Analytics Cloud Data Sync (2.6.1) by Jay Pearson (Oracle A-Team) + ADW 18c * 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 18c * 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 18c * 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...
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...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. Oracle GoldenGate (OGG) best practices dictate that...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. Oracle GoldenGate (OGG) best practices dictate that the OGG Apply process run on the target database server. However, there are instances where this configuration is not practical. In this article we shall discuss a solution where OGG Apply may be configured on a mid-tier server and apply data over a network to a remote SQL Server Database. Main Article A typical Oracle...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. Oracle GoldenGate (OGG) best practices dictate that the OGG Apply process run on the target...
Introduction We receive a lot of questions on how to setup Oracle GoldenGate to perform "soft" deletes in Data Warehouses. By default, Oracle GoldenGate...
Introduction We receive a lot of questions on how to setup Oracle GoldenGate to perform "soft" deletes in Data Warehouses. By default, Oracle GoldenGate replicates data operations exactly as they occur in the source database; however, in Data Warehouses their is typically a requirement to retain the original data record and set a flag that shows the record was deleted. This is what we mean by "soft" delete. In this article we shall present the three most common use cases and...
Introduction We receive a lot of questions on how to setup Oracle GoldenGate to perform "soft" deletes in Data Warehouses. By default, Oracle GoldenGate replicates data operations exactly as they...