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

1. No server to install. Data lives in the Java process for this DSN and is gone when the connection closes unless you add DB_CLOSE_DELAY=-1.
2. Optional user/password: default lab user is often sa with empty password.
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.

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

1. The wizard downloads the H2 JAR into {DownloadFolder}. The database file is created next to it as h2db.mv.db.
2. Point the URL at another folder after Finish if you already have an H2 file.
3. Optional user/password (sa / empty is common for local files).
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.

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

1. Start the H2 server (default TCP 9092) or connect to an existing one.
2. Replace the host (e.g. MyHostName), port (e.g. 9092), and database path. Fill user and password from that server.
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 PUBLIC.MY_TABLE. Replace the identifier with your catalog object. Works in Excel, SSRS, and Crystal Reports.

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

]]> Maps a column to labels with CASE.

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

]]>