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), and other relational databases. In the recent 2.2 release of Data Sync, the functionality to run Post Load SQL and Stored Procedures was added. Currently this functionality is only available for Oracle DBCS or Oracle DB target databases - it will NOT work...
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), and other relational databases. In some use cases, both the source databases, and the target, may be in 'the Cloud'. Rather than run the Data Sync tool 'On-Premise' to extract data down from the cloud, only to load it back up again, this article...
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...
