Releases: ericcj/metabase-netsuite-driver
v0.3.0
v0.2.2
v0.2.1
v0.2.0
This release works both with native and simple queries and successfully scans the netsuite schema. The only significant issue is that netsuite's maximum query length at 32kB isn't enough to support metabase's simple queries where it selects all the column names explicitly #2 but that can be worked around by specifically selecting the needed columns.
v0.1.0
First build, copied netsuite.metabase-driver.jar, NQjc.jar from netsuite, and ojdbc8.jar from oracle into metabase/plugins and verified it connects to netsuite and you can successfully get results of native SuiteQL queries in metabase but syncing the columns for simple metabase queries doesn't work yet (it does get the table list) due to:
2022-11-07 13:47:03,195 WARN sync.describe-table :: Don't know how to map column type 'BIGINT' to a Field base_type, falling back to :type/*.
and
java.sql.SQLException: [NetSuite][SuiteAnalytics Connect JDBC Driver][OpenAccess SDK SQL Engine]Failed to retrieve data.
at com.netsuite.jdbc.oabase.oaa0.b(Unknown Source)
at com.netsuite.jdbc.oabase.oaa0.a(Unknown Source)
at com.netsuite.jdbc.oabase.oaa_.b(Unknown Source)
at com.netsuite.jdbc.oabase.oaa_.a(Unknown Source)
at com.netsuite.openaccess.ssp.oaar.a(Unknown Source)
at com.netsuite.openaccess.ssp.oaf.a(Unknown Source)
at com.netsuite.openaccess.ssp.oaf.a(Unknown Source)
at com.netsuite.openaccess.ssp.oaf.f(Unknown Source)
at com.netsuite.openaccess.ssp.oaf.e(Unknown Source)
at com.netsuite.openaccess.ssp.oaf.b(Unknown Source)
at com.netsuite.openaccess.ctxt.stmt.oac.a(Unknown Source)
at com.netsuite.jdbc.openaccess.oad.j(Unknown Source)
at com.netsuite.jdbc.oabase.oac5.p(Unknown Source)
at com.netsuite.jdbc.oabase.oac5.l(Unknown Source)
at com.netsuite.jdbc.oabase.oac5.execute(Unknown Source)
at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:75)
at metabase.driver.sql_jdbc.execute$fn__55166.invokeStatic(execute.clj:367)
...