Elastic Search River for SQL Server- No Suitable Driver

Elastic Stack Elasticsearch
1

I am trying to fetch data in ES from SQL Server using Microsoft JDBC Driver. I have placed the files

  • sqljdbc4.jar

  • sqljdbc4.1
    in the lib folder of Elastic Search.

    {
    "type": "jdbc",
    "jdbc": {
    "driver": "com.microsoft.sqlserver.jdbc.SQLServerDriver",
    "url": "jdbc:sqlserver://databaserserver;databaseName=DB_NAME",
    "user": "username",
    "password": "Password",
    "sql": "select * from tableName",
    "poll": "30s"
    },
    "index": {
    "index": "indexName",
    "type": "typeName",
    "bulk_size": 500
    }}

However when i run the river i get the following error.
No suitable driver found for jdbc:sqlserver://databaserserver;databaseName=DB_NAME

What am i missing here.

2

Rivers have been deprecated for a long time so I'm not sure it is worth trying to figure this out.... Maybe look at logstash's jdbc?

1 Like