on 01-06-2020 12:18 PM
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?
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...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.