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
- Log in to the SAC tenant.
- Click "Connection" option.
- Add a new connection "+".
- Select the source system SQL-Databases.
- Select Generic Database.
- Enter the JDBC URL.
- Enter the JDBC class.
- Specify the credentials.
- 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