Reference

Authentication Embedded file

Description

No description available [API reference]

Instructions

Apache Derby embedded from Power BI, SQL Server Linked Server via ZappySys Data Gateway, Crystal Reports, SSRS, Azure Data Factory, and other ODBC tools.

  1. No server. The database folder is created under C:\ZappySys\Jdbc\Apache Derby.
  2. Use EmbeddedDriver (do not leave class blank -- SPI is ambiguous with the client JAR).
  3. Optional: add ;create=true (already in this URL) the first time.
  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\Apache Derby\derby-10.14.2.0.jar
Name: DriverClass

Label: Driver class

Optional. Leave blank to auto-detect from the JAR unless SPI is ambiguous (e.g. org.apache.derby.jdbc.EmbeddedDriver). 		org.apache.derby.jdbc.EmbeddedDriver