Oracle GoldenGate: Monitoring via Restful API

Introduction Oracle GoldenGate version 12.1 introduced the ability to monitor on-premises and GoldenGate Cloud Service instances via a Restful API interface. In this article we will show how to enable monitoring and how to obtain information via Restful API for Oracle GoldenGate on-premises instances running version 12.1 or 12.2 and GoldenGate Cloud Service running version 12.2. Main Article Before […]

Oracle Data Integrator Best Practices: Using Check Knowledge Modules on both On-Premises and Cloud Computing

Introduction   This article discusses the best practices for selecting and using Oracle Data Integrator (ODI) Check Knowledge Modules (CKMs) on both on-premises data servers and cloud data services.  In traditional ETL tools, when an ETL data flow is designed, ETL developers must design steps to perform data validation and remove the records that do […]

Oracle GoldenGate: Working With Dates

Introduction By default Oracle GoldenGate handles data for date data types without any user intervention. However, there are times when you may need to manipulate this data based upon end use requirements. Oracle GoldenGate has numerous built-in functions that allows users to test and manipulate data. In this article we shall present the column-conversion functions used to […]

Oracle GoldenGate: Teradata Instantiation

Introduction When working with Teradata customers, we are always asked for recommendations of how to instantiate the target Teradata database. There are numerous ways to accomplish this; including various third-party applications that most customers have in-house. In this article, we will demonstrate a zero down-time data replication implementation from an Oracle 12c Pluggable Database to […]

Using Oracle Data Integrator Cloud Service (ODICS) to Integrate Field Service Cloud with Business Intelligence Cloud Service (BICS): An ODICS Perspective

Introduction   This article discusses how to use Oracle Data Integrator Cloud Service (ODICS) to integrate Oracle Field Service Cloud (FSC) with Business Intelligence Cloud Service (BICS).  ODICS provides pushdown data processing with high performance ETL for the Cloud. ODICS executes data transformations where the data lies without having to unnecessarily copy data to remote […]

Oracle GoldenGate: Microsoft SQL Server to Oracle Migration (Part 2)

Introduction In Part 1 of this article, we performed a zero-downtime migration of a live Microsoft SQL Server Database to an Oracle Pluggable Database using the Microsoft SQL Server Import and Export Wizard and Oracle GoldenGate. In this part, we will do the same zero-downtime migration using Oracle SQL Developer to create the target schema and […]

Oracle GoldenGate: Microsoft SQL Server to Oracle Migration (Part 3)

Introduction In Part 1 of this article, we performed a zero-downtime migration of a live Microsoft SQL Server Database to an Oracle Pluggable Database using the Microsoft SQL Server Import and Export Wizard and Oracle GoldenGate. In Part 2, we performed the same zero-downtime migration using Oracle SQL Developer and Oracle GoldenGate. In this part, […]

Performing ELT Lookups with Data Sync

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), Oracle Analytics Cloud Service (OACS), and other relational databases. In the 2.3 release of Data Sync, new […]

Performing ELT Data Transformations with Data Sync

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), Oracle Analytics Cloud Service (OACS), and other relational databases. In the past, if you needed to transform the […]

Using Native SSH Tunnel Functionality within the Data Sync Tool to Secure Connections

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), Oracle Analytics Cloud Service (OACS), and other relational databases. Last year I covered an approach that could […]

Oracle Data Integrator Cloud Service (ODICS) : Where to Run Studio

Oracle Data Integrator (ODI) is now available as a Cloud Service: Oracle Data Integrator Cloud Service (ODICS). For customers who are interested in a subscription model for their ODI installation and want to integrate and transform data in the Cloud, this is the solution. Start by deploying ODICS following the Oracle By Example document Provisioning […]

Deploying ODICS Studio on a Windows Image (Compute Cloud Service)

Based on our experience, in the on-premise world, most ODI Developers are using ODI Studio on Windows. So, we thought detailing how to deploy ODICS on a Windows Image on Compute might be useful. This can be used to connect to an ODICS Repository that has already been installed. PLEASE NOTE THAT THIS IS ONLY […]

Oracle GoldenGate: Microsoft SQL Server to Oracle Migrations (Part 1)

Introduction Cross-database replication and migrations pose a challenge to IT organizations due to the complexity involved in converting data types and with target database instantiation. In this series of articles we shall explore three options for migrating a Microsoft SQL Server Database to an Oracle Database. In Part 1, we’ll use the Microsoft Import and Export Data […]

GoldenGate Cloud Service (GGCS): Replication from Amazon RDS MySQL Database to Oracle DBCS

Introduction This document will walk you through how to configure Oracle GoldenGate (OGG) replication from Amazon Relational Database Service (RDS) MySQL Database to an Oracle Database Cloud Service (DBCS) on Oracle Public Cloud (OPC) via Amazon Web Services (AWS) Elastic Compute Cloud (EC2) and Oracle GoldenGate Cloud Service (GGCS). The following topics are not included in […]

Loading Data from Oracle Field Service Cloud into Oracle Analytics Cloud using ODI and REST – Part III

Introduction In December, 2016 Oracle announced Oracle Data Integrator (ODI) release 12.2.1.2.6 which contains significant new features including RESTful services. This three-part series details a method of extracting and loading data from Oracle Field Service Cloud (OFSC) into Oracle Analytics Cloud (OAC). It is a companion to the A-Team post Loading Data from Oracle Field Service Cloud […]

Loading Data from Oracle Field Service Cloud into Oracle Analytics Cloud using ODI and REST – Part II

  Introduction In December, 2016 Oracle announced Oracle Data Integrator (ODI) release 12.2.1.2.6 which contains significant new features including RESTful services. This three-part series details a method of extracting and loading data from Oracle Field Service Cloud (OFSC) into Oracle Analytics Cloud (OAC). It is a companion to the A-Team post Loading Data from Oracle Field Service […]

Loading Data from Oracle Field Service Cloud into Oracle Analytics Cloud using ODI and REST – Part I

Introduction In December, 2016 Oracle announced Oracle Data Integrator (ODI) release 12.2.1.2.6 which contains significant new features including support for RESTful services. This three-part series details a method of extracting and loading data from Oracle Field Service Cloud (OFSC) into Oracle Analytics Cloud (OAC). It is a companion to the A-Team post Loading Data from Oracle Field […]

Oracle GoldenGate: SQL Server to SQL Server Instantiation

Introduction The target database instantiation, or initial load, process is key to a successful Oracle GoldenGate implementation. In this article we shall present best practices when instantiating a target Microsoft SQL Server database from a source SQL Server database when implementing Oracle GoldenGate. Main Article When planning a target database instantiation, there are several questions […]

GoldenGate Cloud Service (GGCS): Replication from Amazon RDS Oracle Database to Oracle DBCS

Introduction This document will walk you through how to configure Oracle GoldenGate (OGG) replication from Amazon Relational Database Service (RDS) Oracle Database to an Oracle Database Cloud Service (DBCS) on Oracle Public Cloud (OPC) via Amazon Web Services (AWS) Elastic Compute Cloud (EC2) and Oracle GoldenGate Cloud Service (GGCS). The following topics are not included […]

GoldenGate Cloud Service (GGCS): Replication from On-Premises to Oracle Public Cloud (OPC)

Introduction This document will walk you through how to configure Oracle GoldenGate (OGG) replication between On-Premises Oracle Database to an Oracle Database Cloud Service (DBCS) on Oracle Public Cloud (OPC) via GoldenGate Cloud Service (GGCS). Installation of Oracle GoldenGate for Oracle Database on the On-Premises and the provisioning of Oracle GGCS and DBCS are not […]