Introduction This article discusses how to use Loading Knowledge Modules (LKMs) in Oracle Data Integrator (ODI) to upload data into instances of the Oracle...
Introduction This article discusses how to use Loading Knowledge Modules (LKMs) in Oracle Data Integrator (ODI) to upload data into instances of the Oracle Database Cloud Service (DBCS). LKMs are re-usable code templates within the ODI framework that can be used in ODI mappings to perform data upload operations. On cloud computing, Oracle offers Platform as a Service (PaaS), which provides a shared and elastically scalable platform for the consolidation of existing...
Introduction This article discusses how to use Loading Knowledge Modules (LKMs) in Oracle Data Integrator (ODI) to upload data into instances of the Oracle Database Cloud Service (DBCS). LKMs are...
Introduction This article demonstrates how to configure Oracle Data Integrator (ODI) for the Amazon Elastic MapReduce (EMR) cloud service. Amazon EMR is a big...
Introduction This article demonstrates how to configure Oracle Data Integrator (ODI) for the Amazon Elastic MapReduce (EMR) cloud service. Amazon EMR is a big data cloud service, available on the Amazon Web Services (AWS) cloud computing services. ODI is well documented to run on both the Cloudera and Hortonworks distributions of Hadoop. ODI can also run on the distributions of Hadoop found on the Amazon EMR cloud service. This is the third article of four publications...
Introduction This article demonstrates how to configure Oracle Data Integrator (ODI) for the Amazon Elastic MapReduce (EMR) cloud service. Amazon EMR is a big data cloud service, available on the...
Introduction This article demonstrates how to install Oracle Data Integrator (ODI) on the Amazon Elastic MapReduce (EMR) cloud service. Amazon EMR is a big...
Introduction This article demonstrates how to install Oracle Data Integrator (ODI) on the Amazon Elastic MapReduce (EMR) cloud service. Amazon EMR is a big data cloud service, available on the Amazon Web Services (AWS) cloud computing services. ODI is well documented to run on both the Cloudera and Hortonworks distributions of Hadoop. ODI can also run on the distributions of Hadoop found on the Amazon EMR cloud service. This is the second article of four publications...
Introduction This article demonstrates how to install Oracle Data Integrator (ODI) on the Amazon Elastic MapReduce (EMR) cloud service. Amazon EMR is a big data cloud service, available on the Amazon...
Introduction This article demonstrates how to prepare the Amazon Elastic MapReduce (EMR) cloud service for the Oracle Data Integrator (ODI) installation. ...
Introduction This article demonstrates how to prepare the Amazon Elastic MapReduce (EMR) cloud service for the Oracle Data Integrator (ODI) installation. Amazon EMR is a big data cloud service, available on the Amazon Web Services (AWS) cloud computing services. ODI is well documented to run on both the Cloudera and Hortonworks distributions of Hadoop. ODI can also run on the distributions of Hadoop found on the Amazon EMR cloud service. This is the first article of four...
Introduction This article demonstrates how to prepare the Amazon Elastic MapReduce (EMR) cloud service for the Oracle Data Integrator (ODI) installation. Amazon EMR is a big data cloud service,...
Introduction For data replication products like Oracle GoldenGate (OGG), it is typically a best practice to have a primary key or unique index defined for...
Introduction For data replication products like Oracle GoldenGate (OGG), it is typically a best practice to have a primary key or unique index defined for tables being replicated. However, in practice this may not be possible when working with poorly designed databases or legacy applications. In this article we shall detail OGG's rules for determining uniqueness in replicated data and present examples and best practices for working with tables without primary keys or unique...
Introduction For data replication products like Oracle GoldenGate (OGG), it is typically a best practice to have a primary key or unique index defined for tables being replicated. However, in practice...
Introduction With its capacity to handle complex transformations and large volumes of data, and its ability to orchestrate operations across heterogeneous...
Introduction With its capacity to handle complex transformations and large volumes of data, and its ability to orchestrate operations across heterogeneous systems, ODI is a great tool to prepare and upload bulk data into HCM Cloud. In this post, we are looking at the different steps required to perform this task. Overview of the integration process There are three steps that are required to prepare and upload data into HCM: Transform data and prepare a file that matches the...
Introduction With its capacity to handle complex transformations and large volumes of data, and its ability to orchestrate operations across heterogeneous systems, ODI is a great tool to prepare and...
Introduction For batch imports, Oracle Cloud’s Human Capital Management (HCM) uses a dedicated file format that contains both metadata and data. As far as the...
Introduction For batch imports, Oracle Cloud’s Human Capital Management (HCM) uses a dedicated file format that contains both metadata and data. As far as the data is concerned, the complete hierarchy of parent and children records must be respected for the file content to be valid. To load data into HCM with ODI, we are looking here into a new Integration Knowledge Module (KM). This KM allows us to leverage ODI to prepare the data and generate the import file. Then...
Introduction For batch imports, Oracle Cloud’s Human Capital Management (HCM) uses a dedicated file format that contains both metadata and data. As far as the data is concerned, the complete hierarchy...
Introduction At any given time, organizations are gathering, storing, and transferring millions of records about their customers across multiple enterprise...
Introduction At any given time, organizations are gathering, storing, and transferring millions of records about their customers across multiple enterprise environments. There are various operational settings within Oracle GoldenGate (OGG) that should be set to ensure Personally Identifiable Information (PII), or Sensitive Personal Information (SPI) is not compromised. This article will discuss OGG configuration settings you should employ when replicating data to ensure...
Introduction At any given time, organizations are gathering, storing, and transferring millions of records about their customers across multiple enterprise environments. There are various operational...
hljs.initHighlightingOnLoad(); Introduction In a recent article by Richard Williams on A-Team Chronicles, Richard explained how you can execute a BI publisher...
hljs.initHighlightingOnLoad(); Introduction In a recent article by Richard Williams on A-Team Chronicles, Richard explained how you can execute a BI publisher report from a SOAP Service and retrieve the report, as XML, as part of the response of the SOAP call. This blog article serves as a follow on blog article providing a tutorial style walk through on how to implement the above procedure in Java. This article assumes you have already followed the steps in Richard's blog...
hljs.initHighlightingOnLoad(); Introduction In a recent article by Richard Williams on A-Team Chronicles, Richard explained how you can execute a BI publisher report from a SOAP Service and...
