Skip to content

Instantly share code, notes, and snippets.

@davidsf
Last active December 18, 2015 23:08
Show Gist options
  • Save davidsf/5859062 to your computer and use it in GitHub Desktop.
Save davidsf/5859062 to your computer and use it in GitHub Desktop.
SqlServer Json River
{
"type":"jdbc",
"jdbc": {
"driver":"com.microsoft.sqlserver.jdbc.SQLServerDriver",
"url":"jdbc:sqlserver://ipaddress:port;databaseName=mydatabase",
"user":"myuser","password":"mypass",
"sql":"select * from table",
"poll":"30s"
},
"index": {
"index": "myindex",
"type": "mytype"
}
}
@davidsf
Copy link
Author

davidsf commented Jun 25, 2013

Create the river with: curl -XPUT localhost:9200/_river/my_jdbc_river/_meta -d @myriver.json

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment