Are you looking to installing JDBC database drivers for AWS SCT? We can help you!

For the proper working of AWS SCT, we must install the JCBC database drivers.

As part of our AWS Support Services, we assist our customers with similar AWS queries.

Today, let see the steps followed by our Support Engineers to install the JDBC database drivers.

JDBC Drivers

Java Database Connectivity (JDBC) is an API for Java, which enables java applications to interact with the database.

For the proper working of AWS SCT, we must install the JDBC database drivers for source and target database engines.

Before installing, we have to download the database drivers. We can download the database drivers from the following locations:

MySQL: https://www.mysql.com/products/connector/

Oracle: https://www.oracle.com/database/technologies/jdbc-ucp-122-downloads.html

Amazon Aurora (MySQL compatible): https://www.mysql.com/products/connector/

Microsoft SQL Server: https://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774

Maria DB: https://mariadb.com/downloads/#connectors

Always make sure to install the latest version of the driver available.

Installing JDBC database drivers

Now, let see the steps followed by our Support Techs to install the JDBC drivers on the Linux system for AWS SCT.

1. Firstly, create a directory/folder for storing JDBC drivers.

>sudo mkdir –p /usr/local/jdbc-drivers

2. Then, we can install the JDBC database driver using the following commands:

MySQL : mysql prompt> cd /usr/local/jdbc-drivers
mysql prompt> sudo tar xzvf /tmp/mysql-connector-java-X.X.X.tar.gz

PostgreSQL: PostgreSQL prompt> cd /usr/local/jdbc-drivers
PostgreSQL prompt> sudo cp -a /tmp/postgresql-X.X.X.jre7.tar .

Oracle: From the Oracle prompt, > cd /usr/local/jdbc-drivers
>sudo mkdir oracle-jdbc-drivers
>cd oracle-jdbc-drivers
>sudo cp -a /tmp/ojdbc8.jar .

Amazon Aurora (MySQL compatible): Aurora prompt> cd /usr/local/jdbc-drivers
Aurora prompt> sudo tar xzvf /tmp/mysql-connector-java-X.X.X.tar.gz

Amazon Aurora (PostgreSQL compatible): Aurora prompt> cd /usr/local/jdbc-drivers
Aurora prompt> sudo cp -a /tmp/postgresql-X.X.X.jre7.tar .

Microsoft SQL Server: prompt> cd /usr/local/jdbc-drivers
prompt> sudo tar xzvf /tmp/sqljdbc_X.X.X_enu.tar.gz

After completing the installation of the JDBC driver, we can set the location of the drivers globally in the AWS SCT settings.

If we don’t set this globally, every time, the application asks for the driver’s location when connecting to the database.

Therefore, it is always better to set the driver location globally in the AWS SCT settings.

Setting driver location globally

Let’s the steps for setting the driver location globally:

1. Firstly, from AWS SCT select Settings.
2. Then select Global Settings.
3. Select Drivers.
4. Then, add the JDBC driver path for the source and target database engine.
5. Finally, click OK.

[Need assistance with more AWS queries? We can help you]

Conclusion

To conclude, today we saw the steps followed by our Support Techs for installing JDBC database drivers for AWS.