Versions Compared

Old Version 12

changes.mady.by.user user-b885f

Saved on

compared with

New Version 13

changes.mady.by.user user-b885f

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


HTML
<style>
.release-box {
	height: 30px; 
	width: 100px; 
	padding-top: 8px;
	text-align: center; 
	border-radius: 5px; 
	font-weight: bold; 
	background-color: #d4af37;  
	border-color: #FCE28A;
}

.release-box:hover {
  	cursor: hand;
    cursor: pointer;
    opacity: .9; 
}
</style>
<meta name="robots" content="noindex">

<div class="release-box">
<a href="https://docs.perspectium.com/display/gold" style="text-decoration: none; color: #FFFFFF; display: block;">Gold
</a>
</div>



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. 

(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

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.

Prerequisites

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

(warning) You will also need to create a ServiceNow dynamic share/bulk share or create a Salesforce 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:

UI Steps


UI Step

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.


UI Step

Accept the End User License Agreement terms

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


UI Step

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.


UI Step

Choose your Replicator Type

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



UI Step

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.


UI Step

Enter information for connecting to your Snowflake Database

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


UI Step

Finish the agent installer

Follow the steps to install the DataSync for ServiceNow Agent or the DataSync for Salesforce Agent



UI Step

Run your DataSync Agent

Start running your DataSync Agent.





Similar topics

Content by Label
showLabelsfalse
max5
showSpacefalse
sortmodified
cqllabel = "data-sync" and space = currentSpace()

Contact Perspectium Support

US: 1 888 620 8880

UK: 44 208 068 5953

support@perspectium.com