SYMPTOM:
In Strategy, an XQuery report against Salesforce fails to run with below error:
Status: Execution failed
Error: SQL Generation Complete
QueryEngine encountered error: SfConnectionWrapper::Connect failed. Invalid XMLA Connection string.
Error type: XQuery Engine error. SfConnectionWrapper::Connect: Login FAILED. UID=xxxx. . Connection String: XQUERY;SALESFORCE;UID=xxxx;. Connection String: XQUERY;SALESFORCE;UID=xxxx;..
Error in Process method of Component: QueryEngineServer, Project SalesForce, Job 393, Error Code= -2147212544.
CAUSE:The login ID and password specified in the XQuery Database Instance for Salesforce is incorrect.
ACTION:Use the correct Salesforce account and password for XQuery Database Instance.
Note that the password syntax is PasswordSecurityToken, where Password is the password for the user account and SecurityToken is the additional security token required to access Salesforce.com. Do not use any spaces or other characters to separate the password and security token.
Refer to the below technical note for the detail steps to set up the connectivity to Salesforce:
