5c around experiment connecting H2 + Tableau.
Tableau is nice analytics tool but when it comes to support for data sources becomes a bit picky ( http://www.tableausoftware.com/solutions/data-sources). We took the pg driver to connect to H2 and bellow are some results; 1) Tableau->pg driver->H2 the good news is It connects! But Tableau starts to fire queries and DDL for temporary structures which require some more PG dialect to support … Tableau Queries on connect: select oid, typbasetype from pg_type where typname = 'lo'; SET TIMEZONE TO 'UTC'; SELECT * INTO TEMPORARY TABLE "#Tableau_1_Connect" FROM (SELECT 1 AS COL) AS CHECKTEMP LIMIT 1; DROP TABLE "#Tableau_1_Connect"; CREATE LOCAL TEMPORARY TABLE "#Tableau_2_Connect" ( "COL" INTEGER ) ON COMMIT PRESERVE ROWS; DROP TABLE "#Tableau_2_Connect"; show "lc_collate"; declare "SQL_CUR02DE9BB8" cursor for select relname, nspname, relkind from pg_catalog.pg_class c, pg_catalog.pg_namespace n where relkind in ('r', 'v') and n.oid = relnamespace order by nspname, relname; SAVEPOINT _EXEC_SVP_02DE94A8; ROLLBACK to _EXEC_SVP_02DE94A8; declare "SQL_CUR02DE8680" cursor with hold for SELECT * FROM ( select * from foo ) "TableauSQL" LIMIT 1; --- Summary; a) Not handled by H2 - but easy to address; - SET TIMEZONE TO 'UTC'; - SHOW "lc_collate"; btw: the ODBC driver usually carries the "MS Windows" system character set (like "WIN1250") which does not match with the default java supported charset (windows-1250). Which will fire an exception … b) H2 not supported -> CURSORS … declare "SQL_CUR02DE9BB8" cursor for select relname, nspname, relkind from pg_catalog.pg_class c, pg_catalog.pg_namespace n where relkind in ('r', 'v') and n.oid = relnamespace order by nspname, rename; heh, we could not easily address this ones … ;) --- I've seen the post regarding cursors. Hope they get supported soon ;) Keep the good work - enjoyed wrangling the code! -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
