New Features
- Select which related records you want to share using bulk share's share related list feature.
- Once records are shared out through bulk share or dynamic share, see how many records are shared with the conditional share you created with the Shared Records field.
- Enable Generate unique names for business rules associated with dynamic shares option to have unique business rule names that are created from dynamic shares using business rule.
Enhancements
- Upon cloning bulk shares, new clones will now honor only the latest time stamp and no longer append timestamps continuously.
- ServiceBond in shared queue selection is now replaced by Service Gateway.
- Added warning messages to alert users that the use of custom tables and columns can impact previous shares when creating a custom schema.
- Added the number of messages contained in the payload to the header for messages that are being sent from ServiceNow to the Perspectium Integration Mesh.
- If you input a number in the Limit on the number of records shared field, you will no longer be prompted to confirm you are executing the bulk share without conditions.
- Display error message and prevent the dynamic share from getting created if incorrect configurations for Business Rule When, Include journal fields and Table Map.
- Simultaneous bulk shares will now run separately from regular bulk shares. The number of bulk shares to run simultaneously in a scheduled bulk share will be honored without deferring even when regular bulk shares are already running.
- Creating MultiOutput Jobs will now automatically delete jobs that were previously created by the Create MultiOutput Jobs tool.
- Additional information is available when monitoring your queue and tracking the history. With Track History, you can start viewing the metrics of your queue.
- Alert messages are added to guarantee that both properties, Enable sending receipt functionality for data guarantee and Enable subscribing receipt functionality for data guarantee, are activated for Data Guarantee.
- Enhanced the Table Compare feature for ServiceNow to Database.
- Heartbeats in ServiceNow will now show the number of consumers on each active queue in the instance. If a queue has some sort of error and can't be access, that queue won't show in the heartbeat at all.
Bug Fixes
- Issue fixed with bulk share state staying as "Running" when Data Obfuscation is enabled.
- Reduced the amount of global property query to help improve performance for subscribe records in large bulk.
- In Group Share, clicking Create a new group share like this one no longer leads you to the previous page visited.
Known Issues
- Import set subscribing does not work with .insert .update messages and conflicts with SIAM approach for import sets
Bug Fixes
- Fixed an issue where values were not entering into the import set table correctly.
Bug Fixes
- Fixed an issue where values were not entering into the import set table correctly.
Bug Fixes
- Fixed an issue of primary key violations occurring on bulk actions on subscribe in ServiceNow.
- Added better handling of Observer messages for invalid queries.
Bug Fixes
- Fixed an issue where certain database view tables are not processing correct out of ServiceNow
- Fixed an issue where database view tables returns a syntax error when previewed
Bug Fixes
- Added the ability to for Jira meshlet to select different Jira projects
Bug Fixes
- Fixed an issue where querying business rules were preventing bulk share from sharing the expected number of records.
New Features
- Manually reshare records from your ServiceNow instance from a period of three days or less for situations where all records were not received.
- There are now two options to choose from in dynamic share: business rule or flow designer. Choosing flow designer will create a dynamic share using flow. With this option, you can send records out of your ServiceNow instance even with setWorkflow is set to false. Choosing business rule uses a previous release approach by creating a dynamic share using business rule.
- Specify how many bulk shares can run simultaneously in a scheduled bulk share. This is useful if you don't want all the bulk shares listed in this scheduled bulk share to try and run immediately based on the number of scheduled workers you have available.
- You are now prompted to confirm when deleting messages in the inbound or outbound messages tables.
- Upon creating shared queues or subscribed queues, you can choose a queue type that will automatically prepend a queue prefix to your queue name for easier creation and setup.
- Enable debug logging for a specified time frame in the Perspectium properties to obtain additional informations when using the Perspectium application.
- Fanout queues are used to broadcast messages across multiple queues. When creating a shared queue, you now have the option to send to a fanout queue. Monitoring receipts for fanout queues is also available.
- When include audit log is checked in dynamic share or bulk share, you have an option to choose which audit log records will be shared by checking Filter audit fields.
- In a ServiceNow production instance, you can specify which node to run scheduled jobs on. To learn more about ServiceNow nodes, see Node Performance Metrics.
- Monitor tables such as inbound messages, outbound messages, outbound attachments, and outbound audits in your ServiceNow instance by setting up email notifications using Table Monitoring.
- If you are sending a high volume of messages to a single queue or spreading your messages across a high volume of queues, you can now use Multiple MultiOutput Jobs.
- When you enable sharing ServiceNow display values for reference fields and choice lists in your dynamic shares and bulk shares, you now have an option to change the language of the display values.
- To improve data alignment, you now have an option to use these new features:
- Post Immediately: In a sharing instance, dynamic share messages will be posted as soon as the outbound message is created instead of waiting for the MultiOutput processor scheduled job to send all the outbound messages in bulk.
- Skip delayed updates: In a subscribing instance, inbound messages will be skipped if the message has a later updated time than the target record.
Enhancements
- The target database schema name will now derive from the target table name when customizing your target database schema using table maps in your dynamic share or bulk share.
- Improved dynamic share's scheduled sync up feature with notifying users when to create indexed columns for the selected table in dynamic share. For more information on indexing columns, see Create a table index.
- 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.
- Database views tables is now available for group sharing out a combination of dynamic and bulk shares from one ServiceNow instance to another.
- Improved performance in manually deleting all receipts for messages that have been shared out of ServiceNow.
- Added confirmation request for manually deleting all receipts for messages that have been shared out of ServiceNow.
- When a table map is set in a dynamic share, you will now be notified to use "before" in the business rule when field to ensure Service Gateway integration.
- Catalog Tasks PSP Template is available as a template selection for group share. This template includes data related to service catalog requests that requires approval.
- Optimized performance for querying outbound records by the shared queue.
- Using the Share Schema feature on the bulk share form previously only worked with creating new schemas in the agent database. The feature has been expanded to create new tables in a subscribing ServiceNow instance.
Bug Fixes
- Enable sharing child records of the sys_template table.
- View History in shared and subscribed queues is now compatible with enabled monitor and track history.
- Preview output in table map now correctly process HTML fields with single lines.
- Subscribing instances will now trigger business rules for delete actions in bulk share.
- You should no longer be able to create empty group share templates.
- Work notes and comments on sharing instances will now always appear in the subscribing instance's activity log.
Removed Features
- In dynamic share, 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 Field should not be checked when sharing to another ServiceNow instance or SIAM integration.
- Removed Perspectium ETS scheduled jobs (Perspectium ETS feature is no longer available).
Known Issues
- Auxillary records (audit log, journal fields, etc.) are not re-sending when Resend Message is clicked on the record's receipt.
Bug Fixes
- Typo fix in Meshlet message when retrieving ServiceNow schema.
Enhancements
- Multiple bulk shares can now be executed at the same time.
- Add display value field (prefixed with "dv") for reference and choice list field will automatically be enabled upon registration.
New Features
DataSync Express offers bulk share, scheduled bulk share, and much more!
Enhancements
- Be able to modify your bulk share settings after bulk share is executed using reset bulk share
Removed Features
- Bulk share fields are removed e.g., Include Embedded Images/Videos, View Name, Target Queue, Notes, and Team.
- Shared Queue, Start All Shares and Stop All Shares modules are removed.
New Features
- DataSync Free offers bulk share and scheduled bulk share for your incident records, and much more!
- Add display value field (prefixed with "dv") for reference and choice list field will automatically be enabled upon registration.
Enhancements
- In the DataSync Agent, running too many threads can slow down the process. To avoid this, a warning will appear when more than 64 threads are created.
- In DataSync Agent for Salesforce, the <schema_connection> directive's value will be in the format https://login.salesforce.com or https://login.salesforce.com/services/oauth2/token.
New Features
- Setup DataSync Agent for Snowflake through the Agent Installer.
- More visibility into batch receipts generated by the DataSync Agent is now available by configuring your DataSync agent to receive receipts.
- You can now truncate string values if you have exceeded a column's max length (UTF-8) in the DataSync Agent.
Enhancements
- Configure the number of times the DataSync agent will retry after a SQL error with <sql_retries> in the agent.xml.
- 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 with <timestamp_difference> in the agent.xml.
- Added machine's hostname, internal IP address, Java version and OS version to DataSync Agent's heartbeat.
- Validation of Repeater Agent installation to confirm if the replicator agent has been installed properly.
- Updated DataSync Agent to utilize 3.9.0 Snowflake JDBC driver.
- Configure your DataSync Agent with sorting your database columns in alphabetical order with <column_sort> in the agent.xml.
- Prevent your DataSync Agent from altering your database column size with <database_static_column_size> in the agent.xml.
- Polling interval is now limited to 5 seconds or greater. If the polling interval is set to less than 5 seconds, it will default to 5 seconds.
- To ensure multibyte or foreign characters are saved properly for string column types, the DataSync Agent creates column types that can store unicode string data. Changing the data type to your configuration is now available.
- You can now add the tag <skip_duplicate/> to the agent.xml to skip adding temporal rows for duplicate records.
- S3 file subscriber now allows multiple layers of folders following the bucket name. See the <s3_bucket> directive for more information.
- Default <skip_table_stats/> when installing SQL Agent through the installer.
- In DataSync Agent for Salesforce, the <schema_connection> directive's value will be in the format https://login.salesforce.com.
Bug Fixes
- 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?
- The DataSync Agent's database directive, <database_parms>, now includes another default value (autoReconnect=true) that will save records in the database even when there is no activity in the instance.
- Fixed an issue where the Agent only ran table stats once instead of intervals
Known Issues
- <batch_insert> and <batch_update> commands do not work properly when reading messages from a queue that has records from different tables. To use these commands, the queue should only have records from one table.
New Features
- Added Delete All option in list view of Perspectium objects such as dynamic share and bulk share to delete all selected records at once.
- Temporal agent is now functional with DataSync for Salesforce.
- Scheduled bulk share is now available in DataSync for Salesforce.
Enhancements
- Optimized Perspectium Apex Triggers to improve performance and speed.
- Improved error handling for previewing Salesforce bulk shares.
- Previewing a Salesforce bulk share will be prevented while a bulk share is running.
A target queue error notification will no longer display upon creation for bulk shares and dynamic shares.
- The Salesforce application will set a header with the number of messages being sent on each post to the Integration Mesh.
The Salesforce application now sets a header with the org name for each post to the Integration Mesh.
Bug Fixes
- MultiOutput processing jobs will no longer be present in scheduled jobs after deletion.
- Arrows are centered in the Fields to Share and Include Child Records in the dynamic share and bulk share when selecting records for those fields.
Misspelling fix for the success message that appears when After Save Trigger is clicked in the dynamic share.
Known Issues
- Description field for Perspectium jobs must be left empty by default in order for jobs to process. For a workaround, go to Troubleshooting DataSync for Salesforce and see Why doesn't the Perspectium Job in Salesforce continuously run?
New Features
- Added the ability to share updates and deletes from ServiceNow
- Added the to ability to enable and support data guarantee
New Features
- DataSync for Snowflake, a single-direction (ServiceNow to Snowflake) integration that leverages bulk shares for a one time migration for the collection of ServiceNow data into a Snowflake data warehouse.
Bug Fixes
- Fixed an issue where the password value is not encrypting correctly for Windows environment.
Enhancements
- Enable skipping empty field values in the messages created by using hideEmptyFields in your Meshlet Configurations for Splunk.
- Splunk Meshlets will now process referenced field values such as assigned_to, company, etc.
Enhancements
- Include all the data for a record's fields in the event field when configuring your Splunk meshlet by using saveInEvent.
- Configure your Splunk meshlet to dynamically set table name by adding $table value in sourceType.
New Features
- Modify meshlet logs by setting the rolling policy in the logback file Perspectium Support will provide to you.
- SOCKS proxy server can now be use to connect with the meshlet.