View Source

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.

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: 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

First, you will need to install the DataSync Agent.

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

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 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.

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.

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:

Field	Information to enter
Server	Your Perspectium Integration Mesh URL (excluding "http://", "https://", "amqp://", or "amqps://") e.g., us-east-3-dev.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.

Enter information for connecting to your Snowflake Database

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

Field	Information to enter
Server	URL 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
Password	Password used to access Snowflake
Warehouse	The 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.
Database	The 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.