Release Date: March 11, 2021New Features |
---|
Use <custom_primary_key/> to create an auto-incrementing column and set the column as the primary key. 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 |
---|
| 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 |
---|
|
|
| DEV | 13182Specify the character set for database encoding and truncate the data based on this character set by using <database_truncate_encoding>. 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. | 9446 |
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 | Enable truncating table in the database by the DataSync Agent using Truncate Before Share | 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>. | <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- |
---|
|
|
| 10785 | Customize your temporal database table's archive date and time stamp in the psp_valid_to column with <archive_datetime/> | 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- |
---|
|
|
| 10932Choosing Manual Configurations in the DataSync Agent Installer will prompt you to contact Perspectium Support for a guided step | 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- |
---|
|
|
| 10966If 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 |
---|
| |
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 9588Match 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”/> .
| 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- |
---|
|
|
| 11615 | Snowflake DataSync Agent will automatically have parameter values to default to uppercase characters after installation | 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 | Choosing Manual Configurations in the DataSync Agent Installer will prompt you to contact Perspectium Support for a guided step. | 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-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. 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-120039588 |
---|
|
|
| Match text field lengths in your DataSync Agent with <match_field_lengths/>.<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-1186111753 |
---|
|
|
| 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”/> . 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-1205811615 |
---|
|
|
| Using <column_sort>alpha</column_sort> in your DataSync Agent will now sort new fieldsAWS 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-1470911688 |
---|
|
|
| When a table already exists upon an integration, the new reference fields will now have length of 32.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
| <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-1470912003 |
---|
|
|
| Using <update<close_on_bulk/> will now skip duplicates in the DataSync Agent based on the message action.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-1356211861 |
---|
|
|
| Enhanced error recovery when using temporal and the table does not exist in the databaseThe 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-958012058 |
---|
|
|
| DataSync AWS S3 Subscriber Agent now supports Java 14.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-959314709 |
---|
|
|
| The <region> directive in the AWS S3 Subscriber Agent is now optional and no longer required. 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-1107114709 |
---|
|
|
| AWS S3 Subscriber Agent logging extended for different levelsThe 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-1229514709 |
---|
|
|
| Using <update_on_bulk/> will now skip duplicates in the DataSync Agent based on the message action 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-1331713562 |
---|
|
|
| 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) statusAgent 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-131649580 |
---|
|
|
| DataSync Agent now supports Java 14.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. | 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- |
---|
|
|
| 16147 | The DataSync Agent Installer will now allow you to enter FedRAMP URLs for your ServiceNow instance information. | 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 |
---|
The action of processing delete messages will not alter the database tables. | | Jira |
---|
server | JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
key | DEV- |
---|
|
|
| 9192The attribute, use_basic_consume, in the agent.xml will reflect on the protocol given upon the configuration in DataSync Agent installer. | 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- |
---|
|
|
| 11395Emojis 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). | 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- |
---|
|
|
| 11990 | Sharing records from a database to the Integration Mesh will now be consumed without errors | 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- |
---|
|
|
| 12018After adding a string field with default value in a ServiceNow table, executing a bulk share will no longer generate a timestamp error | 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- |
---|
|
|
| 12244 |
|
Bug Fixes |
---|
Table stats data will now show the correct timezone offset. Show If |
---|
special | Error when inserting/updated a record into a SAP HANA table that has 2 billion+ rows because of metadata query. | | Jira |
---|
server | JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
---|
serverId | e15725ca-3b2b-32f6-914c-89477a90901d |
---|
key | DEV- |
---|
|
|
| 15439 |
---|
The attribute, use_basic_consume, in the agent.xml will reflect on the protocol given upon the configuration in DataSync Agent installer | 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 |
---|
| 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). 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 |
---|
|
|
|
|