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

]]> Flight SQL token authentication (bearer / PAT). Still a generic protocol tile -- InfluxDB 3 keeps its own connector.

1. Create an API token or personal access token in the Flight SQL server UI (same idea as a Stripe secret key).
2. Paste the token into Token. Leave user/password empty unless the server requires both.
3. Java 16+ may need --add-opens=java.base/java.nio=ALL-UNNAMED on the Bridge JVM.
4. After Finish, replace host and port. Cloud endpoints often use 443 with TLS.
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.

]]>