3581137 - How to use SQuirrel SQL Client to test connection to SQL Databases via JDBC driver for verifying the connection parameters used in the connection in SAC?

When use the Generic JDBC data connection in SAC to connect to the SQL databases as per the SAC help guide Import Data Connection to an SQL Database, to narrow down if it is caused by the wrong parameters, third party database SQL client tool like SQuirrel SQL Client can be used to verify. 

How to use SQuirrel SQL Client to test connection to SQL Databases via JDBC driver?

• SAC
• SQuirrel SQL Client
• SQL Databases

1. Download the SQuirrel SQL Client tool from the SQuirrel official website http://www.squirrelsql.org/#installation
2. Install it.
3. Open the SQuirrel SQL Client tool.
4. Click Drivers on the left menu.
5. Click the add button to create a new driver.
6. Enter the Name for identification.
7. Enter the example JDBC URL for reference.
8. Click Add button to select the JDBC driver.
9. Click OK to save the configuration.
   Below is an example for Databricks database:
   
10. Click Aliases on the left menu.
11. Click add button to add alias.
12. In the add alias dialogue, enter the Name, select the Driver created, enter the actual used JDBC URL, user and password.
    
13. Click Test or Connect button to verify if the parameters and driver are working.  

KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem