DbSchema is connecting to Redshift using JDBC Drivers.
What are JDBC Drivers?
JDBC drivers are Java library files with the extension '.jar', used by Java applications to connect to the database.
Usually they are provided by the same company which developed the database software.
DbSchema is an Redshift Client which already includes
the Redshift JDBC driver. DbSchema can configure the Redshift JDBC URL and test the connectivity.
What is the JDBC URL?
The URL is a string (text) with a specific format containing information about the host where the database is running, the port, username, database name, etc.
The URL format is specific to each driver.
Any wrong character in the URL may make the database connectivity fail.
Therefore we recommend installing DbSchema and try to get connected, and you will find the JDBC URL in the connection dialog.
Driver Information
- Required File(s): RedShiftJdbc.jar
- Java Driver Class: net.ucanaccess.jdbc.UcanaccessDriver
- URL: jdbc:redshift://HOST:PORT/DB
- Website: IBM
We use the
The driver files are compressed in a zip file.