Symptom
- Connection to host failed: [Simba][SimbaSalesforceDAE](100) Unknown failure: com.simba.sap.dae.DataAccessExtensionException
Environment
- SAP Analytics Cloud
- Salesforce
Reproducing the Issue
- Create a new connection using the Salesforce option
- Use the Basic Authentication, enter the Salesforce URL (https://xx.my.salesforce.com)
Username, and Password for the SFDC account - Error
Cause
- Must use the Salesforce WSDL(Web Service Description Language) to create the required SOAP project first and use salesforce WSDL URL to create the connection in SAC
- The password need [Password][SecurityToken]\security code.
Resolution
This URL can be found in the section below in Partner WSDL
<service name="SforceService">
<documentation>Sforce SOAP API</documentation>
<port binding="tns:SoapBinding" name="Soap">
<soap:address location="https://login.salesforce.com/services/Soap/u/52.0"/>
</port>
</service>
- The password must have a security code.
Keywords
Salesforce, Simba, DAE , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem
Product
SAP Analytics Cloud 1.0