cancel
Showing results for 
Search instead for 
Did you mean: 

Moving data from Kafka to HANA (via Kafka Connect / JDBC)

mth42
Participant
0 Kudos

Hello all

Let's assume I want to connect HANA and Kafka via Kafka Connect (not Streaming Analytics/SDS or DataHub, or something similar), there seem to be mainly two options:

- Kafka Connect JDBC
- Kafka Connect for HANA from SAP: https://github.com/SAP/kafka-connect-sap

What I am not sure about is why should I choose on or the other? Both seem to use the HANA JDBC driver. The one from Confluent is officialy supported, while the one from SAP seems to be "no support, use at your own risk".

What are the "unique selling points" of using the code from github, compared to the Confluent supported JDBC Kafka connect?

srinivasanss2
Explorer
0 Kudos

Hi Matthias, I am trying to integrate KAFKA with HANA using Confluent JDBC Connector. I tried all the options I am getting JDBC Error and I came to know that Confluent JDBC Connector is not supported for SAP HANA. Could you pl help on this.

Thanks,

Srini

Accepted Solutions (0)

Answers (2)

Answers (2)

lbreddemann
Active Contributor

As often the comparison between general JDBC driver support (for any DBMS) and DB specific JDBC support comes down to enabling DB-specific (in this case HANA-specific) functionality.

Things like table partitioning and the choice between row and column tables can be important for HANA but are not covered by the general JDBC driver support.

Not sure how much difference in the "support offering" there is between both options...

0 Kudos

Hello, when I integrated Kafka connect and Hana, Kafka connect could not load the table. However, I have configured the table name in the Kafka properties file. The format of the parameter is: table.name=SYSTEM ."HANA_ Users ", Kafka conncet's loading error message is: a table name or query must be specified for Hana Kafka connectors to work. Is there a solution to this problem?