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:
- installed JDBC jar and plugin into ES.
- 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.