Hi, I've managed to use ODBC-JDBC bridge with Calcite, and then connect Tableau via ODBC.
Some details are available here https://speakerdeck.com/fe2s/how-we-built-sql-driver-for-in-memory-data-grid -- Oleksiy On Wed, Dec 6, 2017 at 9:53 PM, Julian Hyde <[email protected]> wrote: > +1 > > > > On Dec 6, 2017, at 11:37 AM, Josh Elser <[email protected]> wrote: > > > > Yeah, the Phoenix ODBC driver is (sadly) not open source. It would be > great if it could be, but I haven't been able to make any strides there. > > > > On 12/4/17 12:26 PM, Luis Fernando Kauer wrote: > >> ODBC driver would be great. > >> Apache Phoenix ODBC Driver seems to be provided by HortonWorks (not > open source): > >> https://br.hortonworks.com/hadoop-tutorial/bi-apache-phoenix-odbc/ > >> Apache Drill has ODBC Driver too, but it seems to be provided by MapR > (not open source). > >> However, Kylin has ODBC Driver and it is open source (Apache License): > >> https://github.com/KylinOLAP/odbc-driver > >> Maybe that can be used to get started. > >> Em segunda-feira, 4 de dezembro de 2017 10:40:20 BRST, Christian > Tzolov <[email protected]> escreveu: > >> Avatica ODBC driver would be handy (and good selling i guess) feature > >> indeed! > >> @Josh, the documentation mentions that Apache Phoenix have ODBC > >> implementation over the avatica protocol but i couldn't find any code or > >> even further info? I guess it is a proprietary/commercial project? > >> Last week i've troubled myself trying to setup on my MacOS the OpenLink > >> ODBC-to-JDBC bridge (http://bit.ly/2AWpbhU) for calcite jdbc. It was a > >> complete failure and in the process I almost scrutinized my environment. > >> The bridge is monstrous approach to start with but just out of > curiosity, > >> has anyone every succeeded plugging avatica jdbc in such odbc-jdbc > bridge? > >> On 4 December 2017 at 06:24, Josh Elser <[email protected]> wrote: > >>> Hi Victor, > >>> > >>> An ODBC driver for Avatica would be a great addition to the project, > but I > >>> am not aware of anyone who has volunteered to take on this development > >>> effort. > >>> > >>> On 12/1/17 9:03 PM, victor wrote: > >>> > >>>> Hi, calcite development team: > >>>> we now use calcite for some databases development , the > calcite > >>>> gives us a lot of convenience, thanks all of you. but it seems there > has > >>>> not an odbc driver for avatica, do you have some plan for odbc driver > >>>> developing, please let me know as soon as possible, > >>>> thanks a lot, > >>>> > >>>> > >>>> yours best regards > >>>> > >>>> > >>>> victor lv > >>>> > >>>> > >
