Getting started

This guide will teach you how to authenticate to Foundry within Qlik Sense, and get started loading datasets.

Connect to Foundry

• You will need to have a Foundry access token ready to authenticate.
• You will also need the name of the Foundry DSN created by your server admin
• Within Qlik Sense, open the data manager, and click the icon to create a new connection
• Select OLE DB as the data source
• Choose Microsoft OLE DB Provider for ODBC Drivers as the provider
• For the data source, enter <Foundry_DSN>;PWD=<Token>, where <Foundry_DSN> is the name of the DSN your server admin created, and <Token> is your Foundry token For example, you might end up with something like Foundry;PWD=eyJwbG50ci...
• Choose Specific user name and password, but leave them blank
• Pick an appropriate name for the connection. (Qlik may have set the token in the name by default, remove this!)
• Test the connection to check everything is OK, and then click create to open the table browser.

Loading datasets

After you've created a connection, a table browser will open. You can also open this browser by selecting a previously created connection. From here, you first select the Foundry project containing the dataset(s) you want to load (referred to as a "database" here).

The project tables will then be listed, and you can select the ones you wish to import.

Writing SQL queries

If you're familiar with SQL, you can write your own SQL queries from within Qlik Sense. This can be helpful for filtering and aggregating large datasets, so that only the smaller transformed data is imported into Qlik.

To do this, after creating a connection, open the data load editor and create a new script. Then write a SQL query like in the below image. Datasets can be referenced by their path or dataset RID, surrounded by double quotes.

For more documentation on the "LIB CONNECT" syntax, refer to the Qlik documentation.

To access a specific branch of a dataset, use the following syntax:

Copied!
1
SELECT * FROM "branch"."dataset_path"