Qlik Community

QlikView Connectors

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Multiple Salesforce Connections in one QV applicaiton

I've got a UserID to multiple production Salesforce orgs and built a single QV app to query a specific table from each of these - they all have different CUSTOMCONNECT commands but the same LOAD and SQL statement.

But when I execute the app, I get an error when it tries to initiate the second connect. So, if I comment out the first connect the second works fine so I know there is no syntax error.

Is there a close connect command I need to write or a wait command etc before the second/third connect?

Thanks. Jay

Tags (1)
3 Replies
mov
Esteemed Contributor III

Multiple Salesforce Connections in one QV applicaiton

There is DISCONNECT statement. Manual says it is optional, so it maybe won't help. Worth trying.
(In fact, I am using it in a similar situation, have to connect to different databases on different servers.)

Not applicable

Multiple Salesforce Connections in one QV applicaiton

What error are you getting on second connect?

Not applicable

Re: Multiple Salesforce Connections in one QV applicaiton

Did you ever solve this Jay? I am having the same issue

I put DISCONNECT right at the end of the first block and then used the CUSTOM CONNECT command. This was the error I got:

Garbage after statement

DISCONNECT

CUSTOM CONNECT TO "Provider=SalesForceDLL.dll;T26;XUserId=FZFNd.......................................;"