You can configure your Perspectium DataSync Agent to share data from ServiceNow or Salesforce to a Snowflake database by changing some additional configurations in your agent.xml file

Alternatively, DataSync for Snowflake is available and recommended for sharing data to a Snowflake database.

(info) NOTE:

  • The Snowflake JDBC driver 3.8.0 will come packaged with your Perspectium DataSync Agent in order to address a known issue with use of OSCP for certificate revocation status.
  • The Snowflake auto suspend/resume feature is compatible with your Perspectium DataSync Agent. 
  • Your Snowflake warehouse size dictates the processing power given to the database the DataSync Agent will write to.

(warning) WARNING: If you also using the Snowflake Bulk Load Meshlet to connect to the same database, you will want to configure the Agent to use the same column cases. By default, the Meshlet uses lowercase for the column names. Also, the QUOTED_IDENTIFIERS_IGNORE_CASE setting in Snowflake should be kept with its default value of false.


Prerequisites


(warning) First, you will need to install the DataSync Agent.

(warning) You will also need to create a ServiceNow dynamic share/bulk share.

(warning) Finally, make sure to stop running your DataSync Agent before making any Agent configuration changes.


Procedure

To set up your DataSync Agent to share application data to a Snowflake database, follow these steps:


Open the Agent Installer

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.

Accept the End User License Agreement terms

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

Choose an installation path and JDK/JRE directory

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. On the resulting window, you will be asked to choose the directory where your Java JDK or JRE is installed. In most cases, you can accept the default directory here and then click Next.

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

Choose your DataSync Type

Use the drop down to choose Snowflake DataSync as your DataSync Type.


Enter Perspectium Mesh authentication info

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., us-east-3-dev.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.

Enter information for connecting to your Snowflake Database

Enter your Server, User, User Role, password, Warehouse, Database and Schema.

FieldInformation to enter
ServerURL for your Snowflake database
User

Username used to access Snowflake

User Role

The role this username has to perform actions in your Snowflake data warehouse

PasswordPassword used to access Snowflake
WarehouseThe name of the Snowflake warehouse that your database is in. The warehouse is the top level object that comprises multiple databases that have a schema describing the database and its objects. 
DatabaseThe name of the Snowflake database you want to save records in
Schema

The name of the Snowflake schema for your database. 

Finish the agent installer

Follow the steps to install the Install the DataSync Agent.

Run your DataSync Agent

Start running your DataSync Agent.