On Wed, Feb 25, 2015 at 10:31 PM, Hakim Benoudjit <h.benoud...@gmail.com> wrote:
> 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. > not really. /export yields much more data faster. Also, if you are interested in relatively short result set, you can /select&wt=csv no facets in this case, sadly. Just fyi. > > 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 > -- Sincerely yours Mikhail Khludnev Principal Engineer, Grid Dynamics <http://www.griddynamics.com> <mkhlud...@griddynamics.com>