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.

  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.

Qlik Connectors: Database

Qlik-licensed ODBC drivers support the following databases:

• Amazon Redshift
• Apache Hive
• Cloudera Impala
• Google BigQuery
• IBM DB2
• Microsoft SQL Server
• MySQL Enterprise
• Oracle
• PostgresSQL
• 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.