Elasticsearch River for database


(Kong) #1

Hi, I am new to Elasticsearch. I want to populate updated data from sql
server database to Elasticsearch index, but i have some questions that not
clear in detail.

  1. Is Elasticsearch river support automatic failover?
  2. Can you help me to provide resource or example code for database river?

Thank You
Kong


(David Pilato) #2
  1. yes
  2. it doesn't exist as sending docs from a YesSQL database to a NoSQL store is not trivial.

You should consider to use an ETL to extract your data (SQL, joins, ...), transform to a JSON Doc and Load it to ES.

A river could make sense, if you have a "last update field" somewhere but it's really specific to your SQL schema.

Btw, You can grab source code from CouchDb River to start.

My 2 cents.
David :wink:
Twitter : @dadoonet / @elasticsearchfr

Le 15 juin 2012 à 19:23, Kong n4kong@gmail.com a écrit :

Hi, I am new to Elasticsearch. I want to populate updated data from sql server database to Elasticsearch index, but i have some questions that not clear in detail.

  1. Is Elasticsearch river support automatic failover?
  2. Can you help me to provide resource or example code for database river?

Thank You
Kong


(Jörg Prante) #3

I hope my JDBC river implementation at
https://github.com/jprante/elasticsearch-river-jdbc is useful.

Best regards,

Jörg

On Friday, June 15, 2012 7:23:22 PM UTC+2, Kong wrote:

Hi, I am new to Elasticsearch. I want to populate updated data from sql
server database to Elasticsearch index, but i have some questions that not
clear in detail.

  1. Is Elasticsearch river support automatic failover?
  2. Can you help me to provide resource or example code for database river?

Thank You
Kong


(system) #4