• Created by user-1bc08, last modified by user-4dac1 on Jun 29, 2021


DataSync for Parquet is a single-direction (ServiceNow to file) integration that leverages bulk shares and allows for replicating table records from a ServiceNow instance to a local file. 


Prerequisites

(warning) You will need to install the Perspectium Core update set in your ServiceNow instance. You can request a download link for this update set by contacting Perspectium Support.


Procedure

To set up a DataSync for Parquet integration, follow these steps:

Create or obtain a queue 

A shared queue should have been created by Perspectium Support upon initial configuration of your ServiceNow instance. 

Otherwise, follow Create a ServiceNow shared queue to create a queue that points to your Parquet. 

Create a ServiceNow bulk/dynamic share for your integration

  1. In ServiceNow's left side navigation window, navigate to Perspectium > Perspectium Core > Shares or simply type and then click on Shares. Then, go to Bulk Share > Create a new bulk share.

  2. In the Name field, type any name for your bulk share. 

  3. Click the dropdown next to Table. Then, search for and choose the table whose data you want to bulk share out.

  4. Click the search icon next to the Target queue field. In the Queues popup, choose the shared queue you created or obtained in the Create or obtain a queue step. 

  5. Choose a method to encrypt the data that will be shared out from the Encryption Method dropdown. (info) NOTE: You will need to specify the encryption method in the meshlet configuration. Contact Perspectium Support for more information.

  6. In the Data Enrichment tab, click the search icon next to Table map. From the resulting list, select the table map you want to add. See ServiceNow Table Maps for more information.

  7. Click Submit.  

For any additional information on setting up your bulk share, see Create a ServiceNow bulk share. 

  1. In ServiceNow's left side navigation window, navigate to Perspectium > Perspectium Core > Shares or simply type and then click on Shares. Then, go to Dynamic Share > Create a new dynamic share.

  2. Select Business Rule or Flow Designer and click the Submit button.

  3. Check the Active box to activate your dynamic share and start sharing out record data dynamically.

  4. Click the dropdown next to Table. Then, search for and choose the table whose data you want to dynamic share out.

  5. Click the search icon next to the Target queue field. In the Queues popup, choose the shared queue you created or obtained in the Create or obtain a queue step. 

  6. Choose a method to encrypt the data that will be shared out from the Encryption Method dropdown. (info) NOTE: You will need to specify the encryption method in the meshlet configuration.  Contact Perspectium Support for more information.

  7. In the Data Enrichment tab, click the search icon next to Table map. From the resulting list, select the table map you want to add. See ServiceNow Table Maps for more information.

  8. Click Submit.  

For any additional information on setting up your bulk share, see Create a ServiceNow dynamic share.

Install and Run the Parquet Meshlet as a Service

Follow the link above to install and run the Parquet meshlet. For additional information on the directives in the meshlet configurations, see Meshlet Configuration for Parquet.