How To Connect To Database Over OLEDB In QlikView?

[ToniKautto]

Most SQL compliant database server (e.g. Microsoft SQL Server, Oracle, Microsoft Access) allow connections over OLEDB. This however requires that there are OLEDB drivers available for the database server software. 

Prerequisites

• Download OLEDB drivers from the database server vendor
• Install OLEDB drivers on the machine where QlikView will reload
• Make sure the OLEDB installation is availabel for the user accessing QlikView

Set up OLEDB connection in QlikView

1. Open QlikView desktop client
2. Access document that should load from OLEDB source
3. Go to Script Editor (Ctrl + E)
4. Go to Data tab
5. Under Database select OLEDB
6. Click Connect...
   
7. Select the preferred database driver
8. Fill in the database access credentials and details. Contact database server administrator for details, if you do not know what to fill in.
   
9. Click OK
10. CONNECT string is added to the script
11. Reload (Ctrl + R) application to confirm correct settings
12. QlikView accessed database correctly if reload finished without any errors. Else repeat steps above and validate that connection details are accurate.