3416060 - Error "Unable to connect to datasource. Check the connection details and user credentials, and then try again." happened when create an import data connection to SuccessFactors in SAP Analytics Cloud (SAC)

• Got error "Unable to connect to data source. Check the connection details and user credentials, and then try again." when create import data connection to SuccessFactors in SAC.
• Error "Failed to get access token with message: Illegal base64 character d(If this is using a shared connection without credentials, please enter the credentials by running a data import using such connection)" is found in the HAR trace.

• SAP Analytics Cloud (Enterprise) Edition.

1. Login to SAC tenant.
2. Go to connections and create a new import data connection to SuccessFactors.
3. Enter the SuccessFactors system information.
4. Notice that error "Unable to connect to data source. Check the connection details and user credentials, and then try again." happens.

There is "\r" at the end of private key, it can be seen in the request payload: 

• {\"clientId\":\"<API Key>",\"privateKey\":\"<Private Key>\r\"}

To verify if the downloaded certificate from SuccessFactors has "\r" (CR) at the end of private key, Notepad++ can be used to check.

Note: The option "Show All Characters" need to be checked first in View -> Show Symbol in Notepadd++.

Remove the wrap symbol "\r" (CR) in the certificate, e.g. use Notepad++:

1. Open the certificate .pem file in Notepad++.
2. Double click the wrap symbol option at the bottom right corner:
   
3. Change the option to "Unix(LF)":
   
4. The wrap symbol will become "\n" (LF):
   
5. Save the certificate .pem file again and create the connection.

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