SAP Knowledge Base Article - Public

3328885 - Error: "Unable to connect to data source. Check your connection details and then try again" when creating an import connection to an SQL database (Amazon Redshift) in SAC

Symptom

When creating a new Amazon Redshift connection, the below error appears:

"Unable to connect to data source. Check your connection details and then try again".

Environment

SAP Analytics Cloud

Reproducing the Issue

  1. Log in to the SAC tenant.
  2. Click "Connection" option.
  3. Add a new connection "+".
  4. Select the source system SQL-Databases.
  5. Select Generic Database.
  6. Enter the JDBC URL.
  7. Enter the JDBC class.
  8. Specify the credentials.
  9. Click on create
    >> Notice the error: "Unable to connect to data source. Check your connection details and then try again".

Cause

Database SSL encryption is enabled.

Resolution

Add the ssl=false at the end of the JDBC URL as such:

jdbc:redshift://<endpoint>:<port>/<database-name>?ssl=false 

Keywords

Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, Issue, sapanalyticscloud, sap analytical cloud, sap analytical cloud, no data, warning, instead, incorrect , KBA , LOD-ANA-ADM , SAC Administration , Problem

Product

SAP Analytics Cloud 1.0