Tungsten University
TungstenReplicator Master Class
Advanced

Working with OLTP Targets

Learn how to replicate from MySQL into OLTP targets like PostgreSQL and Oracle using Tungsten Replicator, including prerequisites, object mapping, and end-to-end extractor/applier configurations for heterogeneous pipelines.​

This session explains object mapping semantics, how to generate target-specific DDL with DDLScan, and how to configure extractor filters such as replicate.do and .ignore for selective replication​.

You’ll see practical tungsten.ini examples for PostgreSQL and Oracle appliers, required client/JDBC libraries, port and user setup, and considerations for remote versus local extraction, offboard appliers, and secure API defaults in operational environments.

Topics Covered

  • 00:00 Introduction
  • 00:20 Topics
  • 00:40 Replicator Flow
  • 01:40 Prerequisites
  • 03:35 Object Mapping
  • 04:04 DDLScan
  • 05:03 Extractor Config
  • 05:54 Applier Configs
  • 07:30 Demo
  • 15:32 Summary
  • 15:59 Thank you