Reference

Authentication User and password

Description

No description available [API reference]

Instructions

Generic Arrow Flight SQL JDBC from Power BI, SQL Server Linked Server via ZappySys Data Gateway, Crystal Reports, SSRS, Azure Data Factory, and other ODBC tools. This tile is the protocol driver. InfluxDB 3 already has its own catalog tile -- use that for Influx instead of retargeting this DSN.

  1. Note the Flight SQL host and port (Dremio often uses 32010; other servers differ). Default encryption is on.
  2. Create a database user on the Flight SQL server. Paste user and password.
  3. If the Bridge JVM is Java 16 or newer, add --add-opens=java.base/java.nio=ALL-UNNAMED to the JDBC Bridge JVM options when Arrow reports module-access errors.
  4. After Finish, replace host and port. Set useEncryption=false only for a local plaintext lab.
  5. Finish the wizard. Then click Test Connection on the DSN Main UI (the wizard does not run Test Connection).
  6. 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\Arrow Flight SQL\flight-sql-jdbc-driver-19.0.0.jar
Name: HostName

Label: Host

JDBC host name or IP (e.g. MyHostName). 		YES MyHostName
Name: Port

Label: TCP port

JDBC port (e.g. 32010). 		YES 32010
Name: UserName

Label: User name

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

Label: Password

Database password. Leave empty if no password is required. 		YES
Name: DriverClass

Label: Driver class

Optional. Leave blank to auto-detect from the JAR unless SPI is ambiguous (e.g. org.apache.arrow.driver.jdbc.ArrowFlightJdbcDriver). 		org.apache.arrow.driver.jdbc.ArrowFlightJdbcDriver
Name: useEncryption

Label: Use encryption

Set true for TLS (default). Set false only for a local plaintext Flight SQL server. 		true