Oracle Goldengate - What are MACROS in Oracle Goldengate and usage of MACROS

1 Video View·Sep 4, 2026  #do_colmap

In this session we have discussed regarding Oracle Goldengate Macros OGG Macros
• You can use Oracle GoldenGate macros in parameter files to configure and reuse parameters, commands, and conversion functions. reducing the amount of text you must enter to do common tasks.

• A macro is a built-in automation tool that enables you to call a stored set of processing steps from within the Oracle GoldenGate parameter file.

• A macro can consist of a simple set of frequently used parameter statements to a complex series of parameter substitutions, calculations, or conversions.

• You can call other macros from a macro.

Eg:

macro #do_colmap
params ()
begin
colmap (usedefaults,
Timing = @DATENOW()),
end;

map pdb1.ggtraining1.dept11, target pdb1.ggtraining1.dept22, #do_colmap ();