Prerequisites
First, 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.
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 Preferences > Security & 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.
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:
Type | Description |
---|---|
MySQL | Shares data to a MySQL database. |
MSSQL | Shares data to a Microsoft SQL database. |
Oracle | Shares data to an Oracle database. |
PostgresSQL | Shares data to a PostgresSQL database. |
File DataSync (advanced) | Manually set all the necessary configuration for file subscribing for the Agent in the agent.xml. Contact Perspectium Support for more information. |
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. Contact Perspectium Support for more information. |
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:
Field | Information to enter |
---|---|
Server | Your Perspectium Integration Mesh URL (excluding "http://", "https://", "amqp://", or "amqps://") e.g., <server>.perspectium.net |
User | Username used to connect to the Perspectium Integration Mesh |
Enter Password | Password used to connect to the Perspectium Integration Mesh NOTE: If you don't know or you forgot your Perspectium Integration Mesh server URL, username, and/or password, contact Perspectium Support. |
Retype Password | Password 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 Key | A 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 Reads | A 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:
Field | Information 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 Password | Password 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://") |
Port | Port number for your database |
User | Username used to log into your database |
Enter Password | Password used to log into your database |
Retype Password | Password used to log into your database |
Database | Name 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.
NOTE: Optionally, 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.
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.