You can configure your Perspectium DataSync Agent to share data from ServiceNow or Salesforce to a Snowflake database by making some additional configuration changes to your agent.xml configuration file.
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.
Prerequisites
First, you will need to install a DataSync Agent.
You will also need to create a ServiceNow dynamic share or create a ServiceNow 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:
Install and configure your DataSync Agent
Follow the steps to install the DataSync for ServiceNow Agent or the DataSync for Salesforce Agent and make sure that your agent.xml file is configured correctly.
Access your agent.xml configuration file
Navigate to the directory where you saved your agent.xml file when installing your DataSync Agent.
Add directive(s) for Snowflake
Open your agent.xml file in a text editing application. Then, locate the <task> directive(s) within your <subscribe> directive, and nest the following directive:
| Directive | Description |
|---|---|
| <ensure_table_exists/> | Self-closing tag that runs a check to ensure the Snowflake database table exists |
NOTE: If using a DataSync for ServiceNow Agent, it is also recommended to nest the <use_cache/> directive within each <task> directive for <subscribe>.
Your agent.xml file should look similar to the example shown below.
<?xml version="1.0" encoding="ISO-8859-1" standalone="no"?>
<config>
<agent>
<share/>
<subscribe>
<task instances="4">
<task_name>OnDemandAgent_subscribe</task_name>
<message_connection password="encrypted:vlOtU71yu8N/EFIJH85SSPbQ5/gZDZBSjYcHe6gjfJI=" queue="psp.out.replicator.snowflakeexample" use_basic_consume="true" user="exampleuser">https://exampleperspectium.net</message_connection>
<handler>com.perspectium.replicator.sql.SQLSubscriber</handler>
<decryption_key>The cow jumped over the moon</decryption_key>
<database_type>snowflake</database_type>
<database_server>example.snowflakecomputing.com</database_server>
<database_user>exampleuser</database_user>
<database_password>examplepassword</database_password>
<database_params/>
<database>psp_repl</database>
<use_cache/>
<ensure_table_exists/>
</task>
</subscribe>
<max_reads_per_connect>4000</max_reads_per_connect>
<polling_interval>5</polling_interval>
<skip_message_set_processing/>
</agent>
</config>
Save your agent.xml file
Save the changes you made to your agent.xml file and close the file.
Run your Highly Available DataSync Agent
After configuring your agent.xml file to support your Highly Available DataSync Agent, start running your DataSync Agent again.
