Update database directives to point to MS SQL ServerOpen your agent.xml file in a text editing application. Then, locate the <task> directive(s) within your <subscribe> directive, and update the following database-related directives: Directive | Value to enter |
---|
<database_type> | sqlserver | <database_server> | URL for your MS SQL Server database. If MS SQL Server is installed locally, enter localhost | <database_port> | 1433 | <database_user> | Username used to access your MS SQL Server database | <database_password> | Password used to access your MS SQL Server database | <database_parms> | loginTimeout=30 NOTE: This is optional, but entering this parameter will force the DataSync Agent to wait for 30 seconds after a connection error before attempting to reconnect to MS SQL Server |
Your agent.xml file should look similar to the example shown below. Code Block |
---|
| <?xml version="1.0" encoding="ISO-8859-1" standalone="no"?>
<config>
<agent>
<share/>
<subscribe>
<task instances="4">
<task_name>test_rc6_subscribe</task_name>
<message_connection password="encrypted:vlOtU71yu8N/EFIJH85SSBtaIt7qEEfvqiqft9VZyYE=" queue="psp.out.test.bnym1" use_basic_consume="true" user="admin">https://us-east-2-bnym.perspectium.net</message_connection>
<instance_connection password="encrypted:vlOtU71yu8N/EFIJH85SSPN9aF0P5/YViVwPEVFcGW4=" user="admin">https://dev74686.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>localhost</database_server>
<database_port>1433</database_port>
<database_user>perspectium</database_user>
<database_password>perspectium123</database_password>
<database_params/>
<database_max_column_size>251</database_max_column_size>
<database>psp_repl</database>
</task>
</subscribe>
<max_reads_per_connect>4000</max_reads_per_connect>
<polling_interval>5</polling_interval>
<skip_message_set_processing/>
</agent>
</config> |
|