I got it to work! This is an excellent article for importing SQL Server data in to your index.
http://www.chrisumbel.com/article/lucene_solr_sql_server <http://www.chrisumbel.com/article/lucene_solr_sql_server>Adam On Wed, Dec 15, 2010 at 8:43 AM, Adam Estrada <estrada.a...@gmail.com>wrote: > Thanks All, > > Testing here shortly and will report back asap. > > w/r, > Adam > > > On Wed, Dec 15, 2010 at 4:10 AM, Savvas-Andreas Moysidis < > savvas.andreas.moysi...@googlemail.com> wrote: > >> Hi Adam, >> >> we are using DIH to index off an SQL Server database(the freeby SQLExpress >> one.. ;) ). We have defined the following in our >> %TOMCAT_HOME%\solr\conf\data-config.xml: >> <dataConfig> >> >> <dataSource type="JdbcDataSource" >> name="mssqlDatasource" >> driver="net.sourceforge.jtds.jdbc.Driver" >> url="jdbc:jtds:sqlserver://{server.name >> }:{server.port}/{dbInstanceName};instance=SQLEXPRESS" >> convertType="true" >> user="{user.name}" >> password="{user.password}"/> >> <document> >> <entity name="id" >> dataSource="mssqlDatasource" >> query="your query here" /> >> </document> >> </dataConfig> >> >> We downloaded a JDBC driver from here >> http://jtds.sourceforge.net/faq.html and >> found it to be a quite stable driver. >> >> And the only thing we really had to do was drop that library in >> %TOMCAT_HOME%\lib directory (for Tomcat 6+). >> >> Hope that helps. >> -- Savvas. >> >> On 14 December 2010 22:46, Erick Erickson <erickerick...@gmail.com> >> wrote: >> >> > The config isn't really any different for various sql instances, about >> the >> > only difference is the driver. Have you seen the example in the >> > distribution somewhere like >> > <solr_home>/example/example-DIH/solr/db/conf/db-data-config.xml? >> > >> > Also, there's a magic URL for debugging DIH at: >> > .../solr/admin/dataimport.jsp >> > >> > If none of that is useful, could you post your attempt and maybe someone >> > can >> > offer some hints? >> > >> > Best >> > Erick >> > >> > On Tue, Dec 14, 2010 at 5:32 PM, Adam Estrada < >> > estrada.adam.gro...@gmail.com >> > > wrote: >> > >> > > Does anyone have an example config.xml file I can take a look at for >> SQL >> > > Server? I need to index a lot of data from a DB and can't seem to >> figure >> > > out >> > > the right syntax so any help would be greatly appreciated. What is the >> > > correct /jar file to use and where do I put it in order for it to >> work? >> > > >> > > Thanks, >> > > Adam >> > > >> > >> > >
