You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by veryblues_cn <lh...@gmail.com> on 2012/08/09 09:15:12 UTC
Can I import datasource from SQL sever or Orcale
Hi all,
It seems like possible to deploy solr 1.4 with SQL sever ,but not sure about
the latest version,3.6 even 4.
Of course, it is perfect to use Oracle for the project I am going to
start.But I am not sure about the
difficulties in development,you know,there are many issues like developing
search GUI , how
to crawl the intranet of my company,and so on . I have researched for the
issues for two weeks
but it is still pending.So exhausted.....
Actually ,the more I know about solr ,the more problems occur to me, can any
one give me some idea?
thank you
--
View this message in context: http://lucene.472066.n3.nabble.com/Can-I-import-datasource-from-SQL-sever-or-Orcale-tp4000060.html
Sent from the Solr - User mailing list archive at Nabble.com.
Re: Can I import datasource from SQL sever or Orcale
Posted by veryblues_cn <lh...@gmail.com>.
Hi Tomas,
I really agree with your opinion, and your answear is detailed and useful
to me. As a newbie in solr, I
think I still have so much to learn to use it in a project.And the book you
mentioned is really useful, and
to be honest, I have read some of that, but not so clear about some of the
useage. It seems I need to be
study further on it. Thanks for your idea !!!!! :)
best regards
2012/8/9 Tomás Fernández Löbbe [via Lucene] <
ml-node+s472066n4000131h9@n3.nabble.com>
> Hi, you can index content from any database that has a JDBC driver with
> Data Import Handler. see http://wiki.apache.org/solr/DataImportHandler
> As for crawling your company's website, Solr doesn't crawl, it can be used
> to search across the crawled content but you'll have to crawl yourself or
> with some other tool. You can take a look at Nutch
> http://nutch.apache.org/
> For GUI, there are lot's of possibilities too. For fast prototyping you
> could use the velocity response writer
> http://wiki.apache.org/solr/VelocityResponseWriter or "Ajax- Solr"
> https://github.com/evolvingweb/ajax-solr/ but for a more complex UI you
> can
> use any tool you want to and communicate through Solr either using SolrJ
> (if you use Java for the front-end app) any other client (
> http://wiki.apache.org/solr/IntegratingSolr)
> Finally, if you are having troubles understanding Solr I would take a look
> at any of these books: http://lucene.apache.org/solr/books.html, The wiki
> and blogs around are great, but In my opinion it's much easier to start by
> reading from an organized source that explains things step by step, then
> jump to wiki/blogs/source/javadocs for specific things.
>
> Tomás
>
> On Thu, Aug 9, 2012 at 4:15 AM, veryblues_cn <[hidden email]<http://user/SendEmail.jtp?type=node&node=4000131&i=0>>
> wrote:
>
> > Hi all,
> > It seems like possible to deploy solr 1.4 with SQL sever ,but not sure
> > about
> > the latest version,3.6 even 4.
> >
> > Of course, it is perfect to use Oracle for the project I am going to
> > start.But I am not sure about the
> >
> > difficulties in development,you know,there are many issues like
> developing
> > search GUI , how
> >
> > to crawl the intranet of my company,and so on . I have researched for
> the
> > issues for two weeks
> >
> > but it is still pending.So exhausted.....
> >
> > Actually ,the more I know about solr ,the more problems occur to me, can
> > any
> > one give me some idea?
> >
> > thank you
> >
> >
> >
> > --
> > View this message in context:
> >
> http://lucene.472066.n3.nabble.com/Can-I-import-datasource-from-SQL-sever-or-Orcale-tp4000060.html
> > Sent from the Solr - User mailing list archive at Nabble.com.
> >
>
>
> ------------------------------
> If you reply to this email, your message will be added to the discussion
> below:
>
> http://lucene.472066.n3.nabble.com/Can-I-import-datasource-from-SQL-sever-or-Orcale-tp4000060p4000131.html
> To unsubscribe from Can I import datasource from SQL sever or Orcale, click
> here<http://lucene.472066.n3.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4000060&code=bGhudWFhQGdtYWlsLmNvbXw0MDAwMDYwfDQzMzA3NTQzMg==>
> .
> NAML<http://lucene.472066.n3.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
>
--
View this message in context: http://lucene.472066.n3.nabble.com/Can-I-import-datasource-from-SQL-sever-or-Orcale-tp4000060p4000200.html
Sent from the Solr - User mailing list archive at Nabble.com.
Re: Can I import datasource from SQL sever or Orcale
Posted by Tomás Fernández Löbbe <to...@gmail.com>.
Hi, you can index content from any database that has a JDBC driver with
Data Import Handler. see http://wiki.apache.org/solr/DataImportHandler
As for crawling your company's website, Solr doesn't crawl, it can be used
to search across the crawled content but you'll have to crawl yourself or
with some other tool. You can take a look at Nutch http://nutch.apache.org/
For GUI, there are lot's of possibilities too. For fast prototyping you
could use the velocity response writer
http://wiki.apache.org/solr/VelocityResponseWriter or "Ajax- Solr"
https://github.com/evolvingweb/ajax-solr/ but for a more complex UI you can
use any tool you want to and communicate through Solr either using SolrJ
(if you use Java for the front-end app) any other client (
http://wiki.apache.org/solr/IntegratingSolr)
Finally, if you are having troubles understanding Solr I would take a look
at any of these books: http://lucene.apache.org/solr/books.html, The wiki
and blogs around are great, but In my opinion it's much easier to start by
reading from an organized source that explains things step by step, then
jump to wiki/blogs/source/javadocs for specific things.
Tomás
On Thu, Aug 9, 2012 at 4:15 AM, veryblues_cn <lh...@gmail.com> wrote:
> Hi all,
> It seems like possible to deploy solr 1.4 with SQL sever ,but not sure
> about
> the latest version,3.6 even 4.
>
> Of course, it is perfect to use Oracle for the project I am going to
> start.But I am not sure about the
>
> difficulties in development,you know,there are many issues like developing
> search GUI , how
>
> to crawl the intranet of my company,and so on . I have researched for the
> issues for two weeks
>
> but it is still pending.So exhausted.....
>
> Actually ,the more I know about solr ,the more problems occur to me, can
> any
> one give me some idea?
>
> thank you
>
>
>
> --
> View this message in context:
> http://lucene.472066.n3.nabble.com/Can-I-import-datasource-from-SQL-sever-or-Orcale-tp4000060.html
> Sent from the Solr - User mailing list archive at Nabble.com.
>