The Perspectium ETS Agent processes batches of replicated table data from a ServiceNow instance and writes it to a relational database such as MYSQL or Oracle.
The agent has the same requirements as the Replicator Agent as noted here.
To configure the agent, run setup.sh (Linux) or setup.bat (Windows) located in <agent_installed_directory>/bin. The agent's configuration file is located in <agent_installed_directory>/conf/agent.properties. The service wrapper configuration is located in <agent_installed_directory>/conf/wrapper.conf. The setup script updates the necessary properties in both of these files.
The following configurations are available for the agent:
Configuration information for connecting to Perspectium MBS as provided by Perspectium:
|mbs_url||URL of the Perspectium MBS server||Required|
|mbs_user||Username for the Perspectium MBS server||Required|
|mbs_password||Password for the Perspectium MBS server||Required|
|mbs_queue||Queue on the Perspectium MBS server to read messages from||Required|
The mbs_queue must start with the name of the ServiceNow instance that the messages are coming from. For example if the messages were shared from dev24440.service-now.com the queue would look like: dev24440.psp.out.replicator.example_queue
Configuration information for the database the agent will be integrating with:
|db_type||Database type (mysql or oracle)||Required|
|db_port||Database port number||Required|
|db_name||Database schema name||Required|
|db_password||Password for database user||Required|
The ETS Agent supports optionally using an HTTP/HTTPS proxy for the agent to connect outside the network to MBS.
|proxy_url||URL of the proxy server to connect to.||Optional|
|proxy_user||Username for the proxy server.||Optional|
|proxy_password||Password for the proxy server.||Optional|
|decryption_key||Key string used to decrypt messages||Required|
|sleep_milliseconds||Polling interval in milliseconds||Required|
#Perspectium ETS Agent Configuration File # To encrypt property values such as passwords, prefix the value with encrypt: #MBS Configuration mbs_url=http://localhost:8080/bulkout mbs_user=username mbs_password=password mbs_queue=queue_name #Database Configuration #db_type=mysql|oracle db_type=mysql db_host=localhost db_port=3306 db_name=database_name db_user=username db_password=password #Batch Configuration decryption_key=The cow jumped over the moon sleep_milliseconds=5000
The ETS Agent runs by executing scripts in the <agent_installed_directory>/bin directory. It can be run in the console or installed as a Windows service or Linux Daemon.