The following summary highlights what is new in Connect CDC 5.8.00.00. Details of new features, platforms, and fixed problems can be found in their respective sections.
5.8.11.03
Fixed Issues
Save-while-active
and other processes were trying to save metabases and install libraries, (both in*LIBL
of the connection job), and failed because of uncommitted transactions.- An unplanned connection reset issued numerous messages regarding the QHST log.
- Duplicate transactions found in the
rp_log
. - The
prepared statements
uses theupdate statement
cache for Postgres targets causing the incorrect number of parameters to be used withUpsert statements
. - Fix for incorrect updates for a target column value mismatch from source column value.
For more information, see fixed issues for 5.8.11.03.
5.8.11.02
Fixed Issue
An issue in the temporary table management was preventing the temporary table from being cleaned after writing to RP_RBACK
and optimizing writing performances. For more information, see fixed issues for 5.8.11.02.
5.8.11.01
Fixed Issue
Rows were not getting applied to Kafka as a target. For more information, see fixed issues for 5.8.11.01.
5.8.11
- Connect CDC now supports Kafka Tombstone records. For more information, see Create a Kafka server (Confluent Cloud) with Schema Registry.
Fixed Issues
- In Connect CDC to Snowflake replication, NULLs are being replicated instead of spaces or empty fields.
- Director was setting white spaces as special values.
- Selective start copies all tables when Retrieval Order is set.
For more information, see fixed issues for 5.8.11.
5.8.10
- Connect CDC now supports GCP SQL as a target. For more information, see GCP SQL.
- For releases prior to 5.8.05, Connect CDC used High Water Mark (HWM) file for Kafka targets to keep track of transactions that have been committed successfully and possibly records that cannot be committed because of validation errors. Now, the HWM file will be skipped and the duplicate records will not be handled but written to Kafka. For more information, see FileHwmReader used to read content of HWM file.
- Connect CDC now supports IBM i custom CCSID. If the field content has a different encoding from any given metadata, then an external value will be used by the
RP_CCCSID
definitions. For more information, see Data specific decoding custom CCSID. - Model validation message for 60872 was changed from error to warning. For more information, see Model validation messages.
Fixed Issues
- Connections were getting a parse error when processing a continuation row in Oracle.
- Data may be lost after a switch occurs from redo to archive logs.
- Columns in the target table (MySQL) were not retrieved in the correct order.
For more information, see fixed issues for 5.8.10.
Known Issue
- The compressed table records were not being captured and written to the metabase tables. For more information, proposed solution.
5.8.09
- Connect CDC now supports Kafka Tombstone records. Kafka topics can be configured to delete old records with the same key and only keep the most recent one in a topic partition. For more information, see TombstoneHandler.
- Connect CDC now supports before and after image in same record. For more information, refer to Create a new server for Kafka.
- Connect CDC now supports SSL ports for IBMi services. For more information, refer to Prerequisites for IBMi servers.
- CyberArk support was added for IBMi. For more information, refer to Create a new server for DB2/400.
- For issues fixed in 5.8.09, see Fixed issues for 5.8.09.
5.8.07
- Previously, the JDBC drivers were supplied for MySQL. As of 5.8.07, with MySQL 8 support, the drivers will be removed and you can choose your own driver and location during the Connect CDC installation. For more information, see JDBC Drivers.
- As of 5.8.07, "." (dot) in the schema names and library names for IBMi are now supported.
- Connect CDC now supports SQL Server 2022 as both a source and a target.
5.8.06
- Connect CDC supports Azure Event Hub. For more information, see Create a New Server for EventHub in Getting Started.Note: Azure Schema Registry is not yet supported.
- SQL Server JDBC driver has been upgraded to version 10.2.1. This version of the driver does not support SQL Server 2008 or SQL Server 2008 R2, and therefore support for these DBMS versions have been discontinued.
- Support for Windows Server 2008 and Windows Server 2008 R2 platforms have been discontinued. Extended support for these platforms was ended by Microsoft as of January 2020.
- Connect CDC now supports the Avro logical decimal types. For more information, see Kafka.
5.8.05
- Connect CDC now supports Postgres as a source, see PostgreSQL for more information.
5.8.04
- IBMi Change Selector supports custom libraries from OMNIREP JOBD.
5.8.03
- DB2 LUW remote host support
5.8.00
- SQL Server remote host support on Linux
- IBMi CS Rollback Agent to manage rollback from queue table
- Oracle support for MAX_STRING_SIZE=EXTENDED