Some time ago I encounter https://github.com/kawasima/solr-jdbc never tried it.Anyway, it doesn't help to connect from odbc. On top of my head, is https://cwiki.apache.org/confluence/display/solr/Exporting+Result+Sets but it returns only JSON, not csv. That's I wonder why.
Seems like a dead end so far. On Wed, Feb 25, 2015 at 6:15 PM, Hakim Benoudjit <h.benoud...@gmail.com> wrote: > Thanks for your answer. > For a one-off it seems like a nice way to import my data. > For an ODBC connection, the only solution I found is to replicate my Solr > data in Apache Hive (or Cassandra...), and then connect to that database > through ODBC. > > > 2015-02-25 15:49 GMT+01:00 Alexandre Rafalovitch <arafa...@gmail.com>: > > > Which direction? You want import data from Solr into Excel? One off or > > repeatedly? > > > > For one off Solr -> Excel, you could probably use Excel's Open from > > Web and load data directly from Solr using CSV output format. > > > > Regards, > > Alex. > > ---- > > Solr Analyzers, Tokenizers, Filters, URPs and even a newsletter: > > http://www.solr-start.com/ > > > > > > On 25 February 2015 at 08:52, Hakim Benoudjit <h.benoud...@gmail.com> > > wrote: > > > Hi there, > > > > > > I'm looking for a library to connect Solr throught ODBC to Excel in > order > > > to do some reporting on my Solr data? > > > Anybody knows a library for that? > > > > > > Thanks. > > > > > > -- > > > Cordialement, > > > Best regards, > > > Hakim Benoudjit > > > > > > -- > Cordialement, > Best regards, > Hakim Benoudjit > -- Sincerely yours Mikhail Khludnev Principal Engineer, Grid Dynamics <http://www.griddynamics.com> <mkhlud...@griddynamics.com>