Qlik Replicate: How to create PRIMARY INDEX rather than PRIMARY KEY in Teradata Target DB

john_wang — Tue, 17 Sep 2024 08:23:30 GMT

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 the target endpoint, Qlik Replicate creates a PRIMARY KEY by default if the source table has the PRIMARY KEY as well. Users want to create a PRIMARY INDEX rather than a PRIMARY KEY in Teradata Target tables.

The below steps demonstrate how to customise the CREATE TABLE behavior.

Environment

Qlik Replicate All supported versions
Teradata All supported versions

Detailed Steps

To achieve this, we will add an Internal Parameter to the Endpoint.

Open Manage Endpoint Connections in the Qlik Replicate console GUI
Go to the Endpoint connection
Switch to the Advanced tab
Click Internal Parameters
Add the following parameter:
```
$info.query_syntax.create_primary_key
```
Add the following value:
```
) PRIMARY INDEX ( ${COLUMN_LIST}
```
For more information about Internal Parameters, see Qlik Replicate: How to set Internal Parameters and what are they for?
Run the task

Internal Investigation ID(s)

00043847

article Qlik Replicate: How to create PRIMARY INDEX rather than PRIMARY KEY in Teradata Target DB in Official Support Articles

Qlik Replicate: How to create PRIMARY INDEX rather than PRIMARY KEY in Teradata Target DB

Environment

Detailed Steps

Related Content

Internal Investigation ID(s)