SAP Knowledge Base Article - Public

3095456 - Create new connection to Salesforce

Symptom

  • Connection to host failed: [Simba][SimbaSalesforceDAE](100) Unknown failure: com.simba.sap.dae.DataAccessExtensionException

Environment

  • SAP Analytics Cloud
  • Salesforce

Reproducing the Issue

  1. Create a new connection using the Salesforce option
  2. Use the Basic Authentication, enter the Salesforce URL (https://xx.my.salesforce.com)
    Username, and Password for the SFDC account
  3. 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