Auth Notes (numbered steps), documented params, Maven DriverDownloadLinks, extra SQL examples for ODBC apps. Initial version. MariaDB from Power BI, SQL Server Linked Server via ZappySys Data Gateway, Crystal Reports, SSRS, Azure Data Factory, and other ODBC tools.

1. Note the host, port (default 3306), and database name.
2. Create an application user (not a personal DBA login) with SELECT on the schemas you need.
3. Paste user and password. After Finish, edit the host (e.g. MyHostName) and database (e.g. MyDatabase) on the DSN Main UI.
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.

]]> MariaDB with TLS from Power BI, SQL Server Linked Server via ZappySys Data Gateway, Crystal Reports, SSRS, Azure Data Factory, and other ODBC tools.

1. Same as Default Auth. Use this when the server requires TLS (managed Cloud SQL, RDS, SkySQL).
2. After Finish, confirm sslMode on the JDBC URL matches your server (REQUIRED vs VERIFY_CA).
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 orders. Replace the identifier with your catalog object. Works in Excel, SSRS, and Crystal Reports.

]]> Returns matching rows from orders.

]]> 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.

]]> Returns the first 100 rows. Useful for preview in Excel or Crystal Reports.

]]> Returns the number of rows in orders.

]]> Maps a column to labels with CASE.

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

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

]]> = 1]]> Gets all rows from the orders table. Use this in Power BI or Excel to list every order without filtering.

]]> Gets order lines joined with orders so you can see which lines belong to which order.

]]> Gets product name and quantity for each line of one order. Replace 12345 with your order ID.

]]> Run SET SESSION sql_mode once to enable ANSI_QUOTES, then SELECT from a backtick-quoted table name.

]]>