Reference

Authentication Local file

Description

No description available [API reference]

Instructions

H2 file JDBC from Power BI, SQL Server Linked Server via ZappySys Data Gateway, Crystal Reports, SSRS, Azure Data Factory, and other ODBC tools.

  1. The wizard downloads the H2 JAR into C:\ZappySys\Jdbc\H2. The database file is created next to it as h2db.mv.db.
  2. Point the URL at another folder after Finish if you already have an H2 file.
  3. Optional user/password (sa / empty is common for local files).
  4. Finish the wizard. Then click Test Connection on the DSN Main UI (the wizard does not run Test Connection).
  5. Done. You can query from C#, Python, PowerShell, and ODBC apps.

Parameters

Parameter Required Default value Options
Name: DriverFilePaths

Label: JDBC driver file(s)

Filled by the wizard after download. Separate multiple JARs with a semicolon (e.g. C:\ZappySys\Jdbc\MyConnector\driver.jar). 		YES C:\ZappySys\Jdbc\H2\h2-2.3.232.jar
Name: DriverClass

Label: Driver class

Optional. Leave blank to auto-detect from the JAR unless SPI is ambiguous (e.g. org.h2.Driver). 		org.h2.Driver
Name: UserName

Label: User name

Database user. Leave empty if the server allows anonymous JDBC.
Name: Password

Label: Password

Database password. Leave empty if no password is required.