Redirect URI for setting up Qlik Replicate with Snowflake OAuth (Qlik Replicate 2023.11 build)

[Dineshan]

For instructions on how to set up Qlik Replicate with OAuth in conjunction with Snowflake, see Using Snowflake on Azure as a target | Setting general connection paramaters. During the setup, a redirect URI is needed.

This article documents the OAuth setup (simplified) and provides details on the redirect URI.

1. Create a Snowflake Account. Use the following Link: https://signup.snowflake.com/
   
   Verify that one user has a SYSADMIN role. This role will be used for the creation of a refresh token in Qlik Replicate.
   
   
2. In your Snowflake account, run the following query as ACCOUNTADMIN:
   
   

   create or replace security integration {name_of_security_integration}
   type=oauth
   enabled=true
   oauth_client=CUSTOM
   oauth_client_type='CONFIDENTIAL'
   oauth_redirect_uri='http://{localhost}/attunityreplicate/rest/oauth_complete'
   oauth_issue_refresh_tokens=TRUE
   oauth_refresh_token_validity=86400;

   
   

   In {localhost}, place the URL of the domain you wish to connect from (Qlik Enterprise Manager, Qlik Replicate on Linux, Qlik Replicate on Windows with port 3552).

3. To know the parameters that need to be inserted in Qlik Replicate for the specific domain you chose, run the query:
   

   desc integration oauth_KB

4. Copy the parameters and insert them in Qlik Replicate
5. In Qlik Replicate, when pressing on 'Generate refresh-token', use the account with the role SYSADMIN 

Environment

Qlik Replicate