For other A-Team articles about BICS and Data Sync, click here Introduction Version 2.2 of the Data Sync tool was released September 2016 and added the ability...
For other A-Team articles about BICS and Data Sync, click here Introduction Version 2.2 of the Data Sync tool was released September 2016 and added the ability to connect to a number of different data sources via JDBC. Setting up these Data Sources in Data Sync varies by the source. Rather than create a single article to cover them all, 3 have been written. Select the appropriate article to learn more about the steps to set up that Data Source: This article will cover a...
For other A-Team articles about BICS and Data Sync, click here Introduction Version 2.2 of the Data Sync tool was released September 2016 and added the ability to connect to a number of different data...
For other A-Team articles about BICS and Data Sync, click here Introduction Version 2.2 of the Data Sync tool was released Septembert 2016 and added the ability...
For other A-Team articles about BICS and Data Sync, click here Introduction Version 2.2 of the Data Sync tool was released Septembert 2016 and added the ability to connect to a number of different data sources via JDBC. Setting up these Data Sources in Data Sync varies by the source. Rather than create a single article to cover them all, 3 different articles have been created. Select the link in the right column of the table below to view the appropriate article. This...
For other A-Team articles about BICS and Data Sync, click here Introduction Version 2.2 of the Data Sync tool was released Septembert 2016 and added the ability to connect to a number of different...
For other A-Team articles about BICS and Data Sync, click here Introduction Version 2.2 of the Data Sync tool was released September 2016 and added the ability to connect to a number of different data sources via JDBC. Setting up these Data Sources in Data Sync varies by the source. Rather than create a single article to cover them all, 3 have been created. Select the appropriate article to learn more about the steps to set up that Data Source. This article covers the steps...
For other A-Team articles about BICS and Data Sync, click here Introduction Since this article was written, the ability to create an SSH tunnel has been added...
For other A-Team articles about BICS and Data Sync, click here Introduction Since this article was written, the ability to create an SSH tunnel has been added as inbuilt functionality to the Data Sync tool. For more details of how to use that, please see this article. The method detailed in this article can be used for older versions of the Data Sync tool, or for a 'how to' on setting up an SSH tunnel to the DBaaS database. The Data Sync tool can be used to load both...
For other A-Team articles about BICS and Data Sync, click here Introduction Since this article was written, the ability to create an SSH tunnel has been added as inbuilt functionality to the Data Sync...
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...
