Initial JDBC Bridge catalog version. Hands-free Maven JAR download. Auth Notes and SQL examples for ODBC apps. Apache Phoenix JDBC from Power BI, SQL Server Linked Server via ZappySys Data Gateway, Crystal Reports, SSRS, Azure Data Factory, and other ODBC tools.

1. Get the ZooKeeper quorum and HBase znode (often /hbase).
2. This thick client JAR talks to ZK + HBase. Network access to ZK and region servers is required from the DSN host (gateway or Power BI on-prem).
3. Create a Phoenix user if Kerberos/HBase auth is enabled; otherwise leave user/password empty.
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.

]]> Apache Phoenix Query Server JDBC from Power BI, SQL Server Linked Server via ZappySys Data Gateway, Crystal Reports, SSRS, Azure Data Factory, and other ODBC tools.

1. Start or locate Phoenix Query Server (default port 8765).
2. Replace host in the JDBC URL. User/password only if the server requires them.
3. Finish the wizard. Then click Test Connection on the DSN Main UI (the wizard does not run Test Connection).
4. 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 MY_TABLE. Replace the identifier with your catalog object. Works in Excel, SSRS, and Crystal Reports.

]]> Returns matching rows from MY_TABLE. 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 MY_TABLE.

]]> Maps a column to labels with CASE.

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

]]>