---
title: "DataSync Settings"
canonical: "https://docs.perspectium.com/space/Iodine/1704275/DataSync%20Settings"
format: markdown
---
> Macro (anchor)



Access the DataSync for ServiceNow **DataSync Settings **page at **Perspectium** >** Control and Configuration** >** Properties** > **DataSync Settings**.

Please note that the following settings are only available once you have [installed and configured DataSync for ServiceNow](https://docs-perspectium.atlassian.net/wiki/display/iodine/Install+and+Configure+DataSync+for+ServiceNow). 

Your **DataSync Settings **page contains the default encryption and decryption keys that are used for shared and subscribed data, as well as various configuration options for your bulk shares and inbound messages. Here are the settings you can change from this page:

> Macro (panel)
> 
> > Macro (toc)


---


# Share display values for reference fields and choice lists

[Display values](https://docs.servicenow.com/bundle/quebec-platform-administration/page/administer/field-administration/concept/c_DisplayValues.html)<span style="color: #000000"> </span><span style="color: #000000">are resolved display values of referenced records in the current record being shared. By default, ServiceNow display values for</span><span style="color: #000000"> </span>reference fields<span style="color: #000000"> </span><span style="color: #000000">and</span><span style="color: #000000"> </span>choice lists<span style="color: #000000"> </span><span style="color: #000000">will not be shared out in your</span><span style="color: #000000"> </span>[dynamic shares](https://docs-perspectium.atlassian.net/wiki/display/iodine/Dynamic+Share)<span style="color: #000000"> </span><span style="color: #000000">and</span><span style="color: #000000"> </span>[bulk shares](https://docs-perspectium.atlassian.net/wiki/display/iodine/Bulk+Share)<span style="color: #000000">. You can change this setting in order to enable the sharing of display values for these fields.</span>

<span style="color: #000000">This feature is useful if you're sharing tables that do not need to include referenced records. The display value may contain enough readable information for your report.</span>

<span style="color: #000000">Here's how to change the setting:</span>

1. In your sharing ServiceNow instance, go to **Perspectium** >** Control and Configuration** >** Properties** > **DataSync Settings**.
2. To enable this feature, turn on the toggle under **Enable DataSync to add display value fields for reference and choice fields (prefixed with 'dv_' by default)**
3. Scroll to the bottom and click **Save**.

> ℹ️ **Notes:**
> ℹ️ 
> ℹ️ - <span style="color: #000000">Display values will NOT be shared in schemas to ServiceNow instances.</span>
> ℹ️ - <span style="color: #000000">Display values do not ensure referential integrity when used to join with other tables. To ensure accurate joining between tables, always rely on the actual </span>**<span style="color: #000000">sys_id</span>**<span style="color: #000000"> value in the reference field instead.</span>
> ℹ️ - <span style="color: #172b4d">With</span><span style="color: #172b4d"> </span>[<span style="color: #000000">DataSync Agent</span>](https://docs-perspectium.atlassian.net/wiki/display/iodine/DataSync+Agent)<span style="color: #172b4d">, the columns for the display value will be sent to the database as a separate column, e.g. a </span>**<span style="color: #172b4d">state </span>**<span style="color: #172b4d">column have the numerical value and a </span>**<span style="color: #172b4d">dv_state</span>**<span style="color: #172b4d"> </span><span style="color: #172b4d">column will have the actual value.</span>

[↑ Go to top of page](#DataSyncSettings-TOP)


---


# Use a percentage of workers to run concurrent scheduled bulk shares

<span style="color: #000000">In some cases, you may find that scheduled bulk shares are impacting the performance of your ServiceNow instance, as they use too many of the instance's available</span><span style="color: #000000"> </span>[scheduled jobs](https://docs.servicenow.com/bundle/paris-platform-administration/page/administer/reference-pages/concept/c_ScheduledJobs.html)<span style="color: #000000"> (workers). If this happens, a good troubleshooting practice is to specify a </span>percentage of the workers<span style="color: #000000"> on your ServiceNow instance's nodes that will </span>run scheduled bulk shares concurrently<span style="color: #000000">. Here's how:</span>

1. In your sharing ServiceNow instance, go to **Perspectium** >** Control and Configuration** >** Properties** > **DataSync Settings**.
2. Use the dropdown labeled **Percentage of workers used to run concurrent Scheduled Bulk Shares **to select your desired percentage.
3. Click **Save**.



[↑ Go to top of page](#DataSyncSettings-TOP)


---


# Save Perspectium properties in the sys_properties table

<span style="color: #000000">This feature lets you improve the overall performance of your Perspectium integration by saving all properties related to your Perspectium integration to ServiceNow's</span><span style="color: #000000"> </span>[System Property](https://docs.servicenow.com/bundle/madrid-platform-administration/page/administer/reference-pages/reference/r_AvailableSystemProperties.html)<span style="color: #000000"> </span><span style="color: #000000">(</span>**sys_properties**<span style="color: #000000">) table. By default, this option is disabled, and your Perspectium-related properties are saved in the Perspectium Properties table (</span>**u_psp_properties**<span style="color: #000000">)</span>**.**<span style="color: #000000"> </span><span style="color: #000000">If you enable this option and then make changes to your Perspectium properties, you can then copy those properties to the Perspectium Properties table by disabling this option again.</span>

Here's how:

1. In your sharing ServiceNow instance, go to **Perspectium** >** Control and Configuration** >** Properties** > **DataSync Settings**.
2. <span style="color: #000000">To enable this feature, turn on the toggle under </span>**<span style="color: #000000">Save Perspectium properties in the sys_properties table</span>**<span style="color: #000000">.</span>
3. Click **Save**. It may take 2-3 minutes for this change to be applied to your instance, as the system saved all Perspectium properties over to the **sys_properties **and rebuilds the system cache.

> ℹ️ **Notes:**
> ℹ️ 
> ℹ️ - <span style="color: #000000">Enabling this feature will write all of Perspectium's application properties to ServiceNow's </span>**sys_properties**<span style="color: #000000"> </span><span style="color: #000000">table. The application will then use this table to access all of its properties, increasing the frequency of access to this table and its caching. Please disable this option if you run into issues.  </span>
> ℹ️ - <span style="color: #000000">If, after enabling this option, the </span>**<span style="color: #000000">u_psp_properties</span>**<span style="color: #000000"> </span><span style="color: #000000">table is deleted, you can regenerate the </span>**<span style="color: #000000">u_psp_properties</span>**<span style="color: #000000"> </span><span style="color: #000000">table at </span>**<span style="color: #000000">Perspectium</span>****<span style="color: #000000"> </span>**<span style="color: #000000">></span>**<span style="color: #000000"> </span>****<span style="color: #000000">Control and Configuration</span>****<span style="color: #000000"> </span>**<span style="color: #000000">></span>**<span style="color: #000000"> </span>****<span style="color: #000000">Finish Install</span>****<span style="color: #000000"> </span>**<span style="color: #000000">></span>**<span style="color: #000000"> </span>****<span style="color: #000000">Confirm</span>**<span style="color: #000000">.</span>
> ℹ️ - <span style="color: #000000">If enabling this option, be sure NOT to enter a value higher than 15000000 for the </span>**<span style="color: #000000">com.perspectium.output_bytes_limit</span>**<span style="color: #000000"> </span><span style="color: #000000">property or a value higher than </span>**<span style="color: #000000">800</span>****<span style="color: #000000">0</span>**<span style="color: #000000"> </span><span style="color: #000000">for the </span>**<span style="color: #000000">com.perspectium.output_row_limit</span>**<span style="color: #000000"> </span><span style="color: #000000">property.</span>

[↑ Go to top of page](#DataSyncSettings-TOP)


---


# Disable inbound messages

<span style="color: #000000">By default, DataSync for ServiceNow allows your ServiceNow instance to receive inbound messages. However, if your ServiceNow instance is to be used for</span><span style="color: #000000"> </span>**sharing**<span style="color: #000000"> </span><span style="color: #000000">purposes only (and not for </span>**subscribing**<span style="color: #000000"> </span><span style="color: #000000">purposes, or the receipt of incoming messages from other apps or data sources), you have the option to disable inbound message functionality. Here's how:</span>

1. In your sharing ServiceNow instance, go to **Perspectium** >** Control and Configuration** >** Properties** > **DataSync Settings**.
2. <span style="color: #000000">To enable this feature, turn on the toggle under </span>**<span style="color: #000000">Disable inbound messages</span>**<span style="color: #000000">.</span>
3. Click **Save**.


[↑ Go to top of page](#DataSyncSettings-Topofpage)


---


# Enable multiple jobs to process messages in the inbound table

<span style="color: #000000">By default, the </span>**Perspectium ****DataSync**** Subscriber**<span style="color: #000000"> scheduled job in ServiceNow pulls and processes the messages from your Mesh server's inbound queues. However, you can also have the job pull messages into the ServiceNow inbound table (</span>**<span style="color: #000000">psp_in_message</span>**<span style="color: #000000">) in a</span><span style="color: #000000"> </span>**<span style="color: #000000">Ready</span>**<span style="color: #000000"> </span><span style="color: #000000">state so that </span>**<span style="color: #000000">Perspectium Inbound Processor </span>**<span style="color: #000000">scheduled jobs process the inbound table. This allows you to prioritize the processing of your inbound messages by configuring the </span>**<span style="color: #000000">Perspectium Inbound Processor </span>**<span style="color: #000000">jobs to apply various filters. </span>

> ❌ <span style="color: #000000">This is an advanced capability for </span><span style="color: #000000">DataSync for ServiceNow,</span><span style="color: #000000"> so we recommend you enable this functionality in your test environment(s) first. Note that enabling multiple inbound processor jobs allows you to have greater control over how and when you are subscribing to data that is being shared out by other data sources/applications.</span>

<span style="color: #000000">Here's how to enable this feature:</span>

1. In your sharing ServiceNow instance, go to **Perspectium** >** Control and Configuration** >** Properties** > **DataSync Settings**.
2. To enable this feature, turn on the toggle under **Allow DataSync inbound messages to go to a state of ready isntead of being consumed immediately...**
3. Click **Save**.
4. Now, go to **Perspectium** >** Control and Configuration** > **All Scheduled Jobs**.
5. In the **Schedule Jobs **table, find and select the **Perspectium Inbound Processor **job.
6. <span style="color: #000000">Within the script for this job, find the </span>**<span style="color: #000000">addCustomQuery</span>**<span style="color: #000000"> function on line 50 and modify the script by adding your customer queries.</span>  
  
<span style="color: #000000">To do this, choose one of the following options:</span>  
  
**<span style="color: #000000">Add customer queries by key:</span>**
  <span style="color: #000000">OR</span>  
  
**<span style="color: #000000">Add customer queries by name:</span>**
7. Click **Update **(top right)
8. Create a copy of the modified job so you can apply other filters to enable simultaneous processing.


[↑ Go to top of page](#DataSyncSettings-TOP)


---


# Skip updating the sys_domain_path field when subscribing to records

<span style="color: #000000">This feature allows you to </span><span style="color: #000000">skip</span><span style="color: #000000"> </span><span style="color: #000000">updating</span><span style="color: #000000"> the </span>**<span style="color: #000000">sys</span>****<span style="color: #000000">_</span>****<span style="color: #000000">domain</span>****<span style="color: #000000">_</span>****<span style="color: #000000">path</span>**<span style="color: #000000"> </span><span style="color: #000000">field</span><span style="color: #000000"> on a record to keep the value as it currently is, or allow the system to update the record appropriately if the </span><span style="color: #000000">domain</span><span style="color: #000000"> changes. </span><span style="color: #000000">In</span><span style="color: #000000"> </span><span style="color: #000000">domain</span><span style="color: #000000">-separated ServiceNow instances (Helsinki version or later), if you update a record without changing the</span><span style="color: #000000"> </span><span style="color: #000000">**sys**</span><span style="color: #000000">**_**</span><span style="color: #000000">**domain**</span><span style="color: #000000"> </span><span style="color: #000000">field</span><span style="color: #000000">, the</span><span style="color: #000000"> </span><span style="color: #000000">**sys**</span><span style="color: #000000">**_**</span><span style="color: #000000">**domain**</span><span style="color: #000000">**_**</span><span style="color: #000000">**path**</span><span style="color: #000000"> </span><span style="color: #000000">will be updated to the default global value of “/” that comes in with the incoming record. Prior to the ServiceNow Helsinki release, the system would instead auto adjust to the proper</span><span style="color: #000000"> </span><span style="color: #000000">domain</span><span style="color: #000000"> </span><span style="color: #000000">path </span><span style="color: #000000">after</span><span style="color: #000000"> </span><span style="color: #000000">updating</span><span style="color: #000000"> </span><span style="color: #000000">the record.</span>

<span style="color: #000000">Here's how to enable this feature:</span>

1. First, you must [request domain separation](https://docs.servicenow.com/bundle/madrid-platform-administration/page/administer/company-and-domain-separation/task/t_ActivateDomainSeparation.html#t_ActivateDomainSeparation)<span style="color: #000000"> </span><span style="color: #000000">for your subscribing (Helsinki version or later) ServiceNow instance.</span>
2. In your sharing ServiceNow instance, go to **Perspectium** >** Control and Configuration** >** Properties** > **DataSync Settings**.
3. <span style="color: #000000">To enable this feature, turn on the toggle under</span><span style="color: #000000"> </span>**<span style="color: #000000">skip updating the sys_domain_path field when subscribing to records</span>**<span style="color: #000000">.</span>
4. Click **Save**.


[↑ Go to top of page](#DataSyncSettings-Topofpage)


---


# Alert before bulk sharing a large number of records

<span style="color: #000000">This feature will enable an alert to pop up within your instance whenever a ServiceNow bulk share that you're trying to execute exceeds a minimum number of records. By default, the minimum number of records to trigger an alert is 1,000,000. Here's how to turn on that alert:</span>

1. In your sharing ServiceNow instance, go to **Perspectium** >** Control and Configuration** >** Properties** > **DataSync Settings**.
2. <span style="color: #000000">To enable this feature, turn on the toggle under</span><span style="color: #000000"> </span>**<span style="color: #000000">Alert me before bulk sharing a large number of records</span>**<span style="color: #000000">.</span>
3. Enter the desired minimum number of records in the field labeled **Minimum number of records to trigger an alert before bulk sharing**.
4. Click **Save**.


[↑ Go to top of page](#DataSyncSettings-TOP)


---


# Generate unique names for business rules associated with dynamic shares

<span style="color: #000000">This feature allows you to allow newly created </span>[<span style="color: #000000">business rules</span>](https://docs.servicenow.com/bundle/orlando-application-development/page/script/business-rules/concept/c_BusinessRules.html)<span style="color: #000000"> to have a unique name. By default, the business rule created is named</span>**<span style="color: #000000"> Perspectium Replicate</span>**<span style="color: #000000">.</span>

1. In your sharing ServiceNow instance, go to **Perspectium** >** Control and Configuration** >** Properties** > **DataSync Settings**.
2. <span style="color: #000000">To enable this feature, turn on the toggle under</span><span style="color: #000000"> </span>**<span style="color: #000000">Generate unique names for the business rules associated with dynamic shares</span>**<span style="color: #000000">.</span>
3. Click **Save**.


[↑ Go to top of page](#DataSyncSettings-TOP)


---


# Set receipt tracking

Perspectium's receipt (u_psp_receipt) table as used for [Data Guarantee](https://docs-perspectium.atlassian.net/wiki/spaces/Iodine/pages/1704353) in ServiceNow is rotated to preserve your instance performance. See [ServiceNow Table Rotation](https://docs.servicenow.com/bundle/rome-platform-administration/page/administer/platform-performance/concept/c_TableRotation.html) for more information. 

To configure how often the receipt table is rotated, follow these steps: 

1. Go to **Perspectium** >** Control and Configuration** >** Properties** > **DataSync Settings**.
2. Scroll to the input labeled **<span style="color: #2e2e2e">The number of days to keep message receipts before being deleted... </span>**<span style="color: #2e2e2e"> </span>  
:info:<span style="color: #2e2e2e"> </span>**<span style="color: #2e2e2e">NOTE</span>**<span style="color: #2e2e2e">: This applies to messages in any state (success, pending, error). The number of days must be less than 100.</span>
3. Enter the number days you want to keep the records in the receipt table.
4. Below the property is <span style="color: #2e2e2e">**The number of rotations of deleted data to keep before being overwritten...**</span>  
:info:<span style="color: #2e2e2e">** NOTE: **</span><span style="color: #2e2e2e">If you enter 10, there will be 10 rotations of deleted data before the first instance is overwritten. The number must be less than 100.</span>
5. Enter the number of rotations.
6. Click **Save**.

> Macro (ui-text-box)
> 
> To see other receipt configurations, go to [Receipts](https://docs-perspectium.atlassian.net/wiki/spaces/Iodine/pages/1704341).


[↑ Go to top of page](#DataSyncSettings-TOP)


> Macro (__confluenceADFMigrationUnsupportedContentInternalExtension__)