Sometimes the target default endpoint behavior does not meet our needs. This article is useful if we want to modify the default syntax.
For example while Teradata is target endpoint, Replicate creates PRIMARY KEY by default if the source table has the PRIMARY KEY as well. User want to create PRIMARY INDEX rather than PRIMARY KEY in Teradata Target tables.
The below steps demonstrate how to custom the CREATE TABLE behavior.
Environment
- Qlik Replicate All supported versions
- Teradata All supported versions
Detailed Steps:
1. Open "Manage Endpoint Connections" in Replicate console GUI
2. Go endpoint "Advanced" tab and add "Internal Parameter"
The internal parameter name is:
$info.query_syntax.create_primary_key
press enter after the input, it will appear in the below Parameter-Value matrix.
4. Assign the above parameter value as:
) PRIMARY INDEX ( ${COLUMN_LIST}
The screencopy looks like:
5. Run the task.
Related Content
Another approach : How to custom target endpoint syntax
Support case # 00043847
Qlik Replicate