In the latest release of Aginity Pro and Team, v.15.40 we have included the ability to copy the full JDBC connection string.
This is helpful for debugging what may be missing or required in the advanced parameter section when setting up database connections.
As always you should start with reading through our documentation on connecting to databases.
If you are still struggling the first thing we recommend is to look at the JDBC connection string as shown below.
When you select Copy connection string to clipboard and then paste it to an editor you will see the following.
This in coordination with your database administrator can now help you compare to the JDBC configuration guide of the database and determine what is missing. For example, maybe your Redshift configuration requires the sslRootCert parameter to point to a specific "*.pem" file. In this case you could add the advanced parameter as shown here and the corresponding JDBC configuration string.