Page History
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.
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 DataSync 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
First, you will need to install a DataSync Agent 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:
UI Steps | ||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Similar topics
Content by Label | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|