topic Re: Qlik Sense Desktop Salesforce Connection ERROR in Connectivity & Data Prep

Qlik Sense Desktop Salesforce Connection ERROR

benwashburne — Fri, 02 Apr 2021 07:44:19 GMT

Qlikers,

I'm trying to create a Salesforce data connection and am unable to do so. I have trouble shot a lot, but I can't figure out what is causing the error. I have all the credentials correct and the user is not locked out. I am using the latest version of Qlik Sense Desktop that was released April 2018.

However, I receive two different errors depending on what I put in the URL field.

1. If the URL is left empty, I receive an error saying that my login information is INVALID, which isn't true.

2. If I use the following URL: https://login.salesforce.com/services/soap/u/42.0 , I receive a 404 Not Found.

Carmen, I tagged you in here because I saw that you had responded to a similar issue involving Qlikview. Any help would be much appreciated!

cri‌

Thanks,

Ben

Re: Qlik Sense Desktop Salesforce Connection ERROR

CarmenReilly — Tue, 08 May 2018 19:02:29 GMT

Hey Ben!

Which version of Qlik Sense Desktop are you using, and did you install the Salesforce connector separately or was it part of the Sense Desktop installation?

-Carmen

Re: Qlik Sense Desktop Salesforce Connection ERROR

benwashburne — Tue, 08 May 2018 19:09:43 GMT

cri,

Thanks for the speedy response!

To my knolwedge, the Salesforce connector was installed as part of the Sense Desktop installation when I originally downloaded Qlik Sense to my computer back in January 2018 (sorry, I'm not sure what the version was at that time). Today, I downloaded the April release of Desktop. Below are the details of my QS Desktop version:

Qlik Sense Desktop April 2018

qliksensedesktop: 12.16.2

NET SDK 13.4.0

About Service 1.8.1

App Migration Service 4.8.1

Broker Service 5.11.2

Capability Service 1.4.1

Client 4.86.8

Data Preparation Service 2.32.0

Dependency Graph Service 1.0.6

Freya Client Service 2.8.0

Printing Service 13.15.1

QIX Engine 12.145.3

Qlik DataMarket Connector 2.8.0.1

Qlik Essbase Connector 1.1.0

Qlik ODBC Connector 4.8.0

Qlik REST Connector 1.4.0

Qlik SalesForce Connector 14.3.0

Qlik Sense Browser 7.2.0

Qlik Sense Hub 0.18.0

Qlik Web Connectors 0.36.0

Service Dispatcher 15.0.3

Web Extension Service 1.5.2

Web Extensions 1.4.1

Thank you!

Bem

Re: Qlik Sense Desktop Salesforce Connection ERROR

CarmenReilly — Tue, 08 May 2018 19:17:26 GMT

Hm. Were you able to make the Salesforce connection before you upgraded to the April 2018 version?

Re: Qlik Sense Desktop Salesforce Connection ERROR

benwashburne — Tue, 08 May 2018 19:23:55 GMT

Carmen,

No, I did not attempt the connection until now. Our Salesforce admin, who also recently downloaded the April 2018 version, is also unable to create the connection.

Re: Qlik Sense Desktop Salesforce Connection ERROR

CarmenReilly — Tue, 08 May 2018 20:05:06 GMT

You (or your Salesforce admin) are putting in username, password, and security key?

Re: Qlik Sense Desktop Salesforce Connection ERROR

benwashburne — Wed, 09 May 2018 13:22:49 GMT

cri‌

Yes, that is correct. I'm wondering if it has something to do with the permissions on the Salesforce side - do you know what level of user permissions the Salesforce profile that is making the Qlik connection needs to have?

I checked through all the content in the following URL but could not find anything about Salesforce permissions.

https://help.qlik.com/en-US/connectors/Subsystems/Salesforce_Connector_help/Content/Create-Salesforce-connection/Create-salesforce-connection.htm

Best,

Ben

Re: Qlik Sense Desktop Salesforce Connection ERROR

stevedark — Wed, 09 May 2018 13:32:49 GMT

There is something I have seen with SalesForce connections, which may be part of the problem here.

When you log onto the website it whitelists the machine that you log on from. If you are using Qlik Sense Desktop that is quite straight forward, just log on from your own machine.

If you are using Qlik Sense Enterprise then the connection is actually made from the server. You will need to Remote Desktop to the Qlik Sense Server and then go to the SalesForce web site from within that remote desktop session.

Hope this helps.

Steve

Re: Qlik Sense Desktop Salesforce Connection ERROR

benwashburne — Thu, 10 May 2018 16:11:57 GMT

stevedark‌

Yes, I am attempting the connection from Desktop and did login so my machine should be whitelisted. I believe the issue is on the Salesforce side but, as I am no Salesforce developer or admin, I am not sure what needs to happen on the Salesforce side. Anyone know Salesforce??

Any thoughts/comments would be appreciated!

-Ben

Re: Qlik Sense Desktop Salesforce Connection ERROR

stevedark — Fri, 11 May 2018 14:06:17 GMT

It was a long while back I set this up for a client, and I don't have a log in I can use now. I seem to recall that there was something on the user permission side that needed to be configured to allow the connector to access it. There was also slight strangeness that the password used was a composite of the actual password and the access token generated from within SalesForce. I found documentation which described what needed to be done here.

Hope that helps?

Re: Qlik Sense Desktop Salesforce Connection ERROR

benwashburne — Fri, 11 May 2018 14:34:17 GMT

stevedark‌

Hi Steve,

Are you able to send the Salesforce documentation you mentioned in the thread? Or, maybe you have to attach it to the thread? Or are you saying that you found the documentation somewhere within the Qlik Community space?

Thanks again for all the assistance.

Best,

Ben

Re: Qlik Sense Desktop Salesforce Connection ERROR

stevedark — Mon, 14 May 2018 09:28:29 GMT

Hi,

It was some time ago, so the documentation has probably been superseded. This appears to be the latest and best from the Qlik side:

https://help.qlik.com/en-US/connectors/Subsystems/Salesforce_Connector_help/Content/Introduction/Salesforce-connector.htm

You may also need to refer to some SalesForce documentation around the Security Token and getting that generated.

Steve

Re: Qlik Sense Desktop Salesforce Connection ERROR

benwashburne — Tue, 22 May 2018 19:07:41 GMT

cri stevedark

My apologies for taking a while to circle back here. After further testing, I believe the issue maybe be with the URL that the Qlik connector defaults to. Our client uses a specific URL string to bring users to their login portal. It is in the following format (x's substituted for privacy).

https://xxxxx-mil.my.salesforce.com

I can go to this URL and login with the credentials I have been given by our SF Admin; however, when I try to use those credentials at https://login.salesforce.com/ they are invalid. I receive the invalid credentials error when I used the Qlik connector as well so I assume it is attempting the login at the https://login.salesforce.com/ URL.

Furthermore, when I opt to use the custom https://xxxxx-mil.my.salesforce.com URL, I receive a Qlik error stating that the URL must be in the following formats:

https://login.salesforce.com/services/soap/u/29.0

https://test.salesforce.com/services/soap/u/29.0

I also believe that our client's Salesforce platform is configured for SSO. Could this also cause an error in connecting Qlik?

Thoughts/Comments?

Thank you!

Ben

Re: Qlik Sense Desktop Salesforce Connection ERROR

stevedark — Tue, 22 May 2018 21:51:37 GMT

Hi,

I think you could be onto something with the alternate URL used for login. I've not tried logging onto a non standard URL, so can't offer any direct help. I would suggest a two pronged approach to getting a solution though, looking on the SalesForce forums to see if you can have a user account that uses a standard login when most users use a custom one. You can also contact Qlik to see if there is a way to use a non-standard login with the Qlik Salesforce connector.

Knowing what the problem is is a good step forward!

Re: Qlik Sense Desktop Salesforce Connection ERROR

CarmenReilly — Wed, 23 May 2018 08:31:16 GMT

I agree with Steve that you may be on to something with the URL - I don't think the SSO should necessarily be the cause of the issue (we use SSO here, and I can connect to Salesforce with no problem).

Re: Qlik Sense Desktop Salesforce Connection ERROR

moll_whit — Mon, 18 Nov 2024 15:14:13 GMT

@benwashburne Did you find a solution or work around to connecting to the non-standard URL? I believe we are running into a similar issue.