That's interesting that you were able to setup OpenLink. At Alfresco we've done quite a bit of work on the Solr's JDBC driver to integrate it with the Alfresco repository, which uses Solr. But we haven't yet tackled the ODBC setup. That will come very soon. To really take advantage of Tableau's capabilities we will need to add joins to Solr's parallel SQL. Solr already uses Apache Calcite, which has a join optimizer, so mainly this would involve hooking up the various Streaming Expression joins.
Joel Bernstein http://joelsolr.blogspot.com/ On Mon, Jun 18, 2018 at 6:37 PM, Aroop Ganguly <aroopgang...@icloud.com> wrote: > Ok I was able to setup the odic bridge (using OpenLink) and I see the > collections popping up in Tableau too. > But I am unable to actually get data flowing into Tableau reports because, > Tableau keeps creating inner queries and Solr seems to hate inner queries. > Is there a way to do inner queries in Solr Parallel Sql ? > > > On Jun 18, 2018, at 12:30 PM, Aroop Ganguly <aroopgang...@icloud.com> > wrote: > > > > > > Hi Everyone > > > > I am not sure if something has been done on this yet, though I did see a > JIRA with links to the parallel sql documentation, but I do not think that > answers the question. > > > > I love the jdbc driver and it works well for many UIs but there are > other systems that need an ODBC driver. > > > > Can anyone share any guidance as to how this can be done or has been > done by others. > > > > Thanks > > Aroop > >
