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.
The attached document is available in the support portal for logged on user. To access it, please log in.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:
- QlikView Server all versions
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.
Also, when configuring the DSP Settings, keep in mind "Data source name" refers to the "Data source's driver name". This has been registered as a defect. (Bug ID QV-17173)
- 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