3194156 - "Unable to connect to data source. Check your connection details then try again" error occurs when creating an Import Data Connection to SQL Database in SAP Analytics Cloud (SAC)

• The following Error message occurs when creating an Import Data Connection to SQL Database in SAP Analytics Cloud (SAC): "Unable to connect to data source. Check your connection details then try again" 
• From Tomcat logs we can see error similar to the following:"The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target"."

• SAP Analytics Cloud
• Microsoft SQL Server 2016
• mssql-jdbc-10.2.0.jre8.jar

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, Microsoft, SQL, Server, 2016, JDBC Driver, Import Data Connection, encryption , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem