Qlik Data Gateway: Unable to load MS Access (.accdb) data via Data Manager

[Nao_Baba]

Loading MS Access data (.accdb file) using generic ODBC (via Data Gateway) in Data Manager fails with the following error:

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.

The Direct Access ODBC Connector log reads:

Message=Error in HandleJsonRequest for method=getRawScript,
exception=Exception, error=ODBC Wrapper: Unable to execute SQLForeignKeys:
[Microsoft][ODBC Driver Manager] Driver does not support this function.
internalError=True

Resolution

Use the Data Load Editor to load MS Access data.

Loading file-based Access DBs through ODBC to a modern BI tool is not recommended, specifically with larger files. These are likely to underperform during the loading process.

Cause

This error indicates the MS Access ODBC driver doesn’t support the SQLForeignKeys ODBC function. However, retrieving the table foreign keys is essential for Data Manager (as opposed to Data Load Editor).

Internal Investigation ID(s)

SUPPORT-4446

Environment

• Qlik Cloud Analytics
• Qlik Data Gateway