Initial JDBC Bridge catalog version. Hands-free JAR download. Auth Notes and SQL examples for ODBC apps. Apache Solr SQL JDBC from Power BI, SQL Server Linked Server via ZappySys Data Gateway, Crystal Reports, SSRS, Azure Data Factory, and other ODBC tools. The collection must expose /sql. This Auth uses ZooKeeper (SolrCloud).

1. Note the ZooKeeper host and port (often 2181, or Solr's embedded ZK on 9983 in local examples) and the collection name.
2. Confirm the collection has the /sql handler in solrconfig.xml.
3. The wizard downloads SolrJ 9.10.1 + streaming + ZooKeeper modules. If Test Connection fails on a missing class, add WEB-INF/lib and server/lib/ext JARs from the same Solr 9 install (see additional download instructions).
4. After Finish, replace zkHost and collection on the DSN Main UI. Driver class is org.apache.solr.client.solrj.io.sql.DriverImpl (not auto-obvious from SPI).
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.

]]> Solr SQL over HTTP (no ZooKeeper in the JDBC URL). Still requires /sql on the collection.

1. Note the Solr node host and HTTP port (default 8983) and the collection name.
2. If the node is SolrCloud, ZooKeeper Auth is usually more reliable. Use HTTP for standalone Solr or a single node you can reach directly.
3. Keep SolrJ 9.x. Do not mix Solr 10 JARs with this EngineVersion 11 profile.
4. After Finish, replace host, port, and collection.
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.

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

]]> Returns matching rows from MyCollection. Swap the column and literal for your schema.

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

]]> Maps a column to labels with CASE.

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

]]> Returns distinct values of a field. Typical Power BI dimension extract from Solr.

]]> Sums a numeric field per group. Requires aggregationMode on the JDBC URL when the collection is large.

]]>