Reference

Authentication Local DuckDB file

Description

No description available [API reference]

Instructions

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

  1. The wizard still downloads the JDBC JAR (and Titanic sample) into C:\ZappySys\Jdbc\DuckDB (Parquet).
  2. After Finish, point the JDBC URL at your .duckdb file if you do not want mydb.duckdb.
  3. You can still query Parquet with SELECT * FROM 'C:\ZappySys\Jdbc\DuckDB (Parquet)\titanic.parquet'.
  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)

Path to the DuckDB JDBC JAR on disk. Separate multiple JARs with a semicolon (e.g. C:\ZappySys\Jdbc\MyConnector\driver.jar). 		YES C:\ZappySys\Jdbc\DuckDB (Parquet)\duckdb_jdbc-1.4.5.0.jar
Name: DriverClass

Label: Driver class

Optional. Leave blank to auto-detect from the JAR (e.g. org.duckdb.DuckDBDriver). 		org.duckdb.DuckDBDriver