Table Replication

Table replication was created particularly for Therefore™ Online users, or Therefore™ systems where the Therefore™ server does not have direct access to the database server. It allows users to replicate the data to Therefore™ and use it to create a new referenced table. Table replication is found in the Therefore™ Solution Designer, under the 'Replication/Syncrhonization' node in Integrations.

Two connections are required in order for the table replication to function:

  • The Therefore™ Replication Service needs access to the database. The Therefore™ Replication Service must be installed and running on the source database or alternatively, a client or workstation that has constant access to the source database.

  • Secondly, it needs access to Therefore™.

In addition the Windows account used to start the Therefore™ Solution Designer requires connection rights to the external database.

A right-click on the object opens a context menu.

New Database Connection
Opens the Database Connection Settings dialog to create a new replication.

Database platform
The database platform where the database that is going to be replicated is created.

Server name
The name of the server where the database platform is installed.

Database name
The name of the database.

Authentication
Either Windows Authentication or Database Authentication can be used. If Windows authentication is used, the user must have at least following permissions on the database: connect, create table, insert, update and delete. If database authentication is used, a user name and password must be provided.

Set Account

See the connection requirements above for details on what authentication settings should be used and for details on how and when to use Set 'Account'

Note:

The 'Set Account' setting is grayed out in the case that the user running the Therefore™ Solution Designer does not have enough permissions to write to HKEY_LOCAL_MACHINE in the registry. The account of the Replication Service must also have local administrator privileges.

Security
View and edit role-based access for anything below this node.
Tutorials: Role-based access

Supported Column types

Only the following column types are supported for Therefore™ Table Replication.

SQL Server:
Varchar, Char, Text, NText, NChar, NVarchar, Int1, Int2, Int4, Int8, DateTime, Datetime4, Float4, Float8, Decimal, Numeric, Money, Money4.

Oracle
Varchar2, Char, NVarchar2, Nchar, Number, Timestamp, Clob, Nclob, Date.