From the Properties page, click DataSync Settings (Perspectium > Control and Configuration > Properties > DataSync Settings) Your DataSync Settings contain 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. On the DataSync Settings page, you can:
UI Expand |
---|
title | Share display values for reference fields and choice lists |
---|
|
| User for these fields in DataSync settings. When enabled, display value fields that are prefixed with dv_ in the field name will be added to the shared record. This feature is useful if you are sharing tables that do not need to include referenced records. The display value may contain enough readable information for your report. NOTE:
- Display values will NOT be shared in schemas to ServiceNow instances.
- 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 sys_id value in the reference field instead.
- With DataSync Agent, the columns for the display value will be sent to the database as a separate column, e.g. a state column have the numerical value and a dv_state column will have the actual value.
Prerequisites:Instructions:- In your sharing ServiceNow instance, go to Perspectium > Control and Configuration > Properties > DataSync Settings
- Check the box labeled Enable Replicator to add display value fields for reference and choice fields (prefixed with 'dv_' by default)
- Click Save.
Image Added
|
|
UI Expand |
---|
title | Use a percentage of workers to run concurrent scheduled bulk shares |
---|
|
Divbox |
---|
| 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 scheduled jobs (workers). If this happens, a good troubleshooting practice is to specify a percentage of the workers on your ServiceNow instance's nodes that will run scheduled bulk shares concurrently. Prerequisites:Instructions:- In your sharing ServiceNow instance, go to Perspectium > Control and Configuration > Properties > DataSync Settings
- Use the dropdown labeled Percentage of workers used to run concurrent Scheduled Bulk Shares to select your desired percentage
The percentage that you choose from the dropdown will be the percentage of workers in each of your ServiceNow instance's nodes that will be used to run scheduled bulk shares that are being executed concurrently.
- Click Save.
Image Added
|
|
UI Expand |
---|
title | Share display valuesSave Perspectium properties in the sys_properties table |
---|
|
Divbox |
---|
| This option lets you improve the overall performance of your Perspectium integration by saving all properties related to your Perspectium integration to ServiceNow's System Property (sys_properties) table. By default, this option is disabled, and your Perspectium-related properties are saved in the Perspectium Properties table (u_psp_properties). 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. NOTE: Enabling this option will write all of Perspectium's application properties to ServiceNow's sys_properties 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.
Prerequisites:Instructions:- In your sharing ServiceNow instance, go to Perspectium > Control and Configuration > Properties > DataSync Settings.
- Check the box labelled Save Perspectium properties in the sys_properties table.
- Click Save.
It may take 2-3 minutes for this change to be applied to your ServiceNow instance as the system saves all Perspectium properties over to the sys_properties and rebuilds the system cache. NOTE:
- If, after enabling this option, the u_psp_properties table is deleted, you can regenerate the u_psp_properties table by clicking Perspectium > Control and Configuration > Finish Install > Confirm.
- If enabling this option, be sure NOT to enter a value higher than 15000000 for the com.perspectium.output_bytes_limit property or a value higher than 8000 for the com.perspectium.output_row_limit property.
|
|
UI Expand |
---|
title | Disable inbound messages |
---|
|
Divbox |
---|
| By default, DataSync for ServiceNow allows your ServiceNow instance to receive inbound messages. However, if your ServiceNow instance is to be used for sharing purposes only (and not for subscribing purposes, or the receipt of incoming messages from other apps or data sources), you have the option to disable inbound message functionality in DataSync Properties. For more information about message records in ServiceNow, see ServiceNow messages & receipts. Prerequisites:Instructions:- In your sharing ServiceNow instance, go to Perspectium > Control and Configuration > Properties > DataSync Settings.
- Check the box labeled Disable inbound messages.
- Click Save.
Image Added
|
|
UI Expand |
---|
title | Enable multiple jobs to process messages in the inbound table |
---|
|
Divbox |
---|
| By default, the Perspectium Replicator Subscriber 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 (psp_in_message) in a Ready state so that Perspectium Replicator Inbound Processor scheduled jobs process the inbound table. This allows you to prioritize the processing of your inbound messages by configuring the Perspectium Replicator Inbound Processor jobs to apply various filters.
Warning |
---|
This is an advanced capability for DataSync for ServiceNow, 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. |
Prerequisites:Instructions:- In your sharing ServiceNow instance, go to Perspectium > Control and Configuration > Properties > DataSync Settings.
- Check the box labeled Allow Replicator inbound messages to go to a state of ready instead of being consumed immediately...
- Click Save.
- Now, go to Perspectium > Control and Configuration > All Scheduled Jobs.
- In the Schedule Jobs table, find and select the Perspectium Replicator Inbound Processor job.
- Within the script for this job, find the addCustomQuery function on line 50 and modify the script by adding your customer queries.
To do this, choose one of the following options:
- Click Update (top right corner).
- Create a copy of the modified job so you can apply other filters to enable simultaneous processing.
|
|
UI Expand |
---|
title | Skip updating the sys_domain_path field when subscribing to records |
---|
|
Divbox |
---|
| This option will skip updating the sys_domain_path field on a record to keep the value as it currently is or allow the system to update the record appropriately if the domain changes. In domain-separated ServiceNow instances (Helsinki version or later), if you update a record without changing the sys_domain field, the sys_domain_path 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 auto adjust to the proper domain path after updating the record. Prerequisites:Instructions:- In your sharing ServiceNow instance, go to Perspectium > Control and Configuration > Properties > DataSync Settings.
- Check the box labeled skip updating the sys_domain_path field when subscribing to records.
- Click Save.
|
|
UI Expand |
---|
title | Alert before bulk sharing a large number of records |
---|
|
Divbox |
---|
| This option 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. Prerequisites:Instructions:- In your sharing ServiceNow instance, go to Perspectium > Control and Configuration > Properties > DataSync Settings.
- Check the box labeled Alert me before bulk sharing a large number of records.
- Enter the desired minimum number of records in the field labeled Minimum number of records to trigger an alert before bulk sharing.
- Click Save.
Image Added
|
|
UI Expand |
---|
title | Generate unique names for business rules associated with dynamic shares |
---|
|
Divbox |
---|
| This option allows you to change a setting to allow newly created business rules to have a unique name. Upon the initial creation of a dynamic share, you can choose between using Business Rule or Flow Designer. When you choose Business Rule, the dynamic share uses to trigger sharing records out. By default, the business rule created is named Perspectium Replicate. Prerequisites:Instructions:- In your sharing ServiceNow instance, go to Perspectium > Control and Configuration > Properties > DataSync Settings.
- Check the box labeled Generate unique names for the business rules associated with dynamic shares.
|
|
Image Removed
- Click Save.
Image Added
|
|
|