Capabilities for Apache Kafka

This section lists the Capabilities of Fivetran HVR when using 'Apache Kafka'. For more information about the pre-requisites, access privileges, and other configuration requirements, see Apache Kafka Requirements.

Capture

HVR does not support Capture changes from location on Apache Kafka.

Repository Database

HVR does not support Repository Database on Apache Kafka.

Integrate

HVR supports the following capabilities on Apache Kafka:

• Integrate changes into location (Apache Kafka version 0.8).
• Continuous integration (Integrate with parameter Method=CONTINUOUS) (Apache Kafka version 0.8).
• ColumnProperties with parameter SoftDelete (Apache Kafka version 0.8).

HVR does not support the following capabilities on Apache Kafka:

• Burst integration (Integrate with parameter Method=BURST).
• Integrate with parameter BurstCommitFrequency.
• Tables without a key and without TableProperties with NoDuplicateRows for continuous integration.
• Continuous integrate with parameter OnErrorSaveFailed.
• Disable/enable database triggers during integrate (with parameter NoTriggerFiring).
• Creation and update of HVR state tables.
• Integrate with parameter DbProc.

Bi-directional Replication

HVR does not support Bi-directional Replication on Apache Kafka.

Refresh and Compare

HVR supports the following capabilities on Apache Kafka:

• hvrrefresh into target location (Apache Kafka version 0.8).

HVR does not support the following capabilities on Apache Kafka:

• hvrrefresh or hvrcompare from source location.

Other Capabilities

HVR supports the following capabilities on Apache Kafka:

• Use distribution key for parallelizing changes within a table (ColumnProperties with parameter DistributionKey) (Apache Kafka from version 0.7 to version 0.8).
• International table and column names where DBMS is not configured with UTF-8 encoding (Apache Kafka version 0.8).

HVR does not support the following capabilities on Apache Kafka:

• Lossless binary float datatypes. No data loss when transporting float values (because base 2 fractions are never converted to base 10). The values for these datatypes, when selected back from the database, might be slightly different from the ones that were inserted. This leads to Compare differences..