Loading data from databases

You can load data from commercial database systems into Qlik Sense through the following connectors:

• Standard connectors using the Microsoft ODBC interface or OLE DB. To use ODBC, you must install a driver to support your DBMS and you must configure the database as an ODBC data source in the ODBC Data Source Administrator in Windows Control Panel.

• Custom connectors, specifically developed to load data from a DBMS into Qlik Sense.

  Qlik Sense Custom Connectors help

Loading data from an ODBC database

The easiest way to get started loading data from a database, such as Microsoft Access or any other database that can be accessed through an ODBC data source, is by using the data selection dialog in the data load editor.

To do this, do the following:

1. You need to have an ODBC data source for the database you want to access. This is configured in the ODBC Data Source Administrator in WindowsControl Panel. If you do not have one already, you need to add it and configure it, for example pointing to a Microsoft Access database.
2. Open the data load editor.
3. Create an ODBC data connection, pointing to the ODBC connection mentioned in step 1.
4. Click ± on the data connection to open the data selection dialog.

Now you can select data from the database and insert the script code required to load the data.