Scripting Guide

9.8.0 HotFix 2

Back Next

Using Tcl Scripts and SQL Expressions in Data Replication

The Data Replication InitialSync and Applier components can process Tcl scripts and SQL expressions that you create to customize load processing.

To use Tcl scripts, you must be familiar with the Tcl scripting language. To use SQL expressions, you must be familiar with the SQL of the target database.

You can create Tcl scripts or SQL expressions for the following data replication purposes:

Customize or convert target column datatypes.

Perform advanced filtering of source data to apply to the target system.

Perform mathematical operations on target data.

Generate customized key values.

Split a source column into multiple target columns.

Perform aggregation functions on target data.

Perform advanced logging during a data replication job.

Execute SQL statements on the target database during a data replication job.

Use a variety of functions for advanced text processing.

Data Replication supports Tcl scripts and SQL expressions for all types of replication jobs, including continuous replication.

Data Replication does not support SQL expressions for

Apache Kafka,

Cloudera,

Hortonworks,

and Flat File

targets.

The Tcl Script Engine and SQL Script Engine do not support LOB data. Do not define Tcl scripts or SQL expressions that process LOB data.

For Audit Apply mappings, the SQL Script Engine can get values only from the mapped source columns.

Rename Saved Search

Table of Contents

Scripting Guide

Scripting Guide

Using Tcl Scripts and SQL Expressions in Data Replication

Using Tcl Scripts and SQL Expressions in Data Replication