Another powerful feature of GoldenGate is the SQLEXEC
parameter. We will discuss when and how to use it as a standalone statement or in a TABLE
or MAP
statement to fulfill your data transformation requirements. SQLEXEC
is valid for Extract and Replicat processes and can execute SQL statements or PL/SQL stored procedures.
On the target database, the SQLEXEC
parameter in the MAP
statement allows external calls to be made through a SQL interface that supports the execution of native SQL and PL/SQL stored procedures. This option is typically invoked to perform database lookups, thus obtaining data required to resolve a mapping and can only be executed by the GoldenGate (GGADMIN
) database user.