Introduction We receive a lot of questions on how to setup Oracle GoldenGate to perform "soft" deletes in Data Warehouses. By default, Oracle GoldenGate...
Introduction We receive a lot of questions on how to setup Oracle GoldenGate to perform "soft" deletes in Data Warehouses. By default, Oracle GoldenGate replicates data operations exactly as they occur in the source database; however, in Data Warehouses their is typically a requirement to retain the original data record and set a flag that shows the record was deleted. This is what we mean by "soft" delete. In this article we shall present the three most common use cases and...
Introduction We receive a lot of questions on how to setup Oracle GoldenGate to perform "soft" deletes in Data Warehouses. By default, Oracle GoldenGate replicates data operations exactly as they...
Introduction This article presents an overview of how to integrate Oracle Data Integrator (ODI) on-premises with cloud services. Cloud computing is now a...
Introduction This article presents an overview of how to integrate Oracle Data Integrator (ODI) on-premises with cloud services. Cloud computing is now a service or a utility in high demand. Enterprises have a mix of on-premises data sources and cloud services. Oracle Data Integrator (ODI) on-premises can enable the integration of both on-promises data sources and cloud services. This article discusses how to integrate ODI on-premises with three types of cloud services: ...
Introduction This article presents an overview of how to integrate Oracle Data Integrator (ODI) on-premises with cloud services. Cloud computing is now a service or a utility in high demand....
Introduction This article discusses the best practices for selecting and using the Oracle Data Integrator (ODI) Loading Knowledge Modules (LKMs) on both...
Introduction This article discusses the best practices for selecting and using the Oracle Data Integrator (ODI) Loading Knowledge Modules (LKMs) on both on-premises and on cloud computing. LKMs are code templates in ODI that can perform data upload operations from on-premises data servers to cloud services, between cloud services, or between on-premises data servers. ODI supports a variety of technologies such as SQL databases, Big Data, Files, Java Messaging Systems...
Introduction This article discusses the best practices for selecting and using the Oracle Data Integrator (ODI) Loading Knowledge Modules (LKMs) on both on-premises and on cloud computing. LKMs are...
Introduction This article discusses best practices on using the Reverse Engineering features of Oracle Data Integrator (ODI) on the cloud and on premises. ...
Introduction This article discusses best practices on using the Reverse Engineering features of Oracle Data Integrator (ODI) on the cloud and on premises. The first part of this article presents the various options available in ODI to reverse-engineer metadata from a data server. Then, the article discusses performance considerations when running and executing reverse-engineering tasks. The last section of this article discusses the ODI reverse-engineering best...
Introduction This article discusses best practices on using the Reverse Engineering features of Oracle Data Integrator (ODI) on the cloud and on premises. The first part of this article presents...
Introduction This is the second part of a two part article which demonstrates how to upload data in near-real time from an on-premise oracle database to Oracle...
Introduction This is the second part of a two part article which demonstrates how to upload data in near-real time from an on-premise oracle database to Oracle Storage Cloud Service. In the previous article of this series, we demonstrated Oracle GoldenGate functionality to write to a flat file using Apache Flume File Roll Sink. If you would like to read the first part in this article series please visit Oracle GoldenGate : Apply to Apache Flume File Roll Sink In this article...
Introduction This is the second part of a two part article which demonstrates how to upload data in near-real time from an on-premise oracle database to Oracle Storage Cloud Service. In the previous...
Introduction Oracle Storage Cloud Service should be the central place for persisting raw data produced from another PaaS services and also the entry point for...
Introduction Oracle Storage Cloud Service should be the central place for persisting raw data produced from another PaaS services and also the entry point for data that is uploaded from the customer’s data center. Big Data Cloud Service ( BDCS ) supports data transfers between Oracle Storage Cloud Service and HDFS. Both Hadoop and Oracle provides various tools and Oracle engineered solutions for the data movement. This document outlines various tools and describes the best...
Introduction Oracle Storage Cloud Service should be the central place for persisting raw data produced from another PaaS services and also the entry point for data that is uploaded from the customer’s...
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...
