Oracle DataSource for Apache Hadoop (OD4H): introduction

Introduction Currently we see that Hadoop is becoming part of Enterprise Data Warehouse family. But family should be connected to each other. Sometimes we need access to Hadoop from Oracle Database. Sometimes Hadoop users need enterprise data stored in Oracle database. Hive has very interesting concept – External Tables which allow you to define Java …

Continue reading ‘Oracle DataSource for Apache Hadoop (OD4H): introduction’ »

GoldenGate Cloud Service (GGCS): Configure GoldenGate to replicate data

GoldenGate Cloud Service is part of Oracle’s PaaS portfolio. From technical perspective it is just standard GoldenGate deployed on VM in Oracle Cloud. So same already proven architecture works in Cloud. GGCS can be used for different cases from zero downtime migration to real-time DWH feeding. More cases like BigData and data pipeline feeding are …

Continue reading ‘GoldenGate Cloud Service (GGCS): Configure GoldenGate to replicate data’ »

Oracle Database Cloud Service: Create database

Oracle Cloud provides several Oracle Database offerings. You can choose from a single schema based service virtual machine with a fully configured and running Oracle Database Instance Exadata Service with all the database features. You can look into details here: https://cloud.oracle.com/en_US/database We will talk about Database as a Service and not about Schema or Exadata …

Continue reading ‘Oracle Database Cloud Service: Create database’ »

Oracle Storage Cloud Service: Creating Containers Using the REST API

Introduction Let’s define terms which Oracle uses in Oracle Cloud Services. Block Storage – optimizes storage for IOPS and block-based access and provides POSIX-compliant file systems for Oracle Compute Cloud Service instances. This is just standard disk device. Sometimes it is only one drive, sometimes it is RAID device. But anyway application access it using …

Continue reading ‘Oracle Storage Cloud Service: Creating Containers Using the REST API’ »

GoldenGate Studio: Quick Start

Introduction You work with GoldenGate then you know that there was tool GoldenGate Director for configuration, deployment, monitoring and management. Really these responsibilities are distributed among development and support. So there should be two tools: for development and for support. Oracle is following this ideology and has created two tools:   GoldenGate Monitor (or GG …

Continue reading ‘GoldenGate Studio: Quick Start’ »

Configuring GoldenGate to replicate data from MSSQL Standard Edition (CDC, Change Data Capture)

Introduction One of GoldenGate 12.2 new features is replication support for MSSQL Standard Edition. In the previous GoldenGate 12.1 release, GoldenGate supported capture of DML only from SQL Server Enterprise Edition, due to the method of enabling Supplemental Logging, which is done via a feature only available to Enterprise Editions of SQL Server. Fortunately, beginning …

Continue reading ‘Configuring GoldenGate to replicate data from MSSQL Standard Edition (CDC, Change Data Capture)’ »

GoldenGate Monitor 12.2: how to change password for internal communications

When install GoldenGate Monitor we create special credentials used by GoldenGate Agent and GoldenGate Monitor to secure communications. Also we set this credentials while configuring GoldenGate Agent using pw_agent_util.sh. But is not well documented how these credentials are used and how change them. So let fill these gap.

Configuring GoldenGate Monitor 12.2

I already wrote about configuring GoldenGate agent for ODI and Enterprise Manager. Now I would like to talk about configuring it for GoldenGate Monitor. GoldenGate is interesting tool for GoldenGate monitoring. It is more powerful and flexible than GoldenGate plugin for Enterprise Manager but it is still standalone tool not integrated with OEM. So it …

Continue reading ‘Configuring GoldenGate Monitor 12.2’ »