Skip to main content
Control tables

ON THIS PAGE

Control tables

Control Tables provide information about the replication task as well as useful statistics that can be used to plan and manage both the current replication task and future replication tasks. Aside from the Apply Exceptions table which is always created, you can choose which Control Tables to create on the target.

Create target control tables in schema: Enter the endpoint schema for the target Control Tables. If you do not enter any information in this field, then the tables will be created in the default location in the endpoint.

Information note

When this field is left empty, the target endpoint is MySQL, and the Multiple Endpoints option is enabled, a default database named attrep_control will be created on the MySQL server. The selected control tables will be created in this database.

For more information on the Multiple Endpoints option, see Setting general connection properties.

Information note

When replicating to a Hadoop target endpoint, the value specified in this field will be interpreted as a database name (as opposed to a schema name).

Create target control tables in tablespace: When the target endpoint is Oracle, specify the tablespace where you want the target control tables to be created. If you do not enter any information in this field, the tables will be created in the default tablespace in the target database.

Create target control table indexes in tablespace: When the target endpoint is Oracle, specify the tablespace where you want the control table indexes to be created. If you do not enter any information in this field, the indexes will be created in the same tablespace as the control tables.

Replication history time slot (minutes): The length of each time slot in the Replication History table. The default is 5 minutes.

Table selection

In addition to the Apply Exceptions table (required), select which of the following Control Tables you want Qlik Replicate to create on the target endpoint:

  • Replication Status: Provides details about the current task including task status, amount of memory consumed by the task, number of changes not yet applied to the target and the position in the source endpoint from which Qlik Replicate is currently reading.
  • Suspended Tables: Provides a list of suspended tables as well as the reason they were suspended.
  • Replication History: Provides information about the replication history including the number and volume of records processed during a replication task, latency at the end of a CDC task, among others.
  • Change Data Partitions: The attrep_cdc_partitions table contains records of partitions created on the target database when Change Data Partitioning is enabled for a Replicate task. You can use this information to identify partitioned data that needs to be further processed.
  • DDL History: The attrep_ddl_history table contains a history of all supported DDL changes that occurred during a task.

    For a list of DDL changes supported by Replicate, see Supported DDL statements. Note that DDL changes written to this Control Table are also subject to the limitations described in the section in Limitations when Capturing DDL Changes.

    Information note

    The DDL History table is currently supported with the following target endpoints only:

    • Hadoop
    • Hortonworks Data Platform
    • Microsoft Azure HDInsight
    • Amazon EMR
    • Google Dataproc
    • Microsoft Azure Databricks
    • Databricks on AWS

    • Databricks on Google Cloud

      Information note

      The Databricks on Google Cloud endpoint is available from Replicate May 2021 SR3 only.

    • Cloudera Data Platform (CDP) Private Cloud

For a detailed description of these tables, see Control Tables.