Thanks for the two links. The first one could be helpful if it works. Regarding the second one, I think it's quite similar to using /select to return json format.
2015-02-25 19:10 GMT+01:00 Mikhail Khludnev <mkhlud...@griddynamics.com>: > 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> > -- Cordialement, Best regards, Hakim Benoudjit
