Reference

Authentication Default

Description

No description available [API reference]

Instructions

Apache Flink SQL Gateway JDBC from Power BI, SQL Server Linked Server via ZappySys Data Gateway, Crystal Reports, SSRS, Azure Data Factory, and other ODBC tools. Match the bundle to the gateway major version. This pin is 1.19.3 (Java 11 gateways).

  1. Start a Flink SQL Gateway REST endpoint (default port 8083) bound to your Flink cluster.
  2. The gateway currently ignores user name and password; leave them empty unless your distribution documents otherwise.
  3. JDBC against the gateway is for batch queries. Do not expect interactive streaming CHANGELOG results in Power BI or Linked Server.
  4. After Finish, replace the host (e.g. MyHostName) (and port if the gateway is not on 8083).
  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\Apache Flink\flink-sql-jdbc-driver-bundle-1.19.3.jar
Name: HostName

Label: Host

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

Label: TCP port

JDBC port (e.g. 8083). 		YES 8083
Name: DriverClass

Label: Driver class

Optional. Leave blank to auto-detect from the JAR unless SPI is ambiguous (e.g. org.apache.flink.table.jdbc.FlinkDriver). 		org.apache.flink.table.jdbc.FlinkDriver
Name: UserName

Label: User name

Usually unused. The SQL Gateway ignores user name unless your distribution documents otherwise.
Name: Password

Label: Password

Usually unused. Leave empty unless the gateway is configured for basic auth.