Qlik Cloud: MS Access data not loaded using Data Manager and ODBC

[Nao_Baba]

Loading MS Access DB data via Qlik Data Gateway fails when using the Data Manager. The following error is thrown:

Failed to add data

Data could not be added to Data manager. Please verify that all data sources connected to the app are working and try adding the data again.

Loading data through the Data Load Editor works as expected. 

Reviewing the ODBC log for additional details highlights the error:

System.Exception: ODBC Wrapper: Unable to execute SQLForeignKeys: [Microsoft][ODBC Driver Manager] Driver does not support this function

Resolution

This is a driver-related issue and a known limitation. 

Use the Data Load Editor instead of the Data Manager.

Considerations of using MS Access with Qlik Sense:

MS Access is a legacy technology dating back to the 1990s; loading data from a file-based Access database via ODBC into a modern BI tool is considered an outdated solution. Moreover, with larger files, this approach is likely to result in significant performance degradation during data loading.

Cause

The MS Access ODBC driver does not support the SQLForeignKeys ODBC function.

Environment

• Qlik Cloud Analytics