// Category: debezium-using
// Type: assembly
// ModuleID: developing-debezium-custom-data-type-converters
// Title: Developing {prodname} custom data type converters
[id="custom-converters"]
= Custom Converters

ifdef::community[]
:source-highlighter: highlight.js
:toc:
:toc-placement: macro
:linkattrs:
:icons: font
toc::[]

[NOTE]
====
This feature is currently in incubating state, i.e. exact semantics, configuration options etc. may change in future revisions, based on the feedback we receive. Please let us know if you encounter any problems while using this extension.
====

== Datatype Conversion
endif::community[]

ifdef::product[]
[IMPORTANT]
====
The use of custom-developed converters is a Technology Preview feature only.
Technology Preview features are not supported with Red Hat production service level agreements (SLAs) and might not be functionally complete.
Red Hat does not recommend using them in production.
These features provide early access to upcoming product features, enabling customers to test functionality and provide feedback during the development process.
For more information about the support scope of Red Hat Technology Preview features, see link:https://access.redhat.com/support/offerings/techpreview[https://access.redhat.com/support/offerings/techpreview].
====
endif::product[]

Each field in a {prodname} change event record represents a field or column in the source table or data collection.
When a connector emits a change event record to Kafka, it converts the data type of each field in the source to a Kafka Connect schema type.
Column values are likewise converted to match the schema type of the destination field.
For each connector, a default mapping specifies how the connector converts each data type.
These default mappings are described in the data types documentation for each connector.

While the default mappings are generally sufficient, for some applications you might want to apply an alternate mapping.
For example, you might need a custom mapping if the default mapping exports a column using the format of milliseconds since the UNIX epoch, but your downstream application can only consume the column values as formatted strings.
You customize data type mappings by developing and deploying a custom converter.
You configure custom converters to act on all columns of a certain type, or you can narrow their scope so that they apply to a specific table column only.
The converter function intercepts data type conversion requests for any columns that match a specified criteria, and then performs the specified conversion.
The converter ignores columns that do not match the specified criteria.

Custom converters are Java classes that implement the {prodname} service provider interface (SPI).
You enable and configure a custom converter by setting the `converters` property in the connector configuration.
The `converters` property specifies the converters that are available to a connector, and can include sub-properties that further modify conversion behavior.

After you start a connector, the converters that are enabled in the connector configuration are instantiated and are added to a registry.
The registry associates each converter with the columns or fields for it to process.
Whenever {prodname} processes a new change event, it invokes the configured converter to convert the columns or fields for which it is registered.

[NOTE]
====
The instructions that follow apply to {prodname} relational database source connectors only.
You cannot use this information to create a custom converter for the {prodname} MongoDB connector, or for the {prodname} JDBC sink connector.
====

// Type: assembly
// Title: Creating a {prodname} custom data type converter
// ModuleID: creating-a-debezium-custom-data-type-converter
[id="implementing-a-custom-converter"]
== Implementing custom converters

The following example shows a converter implementation of a Java class that implements the interface `io.debezium.spi.converter.CustomConverter`:

[source,java,indent=0]
----
public interface CustomConverter<S, F extends ConvertedField> {

    @FunctionalInterface
    interface Converter {  // <1>
        Object convert(Object input);
    }

    public interface ConverterRegistration<S> { // <2>
        void register(S fieldSchema, Converter converter); // <3>
    }

    void configure(Properties props);

    void converterFor(F field, ConverterRegistration<S> registration); // <4>
}
----
.Descriptions of fields in a Java converter class that implements the `io.debezium.spi.converter.CustomConverter` interface
[cols="1,7",options="header",subs="+attributes"]
|===
|Item |Description

|1
|Converts data from one type to another.

|2
|Callback for registering a converter.

|3
|Registers the given schema and converter for the current field.
Should not be invoked more than once for the same field.

|4
|Registers the customized value and schema converter for use with a specific field.

|===

[id="debezium-custom-converter-methods"]
=== Custom converter methods

Implementations of the `CustomConverter` interface must include the following methods:

`configure()`::
Passes the properties specified in the connector configuration to the converter instance.
The `configure` method runs when the connector is initialized.
You can use a converter with multiple connectors and modify its behavior based on the connector's property settings. +
The `configure` method accepts the following argument:

`props`::: Contains the properties to pass to the converter instance.
Each property specifies the format for converting the values of a particular type of column.

`converterFor()`::
Registers the converter to process specific columns or fields in the data source.
{prodname} invokes the `converterFor()` method to prompt the converter to call `registration` for the conversion.
The `converterFor` method runs once for each column. +
The method accepts the following arguments:

`field`:::
An object that passes metadata about the field or column that is processed.
The column metadata can include the name of the column or field, the name of the table or collection, the data type, size, and so forth.

`registration`:::
An object of type `io.debezium.spi.converter.CustomConverter.ConverterRegistration` that provides the target schema definition and the code for converting the column data.
The converter calls the `registration` parameter when the source column matches the type that the converter should process.
  calls the `register` method to define the converter for each column in the schema.
Schemas are represented using the Kafka Connect link:https://kafka.apache.org/31/javadoc/org/apache/kafka/connect/data/SchemaBuilder.html[`SchemaBuilder`] API.
ifdef::community[]
In the future, an independent schema definition API will be added.
endif::community[]

// Type: concept
[id="debezium-custom-converter-example"]
=== {prodname} custom converter example

The following example implements a simple converter that performs the following operations:

* Runs the `configure` method, which configures the converter based on the value of the `schema.name` property that is specified in the connector configuration.
The converter configuration is specific to each instance.
* Runs the `converterFor` method, which registers the converter to process values in source columns for which the data type is set to `isbn`.
** Identifies the target `STRING` schema based on the value that is specified for the `schema.name` property.
** Converts ISBN data in the source column to `String` values.

[id="example-debezium-simple-custom-converter"]
.A simple custom converter
====
[source,java,indent=0]
----
    public static class IsbnConverter implements CustomConverter<SchemaBuilder, RelationalColumn> {

        private String isbnSchemaName;

        @Override
        public void configure(Properties props) {
            isbnSchemaName = props.getProperty("schema.name");
        }

        @Override
        public void converterFor(RelationalColumn column,
                ConverterRegistration<SchemaBuilder> registration) {

            if ("isbn".equals(column.typeName())) {
                registration.register(SchemaBuilder.string().name(isbnSchemaName)), x -> x.toString());
            }
        }
    }
----
====

// Type: concept
[id="debezium-and-kafka-connect-api-module-dependencies"]
=== {prodname} and Kafka Connect API module dependencies

A custom converter Java project has compile dependencies on the {prodname} API and Kafka Connect API library modules.
These compile dependencies must be included in your project's `pom.xml`, as shown in the following example:

[source,xml]
----
<dependency>
    <groupId>io.debezium</groupId>
    <artifactId>debezium-api</artifactId>
    <version>${version.debezium}</version> // <1>
</dependency>
<dependency>
    <groupId>org.apache.kafka</groupId>
    <artifactId>connect-api</artifactId>
    <version>${version.kafka}</version> <2>
</dependency>
----
[cols="1,7",options="header",subs="+attributes"]
.Descriptions of compile dependency versions in `pom.xml`
|===
|Item |Description

|1
|`${version.debezium}` represents the version of the {prodname} connector.

|2
|`${version.kafka}` represents the version of Apache Kafka in your environment.

|===


// Type: assembly
// Title: Using custom converters with {prodname} connectors
// ModuleID: deploying-and-configuring-debezium-custom-data-type-converters
[id="configuring-and-using-converters"]
== Configuring and Using Converters

Custom converters act on specific columns or column types in a source table to specify how to convert the data types in the source to Kafka Connect schema types.
To use a custom converter with a connector, you deploy the converter JAR file alongside the connector file, and then configure the connector to use the converter.

[IMPORTANT]
====
Custom converters are designed to modify messages emitted by {prodname} relational database source connectors.
You cannot configure either the {prodname} MongoDB connector, or the {prodname} JDBC sink connector to use a custom converter.
====

// Type: procedure
[id="deploying-a-debezium-custom-converter"]
=== Deploying a custom converter

.Prerequisites
* You have a custom converter Java program.

.Procedure
* To use a custom converter with a {prodname} connector, export the Java project to a JAR file, and copy the file to the directory that contains the JAR file for each {prodname} connector that you want to use it with. +
 +
For example, in a typical deployment, the {prodname} connector files are stored in subdirectories of a Kafka Connect directory (`/kafka/connect`), with each connector JAR in its own subdirectory (`/kafka/connect/debezium-connector-db2`, `/kafka/connect/debezium-connector-mysql`, and so forth).
To use a converter with a connector, add the converter JAR file to the connector's subdirectory.

NOTE: To use a converter with multiple connectors, you must place a copy of the converter JAR file in each connector subdirectory.

// Type: procedure
[id="configuring-a-connectors-to-use-a-custom-converter"]
=== Configuring a connector to use a custom converter

To enable a connector to use the custom converter, add properties to specify the name and class of the converter to the configuration of a {prodname} source connector.
You cannot configure the {prodname} JDBC sink connector to use a custom converter.
If the converter requires further information to customize the formats of specific data types, you can define other configuration options to provide that information.

.Prerequisites

* You xref:implementing-a-custom-converter[created] and xref:deploying-a-debezium-custom-converter[deployed a custom converter].
* A {prodname} relational database source connector is deployed.

.Procedure

* Enable a converter for a connector instance by adding the following mandatory properties to the connector configuration:
+
[subs="+quotes"]
----
converters: _<converterSymbolicName>_ // <1>
_<converterSymbolicName>_.type: _<fullyQualifiedConverterClassName>_ // <2>
----
+
[cols="1,7a",options="header",subs="+attributes"]
.Description of connector configuration properties for enabling a converter
|===
|Item |Description

|1
|The mandatory `converters` property enumerates a comma-separated list of symbolic names of the converter instances to use with the connector.
The values listed for this property serve as prefixes in the names of other properties that you specify for the converter.

|2
|The mandatory `_<converterSymbolicName>_.type` property specifies the name of the class that implements the converter.

|===
+
For example, for the earlier xref:example-debezium-simple-custom-converter[custom converter example], you would add the following properties to the connector configuration:
+
----
converters: isbn
isbn.type: io.debezium.test.IsbnConverter
----

* To associate other properties with a custom converter, prefix the property names with the symbolic name of the converter, followed by a dot (`.`).
  The symbolic name is a label that you specify as a value for the `converters` property.
  For example, to add a property for the preceding `isbn` converter to specify the `schema.name` to pass to the `configure` method in the converter code, add the following property:
+
----
isbn.schema.name: io.debezium.postgresql.type.Isbn
----
