Note: Configurable ODBC cannot be used as an authentication method. It allows QlikView to access a user repository, but any authentication needs to be configured in a third party sign-on method.
Disclaimer: Please be aware that this document is not supported and meant only as a guide. Individual environments may require adjustments for things to work correctly. Please contact QlikView Expert Services for further assistance with specific configurations.
This document outlines the steps needed to set up a simple Configurable ODBC DSP in QlikView's Directory Service Connector using either Mircrosoft SQL Server, Excel or Oracle workbook as the data source.
Environment:
Resolution:
The attached zip file contains a very simple Microsoft SQL Server database, ORACLE and an Excel workbook, either of which may be used as a data source for the Configurable ODBC. Also contained in the zip file is a document, SettingUpConfigurableODBCDSP.docx, which outlines the steps to configure a connection to the above resources and test the configuration.
Please note, it does not go into setting up an interface to authenticate users or any additional coding that may be required.
Items covered:
- What tables and fields are required
- Creation of the ODBC System DSN
- Configuration of the Configurable ODBC DSP
- Configuration of the Qlikview Web Server, with respect to use of the Configurable ODBC DSP
- Configuration of the QlikView Server, with respect to use of the Configurable ODBC DSP
- Testing the connection via the QlikView Management Console and utilizing Fiddler
