2

This question was probably asked multiple times but I still can't find definite answer.

I have a table in a SQL Server database. Data inserted into the table constantly. Nothing gets deleted or updated. Each row has unique id and date column. I want to index this table in ES. Initial index plus all the new inserts coming in. If possible to create a separated index per day.

What is available today. I see that revers deprecated. Found this JDBC importer. is that's the one to use? Logstash?

Thanks in advance.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Igor K.
  • 915
  • 2
  • 12
  • 22
  • What platform are you building this on? Do you have access to .net or are you using some other language. NEST has been one tool we use which allows us easy integration between ES and .net. This allows us to use .net to assemble the data and NEST to build the mapping, and submission. https://nest.azurewebsites.net/nest/quick-start.html – rlcrews Dec 22 '15 at 16:15
  • 1
    I would go with the Logstash JDBC input. How about this answer? http://stackoverflow.com/questions/31674583/logstash-sql-server-data-import – Val Dec 22 '15 at 16:17
  • I am planing to use NEST for reading data from ES. As more I read I see people still use JDBC river or Logstash to import data. – Igor K. Dec 22 '15 at 16:20
  • @Val, just came across your suggestion and really leaning to this solution. Thanks. – Igor K. Dec 22 '15 at 16:28

0 Answers0