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.
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/ PostgreSQL: https://jdbc.postgresql.org/download.html Oracle: https://www.oracle.com/database/technologies/jdbc-ucp-122-downloads.html Amazon Aurora (MySQL compatible): https://www.mysql.com/products/connector/ Amazon Aurora (PostgreSQL compatible): https://jdbc.postgresql.org/download.html 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.
- 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:
- Firstly, from AWS SCT select Settings.
- Then select Global Settings.
- Select Drivers.
- Then, add the JDBC driver path for the source and target database engine.
- Finally, click OK.
[Need assistance with more AWS queries? We can help you]
To conclude, today we saw the steps followed by our Support Techs for installing JDBC database drivers for AWS.