Creating a Table Replication

Table Replication allows users to replicate the data to Therefore™ and use it to create a new referenced table. See our references for further information:

Referenced Tables

Table Replication

Creating a table replication

  1. Open the Therefore™ Solution Designer and expand the Integrations object. Right-click on Table Replications and choose New Database Connection.

  2. Select the Database platform, enter the Server name (or IP address) and the Database name. Then select the type of authentication. For database authentication the user name and password must be specified. Click OK to create the connection.

  3. Right-click on the database connection that you have created and select 'New Table'

  4. Select the Source table from the database. Under Destination table, enter an intuitive name for the replicated table and choose the Primary column for the table. This must be a unique column that does not contain NULL values. Then de-select any columns that you do not want to replicate and click OK to create the replicated table.

    Note:

    The Table Replication polling interval (how often the destination table should be updated from its source table) can be set in the Therefore™ Solution Designer by right-clicking on the Therefore™ object, selecting Settings and then opening Advanced tab. Expand the Table Replication field and enter the value in minutes for the field Replication Polling Interval.

  5. The system is now ready for the creation of referenced tables.