The file that controls the configuration settings for Perspectium DataSync Agents is the agent.xml file. This file is automatically created within the Agent's bin directory upon installation. To make changes to the configuration settings for your DataSync Agent, open this agent.xml file in a text editing application and modify the directives described in the sections below.
NOTE: The directives described below are only the essential configurations that must be set for your DataSync Agent. For additional DataSync Agent configuration settings, see the Similar topics list below or browse the topics under DataSync.
Share & subscribe
DataSync Agents can perform two main functions, share and subscribe. To enable these functions, nest one or many of the following directives within the agent.xml's <agent> directive:
| Directive | Description |
|---|---|
| <share> | An Agent configured with <share> functionality (also known as a producer) monitors static data sources and places messages from those sources into queues in the Perspectium Mesh. |
| <subscribe> | An Agent configured with <subscribe> functionality (also known as a consumer) monitors queues in the Perspectium Mesh and processes any messages in those queues, typically by routing those messages to a static data source.
|
Task & handler
The <task> directive defines a specific <share> or <subscribe> function that your DataSync Agent should perform. Multiple <task> directives can be nested within the <share> and <subscribe> directives, and individual configurations can be defined for each <task> by nesting further configuration directives (described in the following sections) within each <task>.
| Directive | Description |
|---|---|
| <task> | Task that handles either sharing or subscribing. You can configure separate settings by defining directives within each <task> directive.
|
| <task_name> | Name for your <task>
|
| <handler> | Name of the Java handler class. In most cases, the value for this directive will be com.perspectium.replicator.sql.SQLSubscriber. |
Message, instance, and schema connection
The <message_connection> and <instance_connection> directives define how your DataSync Agent connects to the Perspectium Mesh and ServiceNow instance, respectively. For your DataSync Agent to connect to your Salesforce organization, you will need to include the <message_connection> and <schema_connection> directives.
| Directive | Required attributes | Description |
|---|---|---|
| <message_connection> | user = Perspectium Mesh username | Perspectium Mesh URL e.g., https://perspectiumtest.perspectium.net |
password = Perspectium Mesh password
| ||
| queue = Perspectium Mesh queue name | ||
| <instance_connection> | user = ServiceNow instance username | ServiceNow instance URL e.g., https://myinstance.service-now.com |
password = ServiceNow instance password
| ||
| <schema_connection> | user = Salesforce org username | Salesforce org URL e.g., https://login.salesforce.com/services/oauth2/token |
password = Salesforce org password
| ||
| client_id = Salesforce Consumer Key for the Perspectium Replicator app | ||
| client_secret = Salesforce Consumer Secret for the Perspectium Replicator app |
Encryption key & decryption key
The <encryption_key> directive is used with <share> tasks to encrypt data that is being shared from a static data source to an application. The <decryption_key> directive is used with <subscribe> tasks to decrypt data that was encrypted by a sharing application. The value for the <encryption_key> directive should match the subscribing application's decryption key, and the value for the <decryption_key> direction should match the sharing application's encryption key.
| Directive | Description |
|---|---|
| <encryption_key> | Encryption key used to encrypt data being shared from a static data source to an application |
| <decryption_key> | Decryption key used to decrypt data being shared from an application |
Database
There are several directives related to your static data source, or database, that the DataSync Agent connects to. For more information on how to configure your database information in the agent.xml configuration file, see Perspectium SQL Replicator Agent Configuration Guide.
| Directive | Description | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| <database_type> | Type of database you are syncing your data to. Supported databases and associated values for the <database_type>:
| ||||||||||||||||||||
| <database_server> | URL for your database. If your database is installed on your local machine, set this value to localhost. | ||||||||||||||||||||
| <database_port> | Port number for your database | ||||||||||||||||||||
| <database_user> | Username used to connect to your database | ||||||||||||||||||||
| <database_password> | Password used to connect to your database | ||||||||||||||||||||
| <database_parms> | (Optional) Can be used to pass additional parameters to the database server during establishment of the connection | ||||||||||||||||||||
| <database> | Name of your database | ||||||||||||||||||||
| <database_sid> | SID used for your Oracle database
|
Example basic agent.xml configuration
The example below shows some of the basic configurations that must be set for a Perspectium DataSync Agent. For additional DataSync Agent configuration settings, see the Similar topics list below or browse the topics under DataSync.
<?xml version="1.0" encoding="ISO-8859-1" standalone="no"?>
<config>
<agent>
<share/>
<subscribe>
<task instances="4">
<task_name>datasyncforservicenow_to_mysql_subscribe</task_name>
<message_connection password="encrypted:vlOtU71yu8N/EFIJH85SSBtaIt7qEEfvqiqft9VZyYE=" queue="psp.out.replicator.dev80972" use_basic_consume="true" user="admin">https://testperspectium.net</message_connection>
<instance_connection password="encrypted:vlOtU71yu8N/EFIJH85SSPN9aF0P5/YViVwPEVFcGW4=" user="test.user">https://myinstance.service-now.com</instance_connection>
<handler>com.perspectium.replicator.sql.SQLSubscriber</handler>
<decryption_key>The cow jumped over the moon</decryption_key>
<database_type>mysql</database_type>
<database_server>localhost</database_server>
<database_port>3306</database_port>
<database_user>root</database_user>
<database_password>encrypted:vlOtU71yu8N/EFIJH85SSMoilKLTeJHQrNZPJ7c5tFU=</database_password>
<database_parms>characterEncoding=UTF-8 & useSSL=false</database_parms>
<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>
