Introduction Oracle GoldenGate contains advanced functionality that exposes a wealth of information users may leverage. In this article we shall discuss three...
Introduction Oracle GoldenGate contains advanced functionality that exposes a wealth of information users may leverage. In this article we shall discuss three of these, TOKENS; which is user defined data written to Oracle GoldenGate Trails, the Column Conversion Function @TOKEN; which is used to retrieve the token data from the Oracle GoldenGate Trail, and the Column Conversion Function @GETENV; which is used to get information about the Oracle GoldenGate environment. We will...
Introduction Oracle GoldenGate contains advanced functionality that exposes a wealth of information users may leverage. In this article we shall discuss three of these, TOKENS; which is user defined...
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 Session SQL and Stored Procedures was added. This allows, for instance, the Data Sync tool to call a stored procedure to update summary tables, and...
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 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 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...
