* This blog was last tested on Oracle Analytics Cloud Data Sync (2.6.1) + ADW 18c by Jay Pearson (Oracle A-Team) * For other A-Team articles about OAC and Data...
* This blog was last tested on Oracle Analytics Cloud Data Sync (2.6.1) + ADW 18c by Jay Pearson (Oracle A-Team) * For other A-Team articles about OAC 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 Oracle Autonomous Data Warehouse (ADW), and other relational databases. The functionality to run Post Load SQL and Stored Procedures was added in Data Sync v2.2 ....
* This blog was last tested on Oracle Analytics Cloud Data Sync (2.6.1) + ADW 18c by Jay Pearson (Oracle A-Team) * For other A-Team articles about OAC and Data Sync, click here Introduction The Data...
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 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 The Data Sync tool provides the ability to extract from both on-premise, and cloud data sources, and to load that data into...
* This blog was last tested on Oracle Analytics Cloud Data Sync (2.6.1) + ADW 18c by Jay Pearson (Oracle A-Team) * For other A-Team articles about OAC and Data Sync, click here Introduction This functionality has been available since Version 2.2 of the Data Sync tool, released September 2016, when the ability to connect to a number of different data sources via JDBC was added to the product. Setting up these Data Sources in Data Sync varies by the source. Rather than...
* This blog was last tested on Oracle Analytics Cloud Data Sync (2.6.1) + ADW 18c by Jay Pearson (Oracle A-Team) * For other A-Team articles about OAC and Data Sync, click here Introduction This...
* This blog was last tested on Oracle Analytics Cloud Data Sync (2.6.1) + SalesForce 2021 + ADW 18c by Jay Pearson (Oracle A-Team) * For other A-Team articles...
* This blog was last tested on Oracle Analytics Cloud Data Sync (2.6.1) + SalesForce 2021 + ADW 18c by Jay Pearson (Oracle A-Team) * For other A-Team articles about OAC and Data Sync, click here Introduction This functionality has been available since Version 2.2 of the Data Sync tool, released September 2016, when the ability to connect to a number of different data sources via JDBC was added to the product. Setting up these Data Sources in Data Sync varies by the source. ...
* This blog was last tested on Oracle Analytics Cloud Data Sync (2.6.1) + SalesForce 2021 + ADW 18c by Jay Pearson (Oracle A-Team) * For other A-Team articles about OAC and Data Sync, click here...
* This blog was last tested on: Oracle Analytics Cloud Data Sync (2.6.1) + Oracle Service Cloud 20B (Build 266) + ADW 18c by Jay Pearson (Oracle A-Team) * For...
* This blog was last tested on: Oracle Analytics Cloud Data Sync (2.6.1) + Oracle Service Cloud 20B (Build 266) + ADW 18c by Jay Pearson (Oracle A-Team) * For other A-Team articles about OAC and Data Sync, click here Introduction This functionally has been available since Data Sync v2.2 released in September 2016 - when the ability to connect to a number of different data sources via JDBC was added. Setting up these Data Sources in Data Sync varies by the source. Rather than...
* This blog was last tested on: Oracle Analytics Cloud Data Sync (2.6.1) + Oracle Service Cloud 20B (Build 266) + ADW 18c by Jay Pearson (Oracle A-Team) * For other A-Team articles about OAC and Data...
* This blog has not been recently tested on the latest version of Data Sync because it is superseded by inbuilt SSH functionality described in this blog - Jay...
* This blog has not been recently tested on the latest version of Data Sync because it is superseded by inbuilt SSH functionality described in this blog - Jay Pearson (A-Team) * For other A-Team articles about OAC 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...
* This blog has not been recently tested on the latest version of Data Sync because it is superseded by inbuilt SSH functionality described in this blog - Jay Pearson (A-Team) * For other A-Team...
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...