Initial JDBC Bridge catalog version. Hands-free JAR download. Auth Notes and SQL examples for ODBC apps. Apache Kylin 5 JDBC from Power BI, SQL Server Linked Server via ZappySys Data Gateway, Crystal Reports, SSRS, Azure Data Factory, and other ODBC tools. User and password are the Kylin REST user (the same account you use in the Kylin web UI), not a Hadoop principal unless you configured that.

1. Note the Kylin query/REST host and HTTP port (default 7070) and the project name.
2. In the Kylin web UI create (or reuse) a user with query permission on that project. Paste user and password here. Do not use a personal employee login for unattended refresh.
3. The wizard downloads kylin-jdbc 5.0.4 (shaded). After Finish, replace the host (e.g. MyHostName) and project in the JDBC URL.
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.

]]> Kylin 5 JDBC over HTTPS. User and password remain the Kylin REST user.

1. Use the HTTPS port of the Kylin server (often 443 or a custom TLS port). This Auth sets ssl=true.
2. Create a Kylin REST user with query access to the project. Paste user and password.
3. After Finish, replace host, port, and project. If the certificate is private, import it into the Java truststore used by JDBC Bridge.
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.

]]> 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 KYLIN_SALES. Replace the identifier with your catalog object. Works in Excel, SSRS, and Crystal Reports.

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

]]> Maps a column to labels with CASE.

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

]]>