DataSync for ServiceNow Release Notes

Remove Clone bulk configuration option when creating new bulk share since this bulk share hasn't been save into the system yet (so nothing to clone).

Fix for Dashboard to show hourly data in Record Breakdown chart when current time is in the midnight hour.

Don't display domain option on conditional shares for tables that aren't domain separated (i.e. don't have sys_domain field) to overcome ServiceNow limitation with invalid queries.

Separate Group Share as an addon to the Core application for those who don't use it due to potential conflicts with ServiceNow health scans.

Support Share only selected fields when resharing records for Table Compare with a database on bulk shares.

 NOTE: You will need to account for the sys_mod_count field to properly use these Share only selected fields and Table Compare together. See here for more information.

Share out boolean field values as true/false instead of 1/0 when using Share only selected fields.

Support FX Currency (currency2) field type for sharing display values.

 NOTE: FX Currency (currency2) display value fields are decimal fields but will contain the currency symbols (i.e. $3.00) so the databaseConfig.json configuration file should not map the decimal type to a numeric type in Snowflake. Doing so will cause errors since you are trying to insert a non-numeric value into the field. This issue will not occur using the default settings of databaseConfig.json as the decimal type is not specified and will map to VARCHAR that support the currency symbols.

Don't disable the PSP property for posting to the default queue when a 401 Unauthorized is received.

Don't disable the PSP property for posting to the default queue when a 401 Unauthorized is received.

Use JavaScript library to continue supporting Triple DES encryption method for sharing data with ServiceNow's planned deprecation of the GlideEncrypter API. See ServiceNow GlideEncrypter API Deprecation for more information.

Use password2 fields for storing Perspectium properties with ServiceNow's planned deprecation of the GlideEncrypter API. See ServiceNow GlideEncrypter API Deprecation for more information.

Remove warning about AES-128 encryption is only required for certain integrations as AES is recommended for encrypting with ServiceNow's planned deprecation of the GlideEncrypter API. See ServiceNow GlideEncrypter API Deprecation for more information.

Disable Delete option on business rule dynamic share when async_always is selected as the Business Rule When option since this option does not support sharing deletes (similar to previous async option).

Fix Table Compare Synchronize Deleted Records not updating previous executions from a Pending state.

Prevent purging queue when queue has over 1,000,000 (one million) records.

Show Previous Table Compare Executions even if no agent results.

Check Enable confirmation enabled when resharing records to allow records from continuously being reshared when the database has an issue.

Fix Subscribe's Condition script not honoring answer value.

Fix modifications to override and update out of box sys_template New and Update UI actions.

Use _operation() for dynamic share sharing records to account for tables that have an operation field.

Support Share only selected fields with conditional shares.

 NOTE: With Share only selected fields enabled, the Use Table Map option will not be available on conditional shares. Since both options modify the fields in the outgoing record payload, both options are not compatible with each other.

Support outbound records being generated for conditional bulk shares if default encryption key is not set.

Support archiving and restoring data using DataSync with the Agent and a target database.

 NOTE: This requires the Archive Data update set to be installed. Contact support@perspectium.com for more information.

Fix Schedule Table Compare not appearing when clicked on ServiceNow to Database Table Compare Synchronize Deleted Records.

 NOTE: Choosing the timezone has been removed from the Schedule Table Compare form as ServiceNow will not honor the timezone when setting through scripting. 

Don't check for attachments exceeding maximum allowed size on table maps that don't have a mapping using attachments (source field uses psp_attachment or target field is attachments)

Support dynamic shares and scheduled bulk shares not being started or stopped with the Start/Stop All Shares by naming them starting with "X" or "x".

Support the new async_always business rule when option available with Rome+ on dynamic shares and remove the legacy (deprecated) async option when creating a new dynamic share.

 NOTE: If you have a current dynamic share set with the legacy async business rule when, this will not be changed to the new async_always so as to not disrupt your current active dynamic shares and since the legacy option continues to work. You can edit your current dynamic share and choose the new async_always option to upgrade to the new option.

Add Meshlet to filter list for Table Compare's Previous Table Compare Executions list on Compare Records by Table

Add displaying table and option to delete a table compare results record in Table Compare's Previous Table Compare Executions list.

Support specifying number of queues for a shared queue.

Support child bulk shares based on number of queues.

Add All (One Job Per Queue) option when creating multiple MultiOutput jobs by outbound queue.

Return to list when saving a bulk share record instead of staying on the record so user knows record has saved properly.

Use Table Map from bulk share for records reshared to a database by Table Compare.

 NOTE: See Table Compare for further configuration required if using a Table Map with Table Compare for ServiceNow to database.

Sort table names alphabetically in Choose Table dropdown on Synchronize Delete Records and Compare Records by Table pages of Table Compare.

Keep queue active when getting queue status regardless of status returned.

Warn and default Sharing setup to Share the table records only when using a table map in dynamic or bulk share (including conditional shares).

Remove calling queue metrics not being used in application.

Optimize Weekly Troubleshooting Report scheduled job performance.

Use dynamic share legacy approach for Use audit delete listener instead of delete recovery to account for tables like sys_user_grmember that do not work with delete recovery.

Set table field maps to have same field type and field length when adding fields that exist in source table with the Add all source table fields or entering a new field manually using the form. 

Support updating bulk shares that have the same name in scheduled bulk shares if upgrading from older versions of the Perspectium application.

Fix database views to not share out encoded sys_id field when using Share only selected fields option.

Fix executing a bulk share again when the user triggers executing again in a different timezone.

Fix scripting boxes not appearing on Subscribe form when upgrading from Helium.

Display field type and field length options on table field map form.

Fixed Perspectium UI pages having incomplete blue border lines on San Diego/Tokyo+ versions of ServiceNow when clicking on a link

Fixed fonts for headings on Perspectium UI pages not all being consistent on San Diego/Tokyo+ versions of ServiceNow. 

Fixed the Show icon for password fields not being lined up correctly on Perspectium properties UI pages when on San Diego/Tokyo+ versions of ServiceNow.

Fixed Refresh and Setting options not appearing on the Dashboard for San Diego/Tokyo+ versions of ServiceNow.

Fixed UI remaining legacy view when upgrading to Iodine version of Perspectium Core on San Diego/Tokyo+ versions of ServiceNow.

Fixed Portal Settings missing from Perspectium properties UI page on San Diego/Tokyo+ versions of ServiceNow.

Fixed Finish Install not running the first time Perspectium Core installed on an instance with San Diego/Tokyo+ versions of ServiceNow.