does Sqlanywhere17 support Apache Kafka

[former_SQLA_member1694929]

kafka-connector cannot connect to sqlanywhere17 with jdbc driver.

i have sajdbc4.jar and libdbjdbc17.so in dirctory /usr/share/java/kafka-connect-jdbc/

{

  "connector.class": "io.confluent.connect.jdbc.JdbcSourceConnector",
  "connection.url": "jdbc:sqlanywhere://host:port/demo?UID=rmoff?PWD=rmoffsql",
  "mode":"bulk",
  "topic.prefix":"sql-01-"
}'

Thanks in advance

[Vlad]

I am lazy to install Kafka, maybe you can post an error message from Kafka's logs for us?

I think, I am not the only one in this forum, who is lazy too and will not install Kafka for you only.

[Breck_Carter]

Me too, I'm lazy, who's Kafka?

[chris_keating]

The problem is the connection URL is incorrectly formed. It should be of the form:

jdbc:sqlanywhere:HOST=host:port;Server=<db_server_name>;DBN=demo;UID=rmoff;PWD=rmoffsql

The Server parameter is optional but strongly recommended. It will be the database server engine name.