Once you have installed and configured DataSync for ServiceNow, and have successfully set up a bulk share and understand how it works, there are various bulk share settings you can configure. These optional features can help you customize your DataSync experience and leverage DataSync's robust capabilities to make your organization's integration processes more powerful and streamlined.

What's on this page?

Explore all of these available features below! 




Bulk share history set data

This feature allows you to share history set data for the table that you are bulk sharing. History sets in ServiceNow identify which particular records from an audited table contain historical information. History set records only contain a recent subset of historical information (within the past 30 days of inactivity). The following fields will be visible to you in list view for history sets:

Field

Description

IDAn identifier for the record whose history is being recorded
TableThe audited table for the record whose history is being recorded
Load TimeThe amount of time it took to generate the history set

For more information about ServiceNow history sets, see history sets and differences between audit and history sets

Here's how to enable the sharing of history set data for a bulk share:

  1. In your sharing ServiceNow instance, go to Perspectium > Perspectium Core Shares > Bulk Share > View Bulk Shares.

  2. Find and click into the bulk share (the clickable timestamp) that you want to share the history set data for.

  3. In the resulting bulk share page, click the Miscellaneous tab, and check the Include history set box.

  4. Click Update

With DataSync Agent, this option will create a sys_history_xxx table on the target database. 

↑ Go to top of page




Clone a bulk share

This feature allows you to simply clone an existing bulk share or clone and immediately run an existing bulk share. 

  1. In your sharing ServiceNow instance, go to Perspectium > Perspectium Core Shares > Bulk Share > View Bulk Shares.

  2. Find and click into the bulk share (the clickable timestamp) that you want to clone.

  3. In the resulting bulk share page, scroll down to the Related Links section, and click Clone bulk configuration to create a duplicate of the current bulk share, or click Clone and run bulk share to create a duplicate of the current bulk share and then immediately execute the newly duplicated share. 


↑ Go to top of page




Preview a bulk share

This feature allows you to preview a bulk share before executing it. You can see how many records will be shared out and details about when the shared records were created.

What details will display on the preview page? (click to reveal)
  • The number of records that will be shared from the selected table.

  • If include attachments is selected, an estimate on the number of attachment records that will be shared. This will be the combined total of both sys_attachment and sys_attachment_doc records since both tables are required to re-construct attachments when replicating.

  • If include journal fields is selected, an estimate on the number of sys_journal_field records that will be shared.

  • If include audit log is selected, an estimate on the number of sys_audit records that will be shared.

  • A trend chart showing a monthly breakdown of when records were created in the selected table in the last 12 months.

  • If include all child tables is selected, the number of child records will be shared. 


Here's how to preview a bulk share:

  1. In your sharing ServiceNow instance, go to Perspectium > Perspectium Core Shares > Bulk Share > View Bulk Shares.

  2. Find and click into the bulk share (the clickable timestamp) that you want to preview.

  3. In the resulting bulk share page, scroll down to the Related Links section, and click Preview.

  4. On the resulting preview page, you'll see a the number of records to be shared, and a graph showing when the records were created. Click the menu icon (≡) if you want to download the graph. Click Back to Bulk Share to return to the bulk share record. 


↑ Go to top of page




Run a bulk share as another user

This feature allows you to run a bulk share as another user, rather than the default system user that has access to all of the table's records. This feature can be useful when you want to limit the bulk share to a subset of data that certain users have access to, such as records in one domain in your domain separated instance.

Here's how to enable this feature:

  1. In your sharing ServiceNow instance, go to Perspectium > Perspectium Core Shares > Bulk Share > View Bulk Shares.

  2. Find and click into the bulk share (the clickable timestamp) that you want to run as another user.

  3. In the resulting bulk share page, click the Miscellaneous tab, and click the search icon (magnifying glass) next to the Run as field.

  4. Choose the user to run as for your bulk share. 

  5. Click Update




Run a bulk share again

This feature allows you to run an existing bulk share again, once it has a status of Completed. You may want to run the same bulk share multiple times if your intent is to migrate the same table data intermittently. 

Here's how:

  1. In your sharing ServiceNow instance, go to Perspectium > Perspectium Core Shares > Bulk Share > View Bulk Shares.

  2. Find and click into the bulk share (the clickable timestamp) that you want to run again. It must have a Completed status.

  3. In the resulting bulk share page, click Execute Again in the top right corner.


↑ Go to top of page




Bulk share only sys_id listed

This feature allows you to bulk share out only the sys_ids for specific records. This is useful for when you don't want to create filters for a bulk share. 

Here's how:

  1. In your sharing ServiceNow instance, go to Perspectium > Perspectium Core Shares > Bulk Share > View Bulk Shares.

  2. Find and click into the bulk share (the clickable timestamp) for which you want to share only the sys_ids on specific records.

  3. In the resulting bulk share page, click the Data Enrichment tab, and check the Share only Sys IDs listed box.

  4. Then, scroll down and click the Sys IDs tab. This tab will only appear once you check the box from Step 3. 



  5. In the Sys IDs tab, click NewIf using Google Chrome, you may see a popup asking if you want to leave the site—click Leave.

  6. On the resulting page, type the sys_id for the first record you want to bulk share out in the Record Sys ID field.

  7. Click Submit.

  8. (Optional!) Repeat steps 5-7 for any other record sys_ids you want to bulk share out.

  9. Once you've added all sys_ids, click Update.


↑ Go to top of page




Share database views with bulk share

This feature allows you to properly share database views with a bulk share. By default, bulk shares run by querying for records from the selected table in 1,000 record increments, with records ordered by sys_id in ascending order. This is done to minimize performance impact on the ServiceNow instance. However, the records of database views do not have sys_ids and therefore cannot be shared in the same way. In order to properly share database views with a bulk share, you need to query for all records from the view at once.

To do this, you need to specify the glide.db.max_view_records integer system property to a number above the records in your view. If this property is not set, it defaults to 10,000. A good number to use is 999,999.


↑ Go to top of page




Limit the number of records shared

This feature allows you to limit the number of records shared once bulk share reaches a specific limit. 

Here's how to turn it on:

  1. In your sharing ServiceNow instance, go to Perspectium > Perspectium Core Shares > Bulk Share > View Bulk Shares.

  2. Find and click into the bulk share (the clickable timestamp) that you want to limit the number of records shared on.

  3. In the resulting bulk share page, click the Runtime Settings tab, scroll to the Runtime Behavior section, and enter your desired record limit number in the Limit number of records shared field.

  4. Then, scroll down and click the Sys IDs tab. This tab will only appear once you check the box from Step 3. 

  5. Click Update.


↑ Go to top of page




Share updates since then

This feature allows you to share only records that have been inserted or updated since the last time the bulk share ran. This is useful for Scheduled Bulk Shares when you want to ensure you capture all records changed since the last execution of the bulk share.

Here's how to turn it on:

  1. In your sharing ServiceNow instance, go to Perspectium > Perspectium Core Shares > Bulk Share > View Bulk Shares.

  2. Find and click into the bulk share (the clickable timestamp) that you want to configure.

  3. In the resulting bulk share page, click the Runtime Settings tab, scroll to the Triggers section, and check the Share updates since then box.

  4. Click Update.


↑ Go to top of page




Share as archive

This feature will share archived records as regular table records as part of a bulk share, if and when there is an archived table for a specified table in the bulk share. If you choose to share child records, it will also share the records from the archived child tables.

This feature is to be used with the temporal feature in the DataSync Agent (see step 3). 

Here's how to enable share as archive:

  1. In your sharing ServiceNow instance, go to Perspectium > Perspectium Core Shares > Bulk Share > View Bulk Shares.

  2. Find and click into the bulk share (the clickable timestamp) that you want to share archives for.

  3. In the resulting bulk share page, use the Table name dropdown to select an archived table. 

  4. In the Runtime Settings tab, under the Runtime Behavior section, check the Share as archive box.

  5. Click Update.


  • Sharing additional records (i.e. attachments, journals, etc) are disabled
  • "Insert Only" will be disabled if "Share as archive" is enabled
  • Since archive tables do not retain table hierarchy (no parents or child tables), it stores one copy of the record to an archive leaf or child-most table. Therefore, “Include all child tables” and “Share base table” won’t behave the same as sharing a regular table. 

↑ Go to top of page




Distribute bulk share workload

This feature allows you to distribute the work load of your bulk shares by allowing them to run on multiple nodes in your instance. This is useful if you're running multiple bulk shares or scheduled bulk shares, since they will run on the same node by default, and this could impact performance. If you use this feature, nodes will only be used if they are online ad set to accept "any" scheduler.

Here's how to turn it on:

  1. In your sharing ServiceNow instance, go to Perspectium > Perspectium Core Shares > Bulk Share > View Bulk Shares.

  2. Find and click into the bulk share (the clickable timestamp) that you want to configure.

  3. In the resulting bulk share page, click the Miscellaneous tab, and check the Advanced box. This will reveal an Advanced tab.



  4. Click the Advanced tab, and check the Distribute bulk share workload box.

  5. Click Update


↑ Go to top of page




Multiple bulk share jobs

This feature allows you to choose the number of jobs (1, 2, 4, 8, or 16) it will take to process the bulk shared records. Each job will process a subset of the total records, split by sys_id.

Here's how to customize the number of jobs:

  1. In your sharing ServiceNow instance, go to Perspectium > Perspectium Core Shares > Bulk Share > View Bulk Shares.

  2. Find and click into the bulk share (the clickable timestamp) that you want to configure.

  3. In the resulting bulk share page, click the Miscellaneous tab, and check the Advanced box. This will reveal an Advanced tab (see Distribute bulk share workload for a screenshot).

  4. Click the Advanced tab, and under the Runtime Settings section, use the Number of Jobs dropdown to select the number of jobs.  

  5. Click Update.

This feature is not compatible with the following bulk share features:

  • Order by
  • Share only Sys IDs listed
  • Limit number of records shared
  • Enable confirmation features

↑ Go to top of page




Nodes to run on

This feature allows you to specify which node a bulk share will run on by referencing the sys_cluster_state table in ServiceNow. You need admin access (or a custom ACL rule) in order to see and set this value. You may want to run this feature in order to distribute the Perspectium processing across several nodes. 

Here's how to specify nodes:

  1. In your sharing ServiceNow instance, go to Perspectium > Perspectium Core Shares > Bulk Share > View Bulk Shares.

  2. Find and click into the bulk share (the clickable timestamp) that you want to configure.

  3. In the resulting bulk share page, click the Miscellaneous tab, and check the Advanced box. This will reveal an Advanced tab (see Distribute bulk share workload for a screenshot).

  4. Click the Advanced tab, and under the Runtime Settings section, use the Node to run on field to search for and select a node.  

  5. Click Update.


↑ Go to top of page




Order by

This feature allows you to customize the order in which your records in bulk share are sent out by choosing which field (such as Active, Updated, Created On etc.) the records will be ordered by when sending out the records. For example, if you choose the Created On field, the bulk share will send the records in ascending order based on the date and time at which they were created. By default, bulk shares will order records by the Sys ID (sys_id) field when querying for records to share out. 

Here's how to send records in a specific order:

  1. In your sharing ServiceNow instance, go to Perspectium > Perspectium Core Shares > Bulk Share > View Bulk Shares.

  2. Find and click into the bulk share (the clickable timestamp) that you want to configure.

  3. In the resulting bulk share page, click the Miscellaneous tab, and check the Advanced box. This will reveal an Advanced tab (see Distribute bulk share workload for a screenshot).

  4. Click the Advanced tab, and under the Runtime Settings section, use the Order by dropdown to select the field for the records to be ordered by when shared.  

  5. Click Update.


↑ Go to top of page




Share related lists

This feature allows you to share records from one or more related lists of the table being bulk shared. Here's how:

  1. In your sharing ServiceNow instance, go to Perspectium > Perspectium Core Shares > Bulk Share > View Bulk Shares.

  2. Find and click into the bulk share (the clickable timestamp) that you want to configure.

  3. In the resulting bulk share page, click the Miscellaneous tab, and check the Advanced box. This will reveal an Advanced tab (see Distribute bulk share workload for a screenshot).

  4. Click the Advanced tab, and under the Runtime Settings section, check the Share related lists box. This will reveal a new Related lists field with a lock icon.



  5. Click the lock icon next to the Related lists field to unlock the field. This will reveal an empty field and a search bar.



  6. Use the search bar field to type your desired list, or click the search button to open all related lists of the table and select from there. Alternatively, you can click the Add/Remove multiple icon to add or remove multiple lists at once.

  7. Click Update.


↑ Go to top of page




Table replication in a subscribing instance

This feature allows you to create new tables in a subscribing ServiceNow instance by sharing a schema from one instance to another. This will create the table, field types, choices, labels, values, as well as the following:

  • Table sys IDs, columns, and the selection for choice fields
  • ACLs
  • Other table information, such as extends, auto-number, application process, etc.

Upon receiving the schema message, the table will be created in the instance and a generic subscribe record will be will be created to allow for replication of any records that come with the table schema.

Here's how to use share schema to replicate tables in a subscribing instance:

  1. In your sharing ServiceNow instance, go to Perspectium > Perspectium Core Shares > Bulk Share > View Bulk Shares.

  2. Find and click into the bulk share (the clickable timestamp) that you want to share the schema for.

  3. In the resulting bulk share page, click the Miscellaneous tab, and check the Advanced box. This will reveal an Advanced tab (see Distribute bulk share workload for a screenshot).

  4. Click the Advanced tab, and under the Runtime Settings section, check the Share schema box. This will reveal a Target application dropdown.



  5. Select ServiceNow from the Target application dropdown.

  6. Click Update


↑ Go to top of page