JDBC plugins with elasticsearch-1.5.2


(Roshan Kumar C Mutha) #1

I saw many people using JDBC plugins to import table data in Elastic search. i am not able to use it from last two days.
MY Requirement : I need to get data from mssql table to my elastic search.
ES : elasticsearch-1.5.2
MSSQL : Database server used is MS SQL Server 2008 R2.
I have used version 1.4 and 1.6 but not able to proceed.
Example used:

  1. installed JDBC jar and plugin into ES.
  2. Created river.
    http://localhost:9200/_river/riskevent/_meta
    {
    "type":"jdbc",
    "jdbc": {
    "driver":"com.microsoft.sqlserver.jdbc.SQLServerDriver",
    "url":"jdbc:sqlserver://localhost:1433;databaseName=db",
    "user":"fd","password":"pass",
    "sql":"select * from mytable",
    "poll":"30s"
    },
    "index": {
    "index":"riskevent",
    "type":"risk",
    "bulk_size":1000
    }
    }

Reference : http://nitschinger.at/Elastic-Search-and-SQL-Server-are-sitting-in-a-tree

Thanks in advance.


(system) #2