DataSync Agent Release Notes

Support deletes with Snowflake.

Support altering tables to add columns and increase column length for Snowflake.

Add Snowflake as selectable option into Agent Installer along with Snowflake configuration options for Role, Warehouse, Schema and Files Directory. Database, Role, Warehouse and Schema will allow be saved as uppercase from the Installer into the agent.xml configuration file. 

Automatically create Java Additional Parameters Snowflake configuration options when using Agent Installer to install Agent with Snowflake as target database.

Check for valid values for Snowflake configuration options for files_directory, file_max_size, flush_interval and delete_files_interval, using default values if invalid values specified.

Send errors back to ServiceNow when we have validation errors testing records before using the COPY API to push to Snowflake database.

Add Snowflake support for Table Compare, changing default flush_interval to 3 minutes so compare messages can be read properly.

 NOTE: You will need to update databases.xml to work with Table Compare. See Set up DataSync Agent to share to Snowflake for more information and contact Perspectium Support with any questions. 

Add Snowflake support for IO Datetime plugin.

 NOTE: For deletes with the IODatetime plugin, the column specified as the update_column will also be updated with the datetime when the delete action happens due to how Snowflake updates records using the COPY API,

Support MySQL and PostgreSQL as targets for archiving.

Upgraded to new Spring versions to fix CVE-2024-22262, CVE-2024-22259 and CVE-2024-22243.

Upgrade yajsw to new version 13.11 to support Java 21.

Add column headers to CSV files generated after first one.

Support using the COPY command to bulk load data into Snowflake with upgraded Snowflake JDBC driver 3.14.5.

 NOTE: This feature only supports a limited subset of the Agent's features. See Set up DataSync Agent to share to Snowflake for more information and contact Perspectium Support with any questions. 

Support saving Salesforce records to target databases as shared from DataSync for Salesforce.

 NOTE: You will need Krypton 8.0.0 and newer of the DataSync for Salesforce application for the DataSync Agent and to update databases.xml to properly consume Salesforce records. See Set up DataSync Agent for Salesforce for more information and contact Perspectium Support with any questions. 

Support specifying timezone for saving datetime values with the IO Datetime plugin.

Support specifying translations for searching and replacing values when saving to JSON files.

Change to pre-Iodine functionality of not having # in the filename when saving records to files.

Support running the Agent with Java 19.

Support restoring archived data.

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

To avoid data loss, only allow <task instances="1"> and not multiple instances.

Support num_queues attribute on <message_connection> for configuring child queues.

Upgrade to Spring libraries to fix 376506 Spring Framework Remote Code Execution (RCE) Vulnerability (Spring4Shell), 376533 Spring Framework Denial of Service (DoS) Vulnerability and 376642 Spring Framework Denial of Service (DoS) Data Binding Vulnerability.

Support OAuth for accessing ServiceNow instance to get table schema.

Validate configurations on Agent start up and send more errors back from the Agent to ServiceNow for error notifications.

Fix NullPointerException that may occur when Agent is connected to Oracle for a long time.

Upgrade to commons-text-1.10.jar to fix CVE-2022-42889.

Support for Java 18

Upgrade to newer version of yajsw to include commons-text-1.10.jar to fix CVE-2022-42889.