Loading data from databases

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

• Connectors that use the Microsoft ODBC interface or OLE DB. To use Microsoft 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.

• Connectors specifically developed to load data directly from databases through licensed ODBC drivers, without the need for DSN connections.

  For more information, see Qlik Connectors: Database.

Loading data from an ODBC database

There are two ways to load data from a database.

To connect directly to a database through one of the Qlik-licensed ODBC drivers, see the instructions for Database connectors on the Qlik Connectors help site.

For more information, see Qlik Connectors: Database.

Qlik-licensed ODBC drivers support the following databases:

• Amazon Redshift
• Apache Drill (Beta)
• Apache Hive
• Apache Phoenix (Beta)
• Apache Spark (Beta)
• Azure SQL
• Cloudera Impala
• Google BigQuery
• IBM DB2
• Microsoft SQL Server
• MongoDB (Beta)
• MySQL Enterprise
• Oracle
• PostgreSQL
• Presto
• Sybase ASE
• Teradata

To use the Microsoft ODBC interface, 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 Windows Control 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.