GoldenGate Macros are series of commands, parameters or data conversion functions that may be shared among multiple GoldenGate components.
dirmac/report.mac:
MACRO #report
BEGIN
REPORT ON SUNDAY AT 1:00
END;
dirmac/dbconnect.mac:
MACRO #source_001_connect
BEGIN
SOURCEDB source1db useridalias oggadmin
END;
NOLIST
include ./dirmac/dbconnect.mac
include ./dirmac/report.mac
LIST
To call those macros, you can use #macroname () i.e.:
extract ext01
#source_001_connect ()
#report ()
exttrail ./dirdat/e1
TABLE scott.t1;
- Reporting configuration
- Exception handling
- Managing source/target connections
- Define common table mappings functions
- Oracle GoldenGate 12.1.2 Documentation - Macro
- Loren Penton, Oracle GoldenGate: Using Macros, June 25, 2013
- Sourav Bhattacharya, Oracle GoldenGate Best practices: GoldenGate parameter files, April 6, 2013