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...
Introduction This article discusses how to use Oracle Data Integrator (ODI) with the Amazon Elastic MapReduce (EMR) cloud service. Amazon EMR is a big data...
Introduction This article discusses how to use Oracle Data Integrator (ODI) with the Amazon Elastic MapReduce (EMR) cloud service. Amazon EMR is a big data cloud service and a member of the Amazon Web Services (AWS) cloud computing services, offered by Amazon.com. In the big data space, ODI is certified on both Cloudera and Hortonworks distributions of Hadoop. In addition to Cloudera and Hortonworks certifications, ODI usability can be extended to other distributions of...
Introduction This article discusses how to use Oracle Data Integrator (ODI) with the Amazon Elastic MapReduce (EMR) cloud service. Amazon EMR is a big data cloud service and a member of the Amazon...
For other A-Team articles about BICS and Data Sync, click here Introduction Note The current version of the remote data connector available on OTN requires Java...
For other A-Team articles about BICS and Data Sync, click here Introduction Note The current version of the remote data connector available on OTN requires Java 1.8. This may impact the version of the web-server you are able to run. For instance, weblogic 10.3.6 is not certified for java 1.8, but weblogic 12c is. This is a temporary issue, an updated version should be available shortly, and then this section will be removed. This original article was written in March 2016,...
For other A-Team articles about BICS and Data Sync, click here Introduction Note The current version of the remote data connector available on OTN requires Java 1.8. This may impact the version of...
This blog is part of the series of blogs the A-Team has been running on Oracle Service Cloud (OSvC). In the previous blog I went through an introduction to the...
This blog is part of the series of blogs the A-Team has been running on Oracle Service Cloud (OSvC). In the previous blog I went through an introduction to the Bulk APIs in OSvC and briefly touched upon throughput considerations(If you haven't, please read that first). In this blog I build on the previous post and delve deeper into various operational factors to consider when implementing bulk data load into OSvC. For the purpose of this blog, I define bulk import(or bulk...
This blog is part of the series of blogs the A-Team has been running on Oracle Service Cloud (OSvC). In the previous blog I went through an introduction to the Bulk APIs in OSvC and briefly touched...
