Qlik Sense connectivity to OneStream

[AndyMBriggs]

We have a requirement to acquire data from the OneStream cloud financial consolidation product. Although OneStream supports REST it does require OAuth and the Qlik Sense product notes say Qlik support REST but not using OAuth. Has anyone else overcome this issue please and how did you solve it?

[Francisco_Fernandez · Accepted solution]

Hello @AndyMBriggs ,

We noticed that you've contacted us through a case. 

I'm going to share our response in case it might be useful to someone else:

The Qlik REST Connector does not support OAuth schema authentication officially[1][2].

However, you can use OAuth with Qlik REST Connector, you will need to modify the connection in the script as explained in this article[3].

[1] "https://help.qlik.com/en-US/connectors/Subsystems/REST_connector_help/Content/Connectors_REST/REST-c...".

[2]https://help.qlik.com/en-US/connectors/Subsystems/REST_connector_help/Content/Connectors_REST/Create...

[3] "https://community.qlik.com/t5/Qlik-Sense-Documents/Handling-Refresh-Tokens-with-the-Qlik-REST-Connec...".

Best regards,

Francisco

[AndyMBriggs]

Thanks. We haven't yet succeeded with this method but it did help. So far, my colleague has adapted the method to get past the first step and the next challenge is that the source system only support bearer tokens so we are investigating how to switch Qlik REST to use a non-SELECT mode.