DataSync for ServiceNow (Replicator) 

Gold Hotfix 1 Release 

March 19, 2020

• Fixed an issue where query Business Rules were preventing Bulk Share for sharing exepcted number of records.

DataSync for ServiceNow (Replicator)

March 3, 2020

• Reshare records between a designated time interval.

• Use dynamic share to create flow to send records out of your ServiceNow instance even with setWorkflow set to false.

• Specify how many bulk shares can run simultaneously in a scheduled bulk share.

• You are now prompted to confirm when deleting messages in the inbound/outbound tables.

• Easier creation and setup for shared and subscribed queues.

• Enable debug logging for a specified time frame in Perspectium properties.

• Enable and monitor receipts for fanout queues.

• Filter out which audit log records to share in dynamic share or bulk share.

• Specify which node your schedule jobs run on.

• Monitor tables (inbound messages, outbound messages, outbound attachments, and outbound audits) in your ServiceNow instance. 

• Create multiple MultiOutput jobs in your ServiceNow instance through a UI. 

• Select which language to use for display values. 

• Sharing instance can post dynamic share outbound messages immediately.  

• Subscribing instance can skip inbound messages that have a later updated time than the target record.

• Target database schema will now derive from the target table name.

• Improved Dynamic Share's Scheduled sync up feature with indexed columns.

• Receipt messages are now an opt-in feature and can be enabled in the u_psp_properties table by modifying the value of the com.perspectium.enable_receipts property.

• Group share now includes Database Views tables. 

• Performance improvement in deleting all receipts.

• Added confirmation request for deleting all receipts.

• Ensured Service Gateway integration by notifying user to use "before" in business rule when.

• Catalog Tasks PSP Template is available as a template selection for group share.

• Share child tables with the sys_template table.

• View History is now compatible with enabled monitor and track history.

• Preview output in table map now correctly process HTML fields with single lines.

• Fixed an issue for deletes on subscribing instances not triggering business rules.

• You should no longer be able to create empty group share templates.

• Fixed work notes/comments posted on sharing instance not always appearing in record's activity log on subscribing instance.

• On dynamic shares you are no longer restricted from using "Include Journal Fields" when "Business Rule When" is set to "Before". Instead, a warning message is displayed to notify users that "Include Journal Fields" should not be checked when sharing to another ServiceNow instance or SIAM integration.

• Removed Perspectium ETS scheduled jobs

DataSync Express

TBD

• DataSync Express offers bulk share, scheduled bulk share, and much more!

DataSync Agent

TBD

• Setup DataSync Agent for Snowflake through the Agent Installer.

• More visibility into batch receipts generated by the DataSync agent.

• Configure the number of times the DataSync agent will retry after a SQL error.

• Improved better error handling for DataSync agent when messages have empty values.

• DataSync agent name is now automatically generated from the instance name as instancename_subscribe.

• Choose to use the JDK/JRE directory path defined in the JAVA_HOME environment variable when configuring your DataSync Agent.

• The agent.xml configuration file's database_parms directive has been standardize.

• Ability to select which temporal columns will be primary key in agent.xml.

• Configure the time difference between temporal entries in agent.xml.

• Added machine's hostname, internal IP address, Java version and OS version to DataSync Agent's heartbeat.

• Validate the installation of the Repeater Agent.

• Updated DataSync Agent to utilize 3.9.0 Snowflake JDBC driver.

• Configure your DataSync Agent with sorting your database columns in alphabetical order. 

• Prevent your DataSync Agent from altering your database column size.

• Polling interval is limited to 5 seconds or greater. If the polling interval is set to less than 5 seconds, it will default to 5 seconds.

• Repeater agent supports Java 12.

• DataSync agent supports Java 12.

• Tasks pointing to the same database and server will allocate and start only one table stats collector to avoid placing excessive load on the agent and the database.

• DataSync Agent will now replicate records with foreign character. Having the previous DataSync Agent release will still have the issue, simply upgrading to Gold WILL NOT fix the issue. Check out the following link to fix the issue: Why am I having error replicating records with foreign characters?

DataSync for Salesforce

TBD

• Optimized Perspectium Apex Triggers to improve performance and speed.

• Improved error handling for previewing bulk shares.

• Previewing bulk share is prevented while a bulk share is running. 

• Target queue error notification will no longer display upon creation for bulk shares and dynamic shares

• Temporal agent is now functional with Salesforce

• The Salesforce application will set a header with the number of messages being sent on each post to the Integration Mesh.

• A confirmation pop up will now appear after selecting Added Delete All option in tables list view of Perspectium objects such as dynamic share,  and bulk share, and so on. This will confirm that users want to  to delete all the records in the given tableselected records at once.

• MultiOutput processing jobs will no longer be present in scheduled jobs after deletion.

Can't find the feature you're looking for?  

See release notes for earlier releases.