topic Re: Qlik Sense connectivity to OneStream in Connectivity & Data Prep

Qlik Sense connectivity to OneStream

AndyMBriggs — Tue, 08 Feb 2022 11:04:31 GMT

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?

Re: Qlik Sense connectivity to OneStream

Francisco_Fernandez — Mon, 14 Feb 2022 08:32:34 GMT

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-connector.htm#anchor-5".

[2]https://help.qlik.com/en-US/connectors/Subsystems/REST_connector_help/Content/Connectors_REST/Create-REST-connection/Connection-examples.htm

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

Best regards,

Francisco

Re: Qlik Sense connectivity to OneStream

AndyMBriggs — Mon, 14 Feb 2022 15:15:08 GMT

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.