RazorSQL Built-in Database Support

RazorSQL ships with drivers and provides extra features and functionality for the databases listed below. Click on the links below to get more detailed information about working with each database using RazorSQL.

Listed below is some information about specific versions of each of these databases with regards to RazorSQL.

DB2

Version 8.x, 9.x, and 10.x: The driver that ships with RazorSQL, IBM DB2 Universal Driver Type 4, allows users to connect to DB2 UDB for Linux, UNIX and Windows with no additional software required. Users that that have a valid DB2 Connect product license will be able to connect to DB2 UDB for OS/390 and z/OS, DB2 UDB for iSeries and DB2 UDB for VSE and VM servers.

Version 7.x: Connecting to DB2 7.2 may require client software to work properly, i.e. DB2 Connect. If using the DB2 Net driver, the DB2 proxy server, db2jstrt[.exe], must be enabled. The proxy defaults to port 6789. Please be sure to use the JDBC driver version that matches the DB2 version and fix pack you are using.

Earlier Versions: RazorSQL has not been tested on versions of DB2 prior to 7.x. Connections can be made to these databases, but not all RazorSQL features may work properly.

Derby

RazorSQL ships with Derby embedded and network/server drivers, so for almost all cases, RazorSQL can connect to and communicate with Derby out of the box.

Amazon DynamoDB

RazorSQL ships with a custom-built driver that interacts with the Amazon Web Services (AWS) for DynamoDB API to send and receive data to DynamoDB.

Firebird

RazorSQL ships with the Firebird Jaybird drivers, so for almost all cases, RazorSQL can connect to and communicate with Firebird out of the box.

HSQLDB

RazorSQL ships with the HSQLDB drivers, so for almost all cases, RazorSQL can connect to and communicate with HSQLDB out of the box. At this time, the built-in relational database engine that ships with RazorSQL uses HSQLDB.

Informix

RazorSQL ships with the Informix JDBC driver, so for almost all cases, RazorSQL can connect to and communicate with Informix out of the box.

MariaDB

RazorSQL ships with drivers for MariaDB.

If connecting to a MariaDB server on a different machine, you may need to grant access to the user and host/ip address you are using to connect to MariaDB. The following command can be used to grant a user access:

GRANT ALL PRIVILEGES ON [database_name].* to '[user]'@'[hostname]' identified by '[password]'

Microsoft Access

RazorSQL provides read-only access out of the box to most MS Access databases using the UCanAccess driver that ships with RazorSQL. On Windows machines, RazorSQL can provide read/write access to MS Access via the ODBC driver interface.

MongoDB

RazorSQL provides its own driver that interfaces with the MongoDB API to provide access to MongoDB.

MySQL

RazorSQL does not ship with JDBC drivers for MySQL because of licensing restrictions on distributing MySQL JDBC drivers. However, RazorSQL does provide an auto-install feature that will automatically download and install the MySQL driver. If manually downloading the driver, it is recommended that the latest stable version of the MySQL Connector/J driver be used to connect to MySQL databases.

If connecting to a MySQL server on a different machine, you will need to grant access to the user and host/ip address you are using to connect to MySQL. The following command can be used to grant a user access:

GRANT ALL PRIVILEGES ON [database_name].* to '[user]'@'[hostname]' identified by '[password]'

Oracle

Versions 10g, 11g, and 12c: The driver that ships with RazorSQL, the Oracle 12c driver, allows users to connect to Oracle 10g, 11g or 12c with no additional software required if using the Oracle Thin Driver option. If using OCI, the 10g or 11g or 12c OCI client software must be installed on the user's machine.

Version 9i: The driver that ships with RazorSQL, the Oracle 10g driver, is compatible with Oracle 9i with no additional software required if using the Oracle Thin Driver option. If using OCI, the 9i OCI client software must be installed on the user's machine, and you should use the Oracle 9i JDBC driver to connect, not the Oracle 10g driver that ships with RazorSQL.

Earlier Versions:: If using 8i or earlier, you may need to obtain the JDBC drivers specific to the Oracle version you are using. RazorSQL is no longer tested on earlier verisons of Oracle. Connections may be made to these databases, but not all RazorSQL features may work properly.

PostgreSQL

Version 7.x, 8.x, and 9.x: RazorSQL ships with the PostgreSQL 9.x JDBC driver. This driver is compatible with versions 7, 8, and 9 of PostgreSQL. Previous versions of PostgreSQL have not been tested using RazorSQL. Connections may be made to these previous versions, but not all RazorSQL features may work properly.

If connecting to PostgreSQL on a different machine, be sure to either start PostgreSQL with the -i option, which enables TCP/IP connections, or edit the pg_hba.conf file in the PostgreSQL data directory to allow connections from the machine you are using.

Redshift

RazorSQL ships with the both the Amazon Redshift driver and the PostgreSQL 9.x JDBC driver. Both drivers will work with Redshift.

You may need to configure your local ip address in the Amazon Web Services (AWS) control panel to allow the connection from your machine to Redshift.

Salesforce

RazorSQL ships with a custom-built driver for Salesforce.com that interacts with the Salesforce web services API to send and receive data from Salesforce.com.

Amazon SimpleDB

RazorSQL ships with a custom-built driver that interacts with the Amazon Web Services (AWS) for SimpleDB API to send and receive data to SimpleDB.

SQL Azure

RazorSQL ships with the jTDS JDBC driver which is compatible with some Azure versions. RazorSQL also provides access to Azure using the Microsoft SQL Server JDBC driver.

Because SQL Azure has a firewall preventing access unless your local machine's IP address is entered as an SQL Azure firewall rule, you may need to set up the firewall rule in SQL Azure for your local machine before being able to connect.

SQL Server

RazorSQL ships with the jTDS JDBC driver which is compatible with SQL Server versions 2016, 2014, 2012, 2008, 2005, 2000, 7, and 6.5.

RazorSQL supports Single Sign-On for SQL Server when running RazorSQL on Windows.. Select the Windows Single Sign-On option in the connection wizard to connect to SQL Server using the login credentials of the current logged in user of the operating system.

RazorSQL supports Windows Authentication for SQL Server. To use Windows Authentication, select the Windows Authentication option in the Connection Wizard and enter the Windows domain the user belongs to, the login id, and the password.

SQLite

RazorSQL ships with the RazorSQL SQLite Driver, which works by communicating with the SQLite command line program.

RazorSQL for Windows ships with the sqlite3 command line program, and on macOS / Mac OS X machines, the SQLite command line program is preinstalled in the /usr/bin/sqlite3 location. For other operatings systems, the sqlite3 command line program must be present in order for the RazorSQL SQLite driver to work.

There are JDBC drivers available for SQLite. They can be used by going through the JDBC connection type option in the connection wizard process.

Sybase

RazorSQL ships with the jTDS JDBC driver, which is compatible with Sybase Adaptive Server 10, 11, 12, and 15. RazorSQL also ships with Sybase jConnect 5.5, which is compatible with Sybase Adpative Server and SQL Anywhere.

Vertica

RazorSQL ships with the Vertica JDBC driver. No additional steps are needed to be able to connect to Vertica out of the box.