Qlik Connections
Follow this guide to configure a Qlik connection in an Alteryx Analytics Cloud workspace.
OAuth 2.0 Client App
Before the connection configuration, make sure to have the client app ready.
In the Qlik cloud console, go to My Qlik portal or sign in from Qlik.com by selecting Log In > Qlik Cloud.
Sign into your Qlik Cloud tenant as an admin.
You can also sign in from your Qlik Cloud tenant. Open the navigation menu , and select Administration > My Qlik.
Select Add New Client to create a new OAuth client.
Choose the Web Application as a client type.
Enter the Client Name and redirect QLIK_SERVER_URL:
Depending your project or workspace login, specify the URL in the following format
ttps://<Login_URL>/oauth2/callback
.Example:
https://us1.alteryxcloud.com/oauth2/callback
Use the URL you created while setting up the connection in Designer Cloud.
Note the CLIENT_ID and CLIENT_SECRET provided.
Define the necessary scopes based on the permissions required.
Select Save to register the Alteryx Cloud.
Use the provided Client ID and the Client Secret while registering the connection in the connection management window.
This is used to send a request to the /oauth/token endpoint using the Client ID and Client Secret.
Implement the token exchange to access Qlik resources.
Create API key with Qlik Cloud
Sign into your Qlik Cloud tenant as a Tenant Admin.
In the management console, select Settings.
Scroll to the API Keys section and enable API keys for the tenant.
Set the allowed maximum token age and the maximum number of active API keys per user.
Go to the Users section in the management console.
Select the ellipsis menu for a user and select Edit roles.
Select the box for Developer to grant the user developer privileges. Save the changes.
Have the user sign in and select their avatar in the top-right corner.
Select API Keys from the menu.
Select Generate new key.
Enter a name for the key and set the expiration time.
Select Generate to create the API key. Save the API Key.
Add the API endpoint URL (
https://<tenant hostname>/api/v1/users/me
).Select Send to make a request to the API endpoint.
Create Qlik Connection
Go to the Connections Page for more information.
To create the connection, navigate to the Connections page.
Select Create Connection and search for Qlik. You can also find it under Analytics tab under the search window.
Select the Qlik card.
Once the connection configuration form opens up
name the connection appropriately,
select the appropriate OAuth client from the dropdown for OAuth Client,
use OAuth and API Key for authentication,
select Authenticate.
You are led through a regular OAuth 2.0 flow of authenticating against your Qlik cloud tenant app.
Once the authentication is successful, save your connection and start using it in workflows.
Filtering Capability Under the Output Tool in Designer Cloud
Follow these steps to setup the configuration for PowerBI in a workflow:
Drop an Output Tool onto the canvas.
Select the Qlik cloud connection and let it load the browsing experience for finding Qlik Datasets.
You can filter the appropriate Space and collection for the destination.
Select the destination for the dataset at the preferred space and collection within the user’s Qlik Hub.
Locate the correct workspace as applicable and select it.
Find the appropriate dataset under the workspace
optionally, select create a New Dataset,
select + New Dataset in your workspace,
on the pop-up window, add appropriate name for the Qlik cloud Dataset (ensure you have the required authorisation for the space and collection) and select Save. Now you can see the newly created dataset in the workspace (use the search bar to find it).
Select a space and collection under the selected dataset. You can only add one Table per Output Tool.
Select the either Append or Create New.
Select Continue.
Known Limitations
Only CSV files are supported as the output format. You can change the delimiter option to tab for a CSV.
Ensure to write the file under the space and collection combination.
When you use an overwrite option, the collections and tags file associated gets decoupled.
Output tool does not show an error if the user edited a tested connection with incorrect values. The test connection passes, but the Output tool doesn't show any files linked with the user.
While filtering in the Output tool, you can see the Spaces you have access to with all collections listed. Ensure you select a collection you have access to.