You can import your data into QlikView through an ODBC connection. QlikView's Script Editor generates a SQL script that connects to your data store and imports your data so that you can analyze the data in QlikView.
The following procedure is written for QlikView 12. Simba ODBC drivers also support earlier versions of QlikView.
Make sure that the bitness of the driver that you are using matches the bitness of QlikView. If you are using the 32-bit version of QlikView, then you need to use the 32-bit version of the driver. If you are using the 64-bit version of QlikView, then you need to either use the 64-bit version of the driver, or, in the Edit Script dialog box, select the Force 32 Bit check box. For more information about diagnosing the issue, see Architecture Mismatch Problems.
To retrieve data using QlikView:
- In QlikView, select File > New. If the Getting Started Wizard opens, close it. A new empty document is displayed in QlikView.
- Select File > Edit Script.
- In the Edit Script dialog box, in the Database list, make sure that ODBC is selected, and then click Connect.
- In the Connect to Data Source dialog box, from the Data Sources list, select your DSN.
- If your data store requires authentication, type your credentials in the User ID and Password fields.
- To make sure your connection is working, click Test Connection. Note the results in the Connection to Data Source Test dialog box and then click OK to close it.
- Click OK. The Connect to Data Source dialog box closes and an ODBC CONNECT statement is displayed in the main script area of the Edit Script dialog box.
- Click Select.
- In the Create Select Statement dialog box, select the data that you want to analyze in QlikView by doing the following:
- From the Database Tables list, select a table that contains data that you want to analyze.
- From the Fields list, select the fields that contain data that you want to analyze.
- Click Add.
To select data from other tables, repeat these steps as needed.
- When you are done selecting the data to include in your app, click OK to close the Create Select Statement dialog box.
- Select File > Save Entire Document. Browse to the location where you want to save the script, specify a file name for the script, and click Save.
- Click OK to close the Edit Script dialog box.
- Select File > Reload.
The script is executed and the specified tables are loaded into QlikView. You can now use QlikView to analyze the data in those tables.
For more information about connecting to a database in QlikView, see the QlikView help site: https://help.qlik.com.