Dynamic columns provides the ability to configure one or more columns that will be added for each destination table. For example use Dynamic columns when you want to track the exact time in which a table entry has been made. You can create the desired column using the Dynamic columns feature and then manage the content of the column via the Plugin Framework.
<dynamic_columns>
<dynamic_column column_name="my_column" column_type="93" column_size="255"></dynamic_column>
</dynamic_columns>
The column_name must contain a valid column name per the requirements of the target database type. The column_type must be a valid Java SQL type. The column_size field is required but will only be used when your column type is character oriented.
Example of agent.xml
<?xml version="1.0" encoding="ISO-8859-1" standalone="no"?>
<config>
<agent>
<subscribe>
<task>
<task_name>example_subscribe</task_name>
<message_connection password="encrypt:XXXX" user="XXXX" queue="..." >amqp://example.perspectium.net</message_connection>
<instance_connection password="encrypt:XXXX" user="XXXX">http://example.service-now.com</instance_connection>
<handler>com.perspectium.replicator.sql.SQLSubscriber</handler>
<decryption_key>The cow jumped over the moon</decryption_key>
<database_type>sqlserver</database_type>
<database_server>MyAddress</database_server>
<database_port>1433</database_port>
<database_user>XXXX</database_user>
<database_password>XXXX</database_password>
<database_parms></database_parms>
<database>psp_repl</database>
<dynamic_columns>
<dynamic_column column_name="my_column" column_type="93" column_size="255"></dynamic_column>
</dynamic_columns>
</task>
</subscribe>
<max_reads_per_connect>2000</max_reads_per_connect>
<polling_interval>5</polling_interval>
</agent>
</config>