Using Qlik Sense

You can import Spark data into a Qlik Sense app through an ODBC connection. You specify which tables and columns in your data store to load into Qlik Sense, and then construct charts and stories to analyze and present that data.

The following procedure is written for Qlik Sense Desktop 2.1. The Simba Spark ODBC Driver also supports earlier versions of Qlik Sense Desktop.

To retrieve data from your Spark data store using Qlik Sense:

1. In Qlik Sense Desktop, from the Qlik Sense Desktop Hub, click Create New App.
2. In the Create New App dialog box, type the name of your new app and click Create, and then click Open App.
3. In the new app, click Add Data.
4. In the Select a Data Source dialog box, make sure that Connect My Data is selected, and then click ODBC.
5. In the Create New Connection (ODBC) dialog box, make sure that System DSN and the correct bitness for your version of Qlik Sense Desktop are selected.
6. From the list of data sources, select your DSN.
7. If your data store requires credentials for access, then in the Username and Password fields, type your credentials for accessing your data store.
8. Click Next .
9. In the Select Data dialog box, from the list of tables, select the check box next to each table that you want to include in your app.
10. To specify which columns from each table to include in your app, select the table, and then select the columns to include.
11. When you are done selecting the tables and columns that you need, click Load and Finish. The Select Data dialog box closes and the Data Loading dialog box opens.
12. When the data has finished loading, click Edit the Sheet.

You can now use Qlik Sense to analyze the data in those tables.

Related topics

• Troubleshooting