BroadSQL Download
Documentation / Connect to your database: another JDBC database

Connect to another JDBC database

BroadSQL connects to any database with a JDBC driver: the same steps apply, with the driver and the URL format of that database.

DriverBundled for Apache Derby and HSQLDB; for any other database, its vendor's JDBC driver JAR in drivers.
URL formatthe URL format of the vendor's JDBC driver
Examplesee the vendor's driver documentation
Verified with BroadSQLDepends on the database: see the vendor's documentation.

Steps

  1. The driver: Apache Derby (embedded and client) and HSQLDB are included in BroadSQL. For another database, download its vendor's JDBC driver and copy the JAR into drivers, then restart BroadSQL.
  2. Check it: SHOW DRIVERS; lists the drivers found, with their names and versions.
  3. The connection: ADD CONNECTION <id>; (or CONFIG; on Windows). Choose your database in the list of types, then give the URL in the format documented by the driver's vendor.
  4. Test and open it: PING <id>;, then CONNECT <id>;.

If your database does not appear in the list of types, tell us which database and which driver you use.

What works on every database

Ordinary statements, the commands that browse tables and columns (DESCR, SHOW TABLES...) and DUMP work the same way on every database type reachable through a registered connection. A few behaviors depend on the type: see Behavior that differs by database type.

Found something wrong or unclear on this page? , with the page address.