Integrating Single Sign On in Qlikview – Part II

After having created our Entity and Group views, it is time to setup the Directory Service Connector in QMC.

Basically, Directory Service Connector keeps track of the users and it is needed for other management tasks that involve users, such as licence assignment.

In my example, we have all our users in a database. In order for Qlikview to access these users, we must setup a Configurable ODBC connection.

*Note: make sure you first create an ODBC connection in your server.

Open QMC, go to System –> Setup –> Directory Service Connectors –> Configurable ODBC.

Click on the + green button. Here, we must fill in three fields.

Path: enter the IP address where the database is hosted. Make sure you use prefix ODBC://. Ex:  ODBC://
User Name: enter the user name used to access the database. You can check if the user/password is the right one but making a connection in a script within Qlikview Desktop.
Password: database password.

Test your ODBC connection

Test your ODBC connection

Then we click on Apply and we should be able to see a little pen icon. Click on it to edit the ODBC connection settings. The following window will pop up:

DSC Settings

DSC Settings

Service timeout in seconds: timeout in seconds. We can leave the default 30 seconds.
Directory label: you can choose any name you want. This name will be used as your domain. In my example, users will show up as SSO\myUser
Entity name: enter the field name holding the entity names in your entity table/view. Ex: entity_name.
Entity table db name: enter the name of the table/view we created for the entities. Ex: SSO_ENTITY.
Groups table db name: enter the name of the table/view hold Groups data. Ex: SSO_GROUPS.
Database backend: in this case I’ll choose ODBC.
Override connection string: you can leave this field blank unless you prefer to create your own connection string to the database instead of using an ODBC connection. Click here to learn how to setup a connection string.

Click on confirm. If there are no errors,  you’ll see a small red star right next to the small pencil. You can hover over the red star for more information on the error.

In the next post, we will see how we can search for the users and the queries used by DSC.

Keep reading:

Integrating Single Sign On in Qlikview – Part I

Integrating Single Sign On in Qlikview – Part III


Tags: , , , , , , , , ,

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: