ODBC example

Each data source has a different configuration and below is one example of adding an ODBC user directory connector.

Do the following:

1. Verify that the Microsoft Access Text Driver is installed.

2. Set up an ODBC source on the server. You need to store the data in two separate csv files, for example in this location: %ProgramData%\Qlik\Sense\temp.

   Information noteThe temp folder is not included in the default installation. You need to create the temp folder, if not already done by another QMC administrator.

   Table1.csv contains the users and Table2.csv the attributes of the users. The values in the csv files are comma separated. The tables can for example look like this:

    

   Table1

   1	userid,name
   2	JoD,John Doe

   Table2

   1	userid,type,value
   2	JoD,email,jod@gmail.com

3. Select User directory connectors on the QMC start page or from the StartS drop-down menu to display the overview. Add a new user directory connector, default properties (ODBC) and edit the properties:

   Identification

   The Identification property group contains the basic UDC properties in the Qlik Sense system.

   All fields are mandatory and must not be empty.

   Property	Description
   Name	The name of the UDC configuration defined from the QMC.
   Type	The UDC type.

   User sync settings

   The User sync settings property group contains the user sync properties for the user directory connector.

   Property	Description	Default value
   Fetch user data on first access, then keep in sync	When selected, only the existing users are synchronized. An existing user is a user who has logged in to Qlik Sense and/or been previously synchronized from the configured directory service. When not selected, all the users, defined by the properties for the UDC, are synchronized from the configured directory service. You can create a filter to Active Directory or Generic LDAP if you only want to synchronize a selection of users.	Selected

   Connection

   The Connection property group contains the ODBC connection properties in the Qlik Sense system.

   Property	Description	Default value
   User directory name	The name of the user directory. Must be unique, otherwise the connector will not be configured.	-
   Users table name	The name of the table containing the users.	-
   Attributes table name	The name of the table containing the attributes of the users.	-
   Visible connection string	The visible part of the connection string that is used to connect to the data source. Information noteThe two connection strings are concatenated into a single connection string when making the connection to the database.	-
   Encrypted connection string	The encrypted part of the connection string that is used to connect to the data source. Typically contains user name and password. Information noteThe two connection strings are concatenated into a single connection string when making the connection to the database.	-
   Synchronization timeout (seconds)	The timeout for reading data from the data source.	240

   Example:  

   User table name: Table1.csv

   Attributes table name: Table2.csv

   Visible connections string:  Driver={Microsoft Access Text Driver (*.txt, *.csv)};Extensions=asc,csv,tab,txt;Dbq=%ProgramData%\Qlik\Sense\temp

4. Click Apply to apply your changes.

5. Go to the User directory connectors overview and check if the user directory is displayed as Configured and Operational.

   Information noteIf the User directory name is not unique the connector will not be configured. If not operational, check the repository system log in: %ProgramData%\Qlik\Sense\Log\Repository

You have now added an ODBC data source and initial synchronization will be performed within 5 minutes (by default).