- 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.
Twitter : @dadoonet / @elasticsearchfr
Le 15 juin 2012 à 19:23, Kong email@example.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.
- Is Elasticsearch river support automatic failover?
- Can you help me to provide resource or example code for database river?