Set up temporal data

Access your agent.xml configuration file

Navigate to the directory where you saved your agent.xml file when installing the Replicator Agent.

Add the <temporal> directive

Open your agent.xml file in a text editing application. To use the default configurations for syncing temporal data (columns will be named psp_valid_from and psp_valid_to and the maximum psp_valid_to value will be 9999-01-01 01:01:01), add the <temporal/> self-closing tag anywhere within the <task> tag. An example of this agent.xml is shown below. Otherwise, to create custom configurations for your temporal database, see Step #3.

Example agent.xml for default temporal data configurations:

<?xml version="1.0" encoding="ISO-8859-1" standalone="no"?>
<config>
 <agent>
 <share/>
 <subscribe>
 <task instances="4">
 <task_name>ivan_test_subscribe</task_name>
 <message_connection password="encrypted:vlOtU71yu8N/EFIJH85SSBtaIt7qEEfvqiqft9VZyYE=" queue="psp.out.replicator.ivan_test_2" use_basic_consume="true" user="admin">amqps://us-west-2-dev.perspectium.net</message_connection>
 <instance_connection password="encrypted:vlOtU71yu8N/EFIJH85SSPN9aF0P5/YViVwPEVFcGW4=" user="admin">https://dev66700.service-now.com>
 <handler>com.perspectium.replicator.sql.SQLSubscriber</handler>
 <decryption_key>The cow jumped over the moon and the sun</decryption_key>
 <database_type>mysql</database_type>
 <database_server>localhost</database_server>
 <database_port>3306</database_port>
 <database_user>root</database_user>
 <database_password/>
 <database_parms>characterEncoding=UTF-8 &amp; useSSL=false</database_parms>
 <database_max_column_size>251</database_max_column_size>
 <database>psp_repl</database>
 <temporal/>
 </task>
 </subscribe>
 <max_reads_per_connect>4000</max_reads_per_connect>
 <polling_interval>5</polling_interval>
 <skip_message_set_processing/>
 </agent>
</config>

Create custom configurations (optional)

To customize your temporal database table's maximum date & time stamp in the psp_valid_to column, add the directive shown below within the <temporal> tag, replacing the red text with any value you would like to assign for custom configuration.

<max_datetime>2030-12-31 00:00:00</max_datetime>

NOTE: If records already exist in your temporal database table and then the <maxdatetime> value is changed, any records that were previously timestamped in the psp_valid_to column will not be updated to reflect the newly entered <max_datetime> value.

Save your agent.xml file

Save the changes you made to your agent.xml file and close the file.

Confirm temporal data sharing

Log into the database that your Replicator Agent is sharing data to, and confirm that psp_valid_from and psp_valid_to timestamps are being created and that the psp_valid_to timestamp is updated whenever a change is made to the same record.

NOTE: By default, the primary keys for the subscribed table your database will be a composite key comprised of the sys_id value, from column value, and to column value.