lucene-general mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "vrparekh@gmail.com" <vrpar...@gmail.com>
Subject how to schedule data import from database in solr
Date Fri, 15 Apr 2011 05:45:37 GMT
Hello,

I am new to solr,

my requirements are,

1. at regular interval need solr to fetch data from sql server database and
do indexing on it.
2. fetch only those records which is not yet indexed
3. for each record there is one file associated, so with database table
fields also want to index content of that particular file 

e.g. there is one table "Customer" in database and customerid is primary key
       for each customerid there is associated file of that customerprofile
named with customerid,

4. as i metioned above that when solr fetch data from sql server database
table , should fetch only data which is not yet indexed, (we have one older
lucene code, in which there is one field in table that isindexed so when
fetching data in select clause there is one condition that isindexed=false,
and when indexing is done update particular record of database with
isindexed=true) is there any mechanism in solr for that?

how to achieve same ? 
do i need to write custom code for that or it can be done with configuration
provided by solr?

Thanks,

Vishal Parekh

--
View this message in context: http://lucene.472066.n3.nabble.com/how-to-schedule-data-import-from-database-in-solr-tp2823473p2823473.html
Sent from the Lucene - General mailing list archive at Nabble.com.

Mime
View raw message