Downloading the Database Driver
Before installing the database type of SmartConnector, you must download the database driver of the respective database so that the connector can connect to the database. During the installation process, you will be directed to leave the wizard and copy the driver file you downloaded to a SmartConnector folder.
JDBC Driver for Microsoft SQL Server
Different versions of the JDBC driver are required for different SQL Server database versions. The name of the jar file may be different for some JDBC driver versions. Make sure that you use the correct driver for your database version.
Refer to the following information to download the correct jar file depending on the JRE version used by the SmartConnector:
-
SmartConnector Version 8.3.0 uses JRE 1.8.0_312 and supports jar files from version mssql-jdbc-6.4.0.jre8.jar (Download Microsoft JDBC Driver 6.4 for SQL Server) to mssql-jdbc-9.4.0.jre8.jar (Download Microsoft JDBC Driver 9.4.0 for SQL Server).
-
SmartConnector Version 7.2.1 and later use JRE 1.8 and require sqljdbc42.jar (Download Microsoft JDBC Driver 6.0 for SQL Server).
-
SmartConnector Version 7.1.2 and later use JRE 1.7 and require sqljdbc41.jar (Download Microsoft JDBC Driver 6.0 for SQL Server).
-
Earlier versions of SmartConnector run JRE 1.6 and require sqljdbc4.jar (available with Microsoft JDBC Driver 4.0 for SQL Server).
JDBC Driver for MySQL
To download the JDBC driver for MySQL, navigate tohttp://www.java2s.com/Code/Jar/m/Downloadmysqlconnectorjar.htm#google_vignette and download the mysql-connector.jar file.
JDBC Driver for PostgreSQL
To download the JDBC driver for PostgreSQL, navigate to https://jdbc.postgresql.org/download/. It is recommended to download the JDBC driver for Java 8 or a higher version. The jar file for Java 8 is postgresql-42.6.0.jar. For any other version of Java, download the appropriate JDBC driver from the website.
JDBC Driver for Oracle
To download the JDBC driver for Oracle, navigate to https://www.oracle.com/in/database/technologies/appdev/jdbc-downloads.html and download the ojdbc8.jar file.
DB2 Driver for IBM DB2
For IBM DB2, DB2 drivers are no longer provided in the connector installation due to licensing requirements. Later versions of DB2 drivers can be found here, but you require IBM login credentials to download the drivers. The jar file to download is db2jcc4.jar. In addition, IBM now requires a license jar to be added to the connector to connect to the database. The jar file to download is db2jcc_license_cu.jar.