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

[john_wang]

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.

1. Open Manage Endpoint Connections in the Qlik Replicate console GUI
2. Go to the Endpoint connection
3. Switch to the Advanced tab
4. Click Internal Parameters 
5. Add the following parameter:
   
   

   $info.query_syntax.create_primary_key

6. 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?
   
   
   
   
7. Run the task

 

Related Content

Another approach: How to custom target endpoint syntax 

Internal Investigation ID(s)

00043847