Thanks to all of you for the valuable inputs. Being on J2ee platform I also felt using solrJ in a multi threaded environment would be a better choice to index RDBMS data into SolrCloud. I will try with a scheduler triggered micro service to do the job using SolrJ.
Regards, Vishal On Fri, Mar 17, 2017 at 9:11 PM, Alexandre Rafalovitch <arafa...@gmail.com> wrote: > One assumes by hooking into the same code that updates RDBMS, as > opposed to be reverse engineering the changes from looking at the DB > content. This would be especially the case for Delete changes. > > Regards, > Alex. > ---- > http://www.solr-start.com/ - Resources for Solr users, new and experienced > > > On 17 March 2017 at 11:37, OTH <omer.t....@gmail.com> wrote: > >> > >> Also, solrj is good when you want your RDBMS updates make immediately > >> available in solr. > > > > How can SolrJ be used to make RDBMS updates immediately available? > > Thanks > > > > On Fri, Mar 17, 2017 at 2:28 PM, Sujay Bawaskar <sujaybawas...@gmail.com > > > > wrote: > > > >> Hi Vishal, > >> > >> As per my experience DIH is the best for RDBMS to solr index. DIH with > >> caching has best performance. DIH nested entities allow you to define > >> simple queries. > >> Also, solrj is good when you want your RDBMS updates make immediately > >> available in solr. DIH full import can be used for index all data first > >> time or restore index in case index is corrupted. > >> > >> Thanks, > >> Sujay > >> > >> On Fri, Mar 17, 2017 at 2:34 PM, vishal jain <jain02...@gmail.com> > wrote: > >> > >> > Hi, > >> > > >> > > >> > I am new to Solr and am trying to move data from my RDBMS to Solr. I > know > >> > the available options are: > >> > 1) Post Tool > >> > 2) DIH > >> > 3) SolrJ (as ours is a J2EE application). > >> > > >> > I want to know what is the recommended way for Data import in > production > >> > environment. > >> > Will sending data via SolrJ in batches be faster than posting a csv > using > >> > POST tool? > >> > > >> > > >> > Thanks, > >> > Vishal > >> > > >> > >> > >> > >> -- > >> Thanks, > >> Sujay P Bawaskar > >> M:+91-77091 53669 > >> >
