Release Date: March 11, 2021New Features |
---|
Use <custom_primary_key/> to create an auto-incrementing column and set the column as the primary key. Show If |
---|
| Jira |
---|
server | JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
key | DEV-8399 |
---|
|
|
|
Show If |
---|
| Optimize throughput and ensure message ordering with Key Set Processing for DataSync Agent. Jira |
---|
server | JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
key | CE-168 |
---|
|
|
Use <batch_flush_interval> for the number of seconds that will trigger a batch SQL statement execution with batch processing. Show If |
---|
| Jira |
---|
server | JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
key | DEV-9720 |
---|
|
|
| Use <skip_performance_tag> to stop the Agent from reporting performance metrics (statsx) to the Integration Mesh. Show If |
---|
| Jira |
---|
server | JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
key | DEV-10621 |
---|
|
|
| Enable truncating table in the database by the DataSync Agent using Truncate Before Share. Show If |
---|
| Jira |
---|
server | JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
key | DEV-9448 |
---|
|
|
| <use_instance_credentials/>is now available to use instead of access keys in AWS S3 Subscriber Agent to use IAM roles when uploading to the S3 buckets. Show If |
---|
| Jira |
---|
server | JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
key | DEV-14515 |
---|
|
|
| Customize your temporal database table's archive date and time stamp in the psp_valid_to column with <archive_datetime/>. Show If |
---|
| Jira |
---|
server | JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
key | DEV-13182 |
---|
|
|
| Specify the character set for database encoding and truncate the data based on this character set by using <database_truncate_encoding>. Show If |
---|
| Jira |
---|
server | JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
key | DEV-9446 |
---|
|
|
|
Show If |
---|
| DataSync Agent can now run as a container in Azure. Jira |
---|
server | JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
key | DEV-20851 |
---|
|
|
Enhancements |
---|
Improved SQL server performance. | Added PostgresSQL as a DataSync Type option in the Agent installer. Show If |
---|
| Jira |
---|
server | JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
key | DEV-12079 |
---|
|
|
| The DataSync Agent Installer will now use HTTPS as a protocol by default in <message_connection>. Show If |
---|
| Jira |
---|
server | JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
key | DEV-10785 |
---|
|
|
| Snowflake DataSync Agent will automatically have parameter values to default to uppercase characters after installation. Show If |
---|
| Jira |
---|
server | JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
key | DEV-10932 |
---|
|
|
| Choosing Manual Configurations in the DataSync Agent Installer will prompt you to contact Perspectium Support for a guided step. Show If |
---|
| Jira |
---|
server | JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
key | DEV-10966 |
---|
|
|
| If the agent.xml file is invalid (i.e. bad file format, missing field characters, etc), an error message will now display on the log with a description of the error. Show If |
---|
| Jira |
---|
server | JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
key | DEV-9588 |
---|
|
|
| Match text field lengths in your DataSync Agent with <match_field_lengths/>. Show If |
---|
| Jira |
---|
server | JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
key | DEV-11753 |
---|
|
|
| Check the fields values if the updated time is the same from the previous share in your DataSync Agent with <skip_duplicates check_all_fields=”true”/> . Show If |
---|
| Jira |
---|
server | JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
key | DEV-11615 |
---|
|
|
| Using <column_sort>alpha</column_sort> in your DataSync Agent will now sort new fields. Show If |
---|
| Jira |
---|
server | JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
key | DEV-11688 |
---|
|
|
| When a table already exists upon an integration, the new reference fields will now have length of 32. Show If |
---|
| Jira |
---|
server | JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
key | DEV-11738 |
---|
|
|
| <enable_error_log/> will now keep track of the number of invalid records and save the error count in the generated audit file. Show If |
---|
|
Jira |
---|
server | JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
key | DEV-12003 |
---|
|
|
| <close_file_interval> is added to set the amount of time the Agent will wait for tmp files to be modified. Show If |
---|
|
Jira |
---|
server | JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
key | DEV-11861 |
---|
|
|
| Enhanced error recovery when using temporal and the table does not exist in the database. Show If |
---|
| Jira |
---|
server | JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
key | DEV-12058 |
---|
|
|
| AWS S3 Subscriber Agent now supports sending receipts back to ServiceNow. Show If |
---|
| Jira |
---|
server | JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
key | DEV-14709 |
---|
|
|
| The <region> directive in the AWS S3 Subscriber Agent is now optional and no longer required. Show If |
---|
| Jira |
---|
server | JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
key | DEV-14709 |
---|
|
|
| AWS S3 Subscriber Agent logging extended for different levels. Show If |
---|
| Jira |
---|
server | JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
key | DEV-14709 |
---|
|
|
| Using <update_on_bulk/> will now skip duplicates in the DataSync Agent based on the message action. Show If |
---|
| Jira |
---|
server | JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
key | DEV-13562 |
---|
|
|
| The agent will now log a warning message that a queue will be created when messages are shared if the agent gets a 404 (queue not found) status. Show If |
---|
| Jira |
---|
server | JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
key | DEV-9580 |
---|
|
|
| DataSync Agent now supports Java 14. Show If |
---|
| Jira |
---|
server | JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
key | DEV-9593 |
---|
|
|
| DataSync Agent now supports Java 15. Show If |
---|
| Jira |
---|
server | JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
key | DEV-11071 |
---|
|
|
| The DataSync Agent Installer will now allow you to enter FedRAMP URLs for your ServiceNow instance information. Show If |
---|
| Jira |
---|
server | JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
key | DEV-12295 |
---|
|
|
| The action of processing delete messages will not alter the database tables. Show If |
---|
| Jira |
---|
server | JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
key | DEV-13317 |
---|
|
|
| Agent re-queues delete records up to 3 times when no record in database to delete. Show If |
---|
| Jira |
---|
server | JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
key | DEV-13164 |
---|
|
|
| Agents installed using the installer will create a conf/agent.xml with instances valued to 1 instead of 4 to minimize data loss. Show If |
---|
| Jira |
---|
server | JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
key | DEV-14958 |
---|
|
|
| Sharing records from a database to the Integration Mesh will now be consumed without errors. Show If |
---|
| Jira |
---|
server | JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
key | DEV-16147 |
---|
|
|
| Set your MySQL database with utf8mb4 character set and collation to accept multibyte characters in the agent.xml with <database_table_character_set> and <database_table_collation>. Show If |
---|
| Jira |
---|
server | JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
key | DEV-13006 |
---|
|
|
|
Bug Fixes |
---|
Error when inserting/updated a record into a SAP HANA table that has 2 billion+ rows because of metadata query. Show If |
---|
| Jira |
---|
server | JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
key | DEV-9192 |
---|
|
|
| The attribute, use_basic_consume, in the agent.xml will reflect on the protocol given upon the configuration in DataSync Agent installer. Show If |
---|
| Jira |
---|
server | JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
key | DEV-11395 |
---|
|
|
| Emojis will no longer be removed in incoming messages to the DataSync Agent when at lease one custom schema feature is used (tablename, column_name, _dv suffix). Show If |
---|
| Jira |
---|
server | JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
key | DEV-11990 |
---|
|
|
| After deleting a field from a ServiceNow table, the old value of that field will no longer be inserted into the database. Show If |
---|
| Jira |
---|
server | JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
key | DEV-12018 |
---|
|
|
| After adding a string field with default value in a ServiceNow table, executing a bulk share will no longer generate a timestamp error. Show If |
---|
| Jira |
---|
server | JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
key | DEV-12244 |
---|
|
|
| Table stats data will now show the correct timezone offset. Show If |
---|
| Jira |
---|
server | JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
key | DEV-15439 |
---|
|
|
| Using skip_duplicate with check_all_fields will now compare values properly. Show If |
---|
| Jira |
---|
server | JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
key | DEV-13534 |
---|
|
|
|
Removed Features |
---|
Removed the following DataSync Type options in the DataSync Agent Installer that are no longer being used: Rabbit MQ and Other. Show If |
---|
| Jira |
---|
server | JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
key | DEV-10787 |
---|
|
|
|
|