Initial JDBC Bridge catalog version. Hands-free JAR download. Auth Notes and SQL examples for ODBC apps. 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.

]]> Lists tables available to this connection. Use this in Power BI or a SQL Server Linked Server to confirm the catalog before building reports.

]]> Returns rows from MyTable. Replace the identifier with your catalog object. Works in Excel, SSRS, and Crystal Reports.

]]> Returns matching rows from MyTable. Swap the column and literal for your schema.

]]> Joins two tables on a key. Use in Azure Data Factory or SSIS when you need a combined extract.

]]> Counts rows per group. Typical Power BI import pattern before a visual.

]]> Keeps groups whose count is at least 10.

]]> = 10]]> Returns the first 100 rows ordered by a column. Useful for preview in Excel or Crystal Reports.

]]> Returns the number of rows in MyTable.

]]> Maps a column to labels with CASE.

]]> Returns a column list instead of star. Prefer this in Linked Server views.

]]> Lists Flink catalogs visible to this gateway session.

]]> Lists databases in the current catalog.

]]>