What's New in Syniti Replicate 10.4

Here are highlights of the significant changes in 10.4.

New Features

All Components

• Added support for SQL Server Synonyms, which are used as a source table for refresh replication

• Added support for Oracle Synonyms, which are used as a source table for refresh replication

• Created an export API to create a replication, with specified settings, where the target is a CSV file

• Added a Chunk Column property in file target replications, which uses the indicated column to process data load in chunk files

• Added automatic conversion for the SAP date logic since SAP stores dates as an NVARCHAR(8) field in the format of YYYYMMDD. When refreshing an SAP table, the NVARCHAR(8) field is now converted to a DATE field in the replicated table instead of having to be manually translated via the Replicate scripting layer.

• Introduced mirroring replication with SAP using RFC

Enhancements

All Components

• Added support for Redshift ODBC driver v. 2.0.0.0

• Added an option to file export that entirely disables the transactional info in the target schema

• Added a predefined function, ConvertToDate, to be used in the mapping when in need to convert a string into a date

Management Center

The datetime fields in the Properties dialog show date time and timezone with reference to the Server Agent. This is useful when viewing information from a remote MC

Server Agent

Enhanced performance between the Server agent and the Syniti Knowledge Platform tenant with the following changes:

• HTTP server - show all inner exceptions when an error is generated

• POST/PUT replications - moved properties field to a JSON body section

Data Access

Updated Parquet library version to v. 4.10.1

Bug Fixes

All Components

• Added a replication property, Validate on Session Start, to run a Validate before every mirroring session in order to check if all prerequisites are in place

• Fixed an issue with trigger-based replications for HANA and Oracle with the Continue And Process algorithm option where the records were not properly processed when Max Size Mirroring Block was defined

Management Center

• Fixed an issue with using the "Yes All" button for "Keep Transaction ID to resume replications..." because it did not impact all selected replications

• Fixed an issue that surfaced while editing the EnableAgentSSL property

• Fixed a transactional log settings that was being reset when changing server connection settings

• Fixed the connection to Redshift; it was incorrectly showing the driver 32-bit version

• Fixed an issue in the SQL Command panel; it was not showing the database and user name in the title bar

• Fixed a SQL Azure DB error that displayed when trying to select existing master log table

• Fixed an issue that triggered an error dialog and prevented saving when switching Insert Mode to SingleInsert for HANA connections

• Fixed an issue in the Verifier Reconcile Data when updating records using the Verify Subset of Columns option enabled

Data Access

Fixed an issue with Snowflake; nullable field metadata was not being read correctly in Syniti Replicate

Replication Agent

• Fixed an issue with Parquet; Syniti Replicate stored wrong values for internal fields (DATETIME, USER, TABLENAME, ACTION)

• Fixed a rounding issue in Oracle during mirroring bulk for the BINARY_DOUBLE data type

• Fixed an issue with Mirroring Bulk when MySQL Target database name contains special characters

• JSON data type still not supported in mirroring from MySQL but the replication does not stop anymore because the data type is now recognized and skipped

Server Agent

• Fixed an issue on Server Agent if SSL was enabled but not working

• Fixed an error when running POST/replications to target FILE when creating the target table

• Fixed alerts; Replication Agent downtime Alert timestamp didn't use the time zone information and was therefore misaligned

• Fix erroneously sending downtime alerts for mirroring replications that are correctly refreshing