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

1. Start Network Server (default port 1527) or use an existing one.
2. Create a database user if authentication is on. Lab often uses a simple user/password.
3. Seed Driver class as ClientDriver (SPI can also load EmbeddedDriver).
4. After Finish, replace the host (e.g. MyHostName) and database name (e.g. MyDatabase) on the DSN Main UI.
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.

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

1. No server. The database folder is created under {DownloadFolder}.
2. Use EmbeddedDriver (do not leave class blank -- SPI is ambiguous with the client JAR).
3. Optional: add ;create=true (already in this URL) the first time.
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 Derby in-memory from Power BI, SQL Server Linked Server via ZappySys Data Gateway, Crystal Reports, SSRS, Azure Data Factory, and other ODBC tools.

1. Data lasts for this DSN Java process only.
2. Keep EmbeddedDriver. Use for labs and Excel previews.
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 "APP"."ORDERS". Replace the identifier with your catalog object. Works in Excel, SSRS, and Crystal Reports.

]]> Returns matching rows from "APP"."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 "APP"."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]]> Returns all rows from the orders table in the APP schema. In Apache Derby, schema and table names are case-sensitive; quote them when needed.

]]> Returns order lines with the order ID by joining orders and order lines.

]]> Returns product name and quantity for each line item in a single order.

]]>