Prerequisites


(warning) First, make sure that the device you are installing the DataSync Agent on meets these basic requirements.

(warning) You will also need to request the Agent Installer from Perspectium Support.

(info) NOTE: Screenshots are for a MySQL database and may change depending on database type.

Procedure

To install the DataSync Agent, follow these steps:


Open the Agent Installer .jar file. If you didn't receive this file, you can request one from Perspectium Support. A pop-up may appear indicating that the Agent Installer file can't be opened because it is from an unidentified developer. If this happens, click OK to close the pop-up and then navigate to System PreferencesSecurity & Privacy. Under the General tab, locate the section beginning with Allow apps downloaded from: and click Open Anyway. Then, click Open in the resulting pop-up to open the Agent Installer wizard.

Check the box to accept the terms of the Perspectium End User License Agreement. Then, click Next.

Choose a directory to install the DataSync Agent files in. If you specify a new directory, that directory will first be created and then populated with the Agent files. Then, click Next.

Choose the directory where your Java JDK/JRE is installed. In most cases, you can use the directory defined in JAVA_HOME. Otherwise, choose the other option and then click Next to specify the JDK/JRE directory you want to use. After you finish choosing the JDK/JRE, click Next.

(info) NOTE: Your JDK/JRE must be version 1.8.0 or higher.

Type a name for your DataSync Agent; e.g., datasyncforservicenow_to_mysql. Then, choose an option from the DataSync Type dropdown:

TypeDescription
MySQLShares data to a MySQL database.
MSSQLShares data to a Microsoft SQL database.
OracleShares data to an Oracle database.
PostgresSQLShares data to a PostgresSQL database.
File DataSync (advanced)

Manually set all the necessary configuration for file subscribing for the Agent in the agent.xml. 

(warning) Contact Perspectium Support for more information. 

<?xml version="1.0" encoding="ISO-8859-1" standalone="no"?>
<config>
	<agent>
		<share/>
		<subscribe>
			<task instances="1">
				<task_name>file_subscribe</task_name>
				<message_connection password="encrypt:perspectium_password" queue="psp.out.replicator.yourqueue" 		use_basic_consume="false" user="perspectium_user">https://perspectium_server</message_connection>
				<instance_connection password="encrypt:perspectium_password" user="perspectium_user">https://yourinstance.service-now.com</instance_connection>
				<decryption_key>decryption_key</decryption_key>
				<handler>com.perspectium.replicator.file.(your_dataformat)Subscriber</handler>
				<files_directory>your_directory_containing_file_of_saved_records</files_directory>
			</task>
		</subscribe>
	</agent>
</config>
Manual Configuration (advanced)

Manually set all the necessary and advance configurations for sharing and subscribing data with the Agent in the agent.xml. See DataSync Agent configuration

(warning) Contact Perspectium Support for more information. 

<?xml version="1.0" encoding="ISO-8859-1" standalone="no"?>
<config>
	<agent>
		<share>
			<task>
				<task_name>yourinstance_share</task_name>
				<message_connection password="encrypt:perspectium_password" queue="psp.out.servicenow.yourinstance" user="perspectium_user">https://perspectium_server</message_connection>
				<encryption_key>decryption_key</encryption_key>
			</task>
		</share>
		<subscribe>
			<task instances="1">
				<task_name>yourinstance_subscribe</task_name>
				<message_connection password="encrypt:perspectium_password" queue="psp.out.replicator.yourqueue" use_basic_consume="false" user="perspectium_user">https://perspectium_server</message_connection>
				<encryption_key>decryption_key</encryption_key>
			</task>
		</subscribe>
	</agent>
</config>

Finally, click Next to proceed to the next step.

On the resulting page, enter the following to allow your DataSync Agent to authenticate when connecting to the Perspectium Integration Mesh:

FieldInformation to enter
Server

Your Perspectium Integration Mesh URL (excluding "http://", "https://", "amqp://", or "amqps://")

e.g., <server>.perspectium.net

UserUsername used to connect to the Perspectium Integration Mesh
Enter Password

Password used to connect to the Perspectium Integration Mesh

(info) NOTE: If you don't know or you forgot your Perspectium Integration Mesh server URL, username, and/or password, contact Perspectium Support.

Retype PasswordPassword used to connect to the Perspectium Integration Mesh
Queue Name

Name of the queue that will store data being shared from your ServiceNow instance to your database. Simply replace the yourqueue text here with the name of your ServiceNow instance; e.g., dev12345

Encryption/Decryption KeyA key of 24+ characters (for base64, TripleDES, and AES-128 encryption) or 32+ characters (for AES-256 encryption), including spaces, which will be used to encrypt data being shared from your ServiceNow instance to your database.
Max ReadsA maximum number of data messages that your DataSync Agent will read from the queue each time messages are processed
Polling Interval (sec)Time period (in seconds) for which your DataSync Agent will process messages from your shared queue

Then, click Next to continue to the next step.

On the resulting page, enter the following information to allow your DataSync Agent to connect to and authenticate with your ServiceNow instance and database server:

FieldInformation to enter
Instance

Your ServiceNow instance URL or ServiceNow FedRAMP URL (excluding "http://" or "https://") 

User

Username used to log into your ServiceNow instance (in firstname.lastname format)

Enter Password

Password used to log into your ServiceNow instance

Retype PasswordPassword used to log into your ServiceNow instance
Server

Server URL for the database you will be sharing your ServiceNow instance data to (excluding "http://" or "https://")

PortPort number for your database
UserUsername used to log into your database
Enter PasswordPassword used to log into your database
Retype PasswordPassword used to log into your database
DatabaseName of your database schema

Then, click Next to continue to the next step.

On the Summary and Review screen, wait for the processes to finish running and then click Next. Then, on the Perform External Processes screen, wait for the processes to complete and then click Next.

Finally, on the Installation Finished screen, click Done to finish installation of your DataSync Agent.

(info) NOTEOptionally, you can Generate an automatic installation script on this screen and then choose a directory to save your install script in. This script can then be run on another device to install a DataSync Agent with the same settings you've specified here.

The following system files will be installed within the bin/perspectium_data directory and used for temporary storage/caching when your DataSync for ServiceNow Agent is running:

  • psp.in.agent.errors
  • psp.in.messageset
  • psp.out.servicenow.INSTANCE_NAME (where INSTANCE_NAME  is from your https://INSTANCE_NAME.service-now.com URL)
  • psp.in.servicenow
  • TableStatsPublisher

A perspectium.log file will also be installed that contains important log messages for your DataSync for ServiceNow Agent. For more information, see monitoring DataSync Agent logs.

(info) NOTE: If the files listed above exceed 1 GB in size, you may delete these files to improve your DataSync Agent performance.

(Optional) After installing your DataSync for ServiceNow Agent, it is highly recommend to confirm that you Agent is configured correctly by running the Agent validateConfiguration tool.

To run the validateConfiguration tool on a Linux device, open a terminal window and change your current directory to the directory where you installed your Agent in Step #3. Then, execute the following command:

bin/validateConfiguration start

To run the validateConfiguration tool on a Windows device, navigate to the bin directory that was installed within the main Agent directory that was specified in Step #3. Then, double-click to run the validateConfiguration.bat file.

The tool will attempt to connect to the Perspectium Integration Mesh, your ServiceNow instance (if configured, to test fetching a schema) and to your database, logging if it was successful making these connections or any failures that may occur. Contact support@perspectium.com if you have questions on the connection failures.

Next steps


Start or stop the DataSync Agent