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.
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/bulk share or create a Salesforce 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:
Install and configure your DataSync Agent
Follow the steps to install the DataSync for ServiceNow Agent or the DataSync for Salesforce Agent.
Choose your Replicator Type
On step 4, use the drop down to choose Snowflake Replicator as your Replicator Type.
Enter information for connecting to your Snowflake Database
Enter your Server, User, User Role, password, Warehouse, Database and Schema.
