Mapd Open source Edition support ODBC?


#1

Dear all,

would like to connect to Tableau BI tool with MapD Open source on ODBC Interface. please let us know is it ODBC is supported interface? if not any other interface can use to connect to Tableau Tool.

Regards,
Sumit


#2

Hi @sumit -

ODBC support is part of our Enterprise Edition only.

Thanks,
Randy


#3

@randyzwitch

Is it any way possible to connect “Tableau” Tool ?


#4

Yes, you can use the MapD ODBC driver to connect with Tableau, it’s just not free/open-source. If in the future, Tableau provides JDBC access, that would be another way.


#5

@randyzwitch
Noted with thanks


#6

@randyzwitch

How we can connect MapD from perl ? for example when i am connecting to Oracle Database, we use DBI.

/sumit


#7

I’m not a perl coder, but can you use some combination of these?

http://search.cpan.org/~vizdom/DBD-JDBC-0.70/JDBC.pod
https://www.mapd.com/docs/latest/mapd-core-guide/jdbc/


#8

last year i connected from Tableau to Mapd CE with the odbc to jdbc bridge of Easysoft, doing some customization on Mapd jdbc driver; i can download a trial of bridge and try this way


#9

@randyzwitch
let me try the above link if it can work for us


#10

@aznable
thanks for sharing details and i will check Easysoft


#11

i gguess it works same way with other odbc-jdbc products, so if you have another one licenced you haven’t to use Easysoft’s one.
Take in account you could have compatibility issue with the jdbc driver (feel free to ask, someone will help you out) and you will be using Tableau with generic odbc connections, that’s quite different from usign with a certificated data source and the query generated could be sub-optimal (e.g. using stddev on a generic odbc tableau will generate a suboptimal expression, so to get best performance you are force to use SCRIPT_* expressions)