Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team
When having any issue fetching data from Data Source to Qlik Products(QlikView or Qlik Sense) via ODBC DSN, it is crucial to determine whether it is general or Qlik specific.In order to investigate, the best way is to establish connection and fetch data from a 3rd party tool. Chances are:
Note this article is for testing ODBC connection. Also see related How to fetch data with ODBC DSN connections using PowershellFor testing OLE DB Connection String, please refer to article How to externally test an OLEDB Connection String using Windows PowerShell.
DSN must be already created and tested.
Then use one of the two options below.
Double-click the .DQY file. Excel will show a Security Notice. Click "Enable".