Step by step recipe for setting up the river with SQL Server

Suggested reading: SQL Server and Elastic Search Sitting In A Tree...

1. Download ElasticSearch.

2. Download SQL Server JDBC driver from here

3. Download the latest version of elasticsearch-river-jdbc using the plugin downloader. i.e. navigate to the elasticsearch folder on your computer and run...

./bin/plugin -install river-jdbc -url http://bit.ly/1ctvKka

4. (optional) Download Sense the chrome plugin. This will make it easy to search, add/remove rivers etc

5)set up the database you want to be indexed. this includes allowing TCP/IP connections

6. fire up elastic search using the bat file

./elasticsearch.bat

6)in sense set up the river like this

put _river/scorecards_river/_meta
{
    "type":"jdbc",
    "jdbc": {
        "driver":"com.microsoft.sqlserver.jdbc.SQLServerDriver", 
        "url":"jdbc:sqlserver://localhost:1433;databaseName=ICFV",
        "user":"elasticsearch",
        "password":"elasticsearch",
        "sql":"select * from ScoreCards",
        "poll":"30s"
    }
}

You should see the river parsing the incoming data from the database in the CL