The procedures described in this documentation are best practices for setting up Perspectium DataSync for the typical use cases when sharing data from your ServiceNow instance to target databases and files.
For other ways to get started with DataSync, click here or contact Perspectium Support.
First, request for the downloadable link for Perspectium for ServiceNow application.
Make sure that the device you are installing the DataSync Agent on meets these basic requirements.
You will also need to request the Agent Installer from Perspectium Support.
You will need the following information from Perspectium Support:
To install the Perspectium Application for ServiceNow you need to have admin access to the ServiceNow instance and should have received the update set from Perspectium Support which will be imported, validated and committed during installation. You can follow these steps to install in ServiceNow:
Once installation is finished you need set up some initial configurations:
In order to share data to the Perspectium Integration Mesh (Message Broker Service aka MBS) you need to configure at least one shared queue since MBS is queue based. This queue will be used by the ServiceNow instance to share records while the DataSync Agent will subscribe to the same queue in order to be able to receive records, decrypt the shared content and issue the necessary SQL queries to populate those records into the target database.
The Perspectium DataSync Agent can be installed both on Windows or Linux machines. Before installing consulting with this article for minimum requirements.
The virtual machine where you will be installing the agent needs to have connectivity to:
Make sure the necessary network connectivity exists and the needed firewall rules are set properly before you start the installation.
Once you start the installation package perform the following steps:
The IO Datetime plugin allows the DataSync agent to add additional columns to the synchronized tables to specify the timestamps of when those records were first inserted, last updated or deleted into the database. As opposed to the usual ServiceNow sys_updated, sys_created_on which keep the date and time when those transactions happened in ServiceNow the IO Datetime plugin columns keep the timestamps of the database transactions triggered by the agent. This plugin can be activated by adding the following lines to the agent.xml within the <task> directive:
<!-- Create the columns --> <dynamic_columns> <dynamic_column column_type="93" column_size="32" deletes_only="true">psp_per_delete_dt</dynamic_column> <dynamic_column column_type="93" column_size="32" updates_only="true">psp_per_update_dt</dynamic_column> <dynamic_column column_type="93" column_size="32" inserts_only="true">psp_per_insert_dt</dynamic_column> </dynamic_columns> <!-- Update the columns --> <plugins> <plugin insert_column="psp_per_insert_dt" update_column="psp_per_update_dt" delete_column="psp_per_delete_dt">com.perspectium.replicator.sql.plugin.SQLSubscriberIODateTimePlugin</plugin> </plugins> |