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 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...
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...
Introduction Oracle GoldenGate (OGG) best practices dictate that the OGG Apply process run on the target database server. However, there are instances where...
Introduction 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 GoldenGate implementation that follows best practices guidelines is depicted below. In this...
Introduction 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...
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...
