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://") |
| User | Username used to connect to the Perspectium Integration Mesh |
| Enter Password | Password used to connect to the Perspectium Integration Mesh
|
| 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.