topic Configurable ODBC in Qlikview server in QlikView

Configurable ODBC in Qlikview server

bhargav_bhat — Tue, 28 Mar 2017 12:51:55 GMT

Hi,

I am trying to connect to the User Directory through configurable ODBC in Qlikview Management Console.But I am getting an error as

Exception when connecting to the data source

Error:IM002 Data source name not found nad no default driver specified

Can anyone help me on the steps that needs to be followed for successful connection

Regards,

Bhargav

Re: Configurable ODBC in Qlikview server

awhitfield — Tue, 28 Mar 2017 13:03:08 GMT

Have you actually created the required DSN first?

Andy

Re: Configurable ODBC in Qlikview server

bhargav_bhat — Tue, 28 Mar 2017 13:08:28 GMT

Hi,

I have created the DSN and in the path I have given ODBC://localhost

and given username and password of the admin user

Re: Configurable ODBC in Qlikview server

awhitfield — Tue, 28 Mar 2017 13:10:16 GMT

What's the full CONNECT line in the script?

Re: Configurable ODBC in Qlikview server

bhargav_bhat — Tue, 28 Mar 2017 13:25:21 GMT

Hi Andrew,

when I connect through same DSN in QLikview application in the script it appears as

ODBC connect to TEST_ODBC;

select * from Db.Test.Table

But when I try to connect through Configurable ODBC in QMC I am getting the above error

can you please suggest me the steps that needs to be followed

Regards,

Bhargav

Re: Configurable ODBC in Qlikview server

awhitfield — Tue, 28 Mar 2017 13:36:29 GMT

Re:

But when I try to connect through Configurable ODBC in QMC I am getting the above error

can you please suggest me the steps that needs to be followed

Please supply a screen shot that shows what you are trying to do.

Andy

Re: Configurable ODBC in Qlikview server

Peter_Cammaert — Tue, 28 Mar 2017 13:47:21 GMT

System DSN or User DSN?

A User DSN will be visible to you and can be used in QV Desktop.

A System DSN will be visible to all, including the DSC/QMS/QDS/QVS service account.

Re: Configurable ODBC in Qlikview server

bhargav_bhat — Tue, 28 Mar 2017 13:48:37 GMT

Hi below is the screenshots

I have given admin user's name and password

In Data source name given DSN name

for entity name given the name of the column in the table in database having entity name

for Entity table db name gave the name of the table in database

for Groups table gave the Groups table name

for Conn db name gave the database name

Re: Configurable ODBC in Qlikview server

awhitfield — Tue, 28 Mar 2017 14:26:59 GMT

Hi Bhargav,

sorry never used that, check out the attached Help Link which may help:

Andy

http://help.qlik.com/en-US/qlikview/12.1/Subsystems/QMC/Content/QMC_System_Setup_DirectoryServiceProviders_ConfigurableODBC.htm

Re: Configurable ODBC in Qlikview server

bhargav_bhat — Tue, 28 Mar 2017 15:00:36 GMT

Hi Peter,

Thanks for replying

I have used System DSN only

Re: Configurable ODBC in Qlikview server

bhargav_bhat — Wed, 29 Mar 2017 10:37:31 GMT

Hi Peter,

I want to connect to PostgreSQL database for the user directory for the configurable ODBC in Directory Service Connector in QMC and for that I have used 64 bit System DSN and in the Configurable ODBC settings

I have followed the steps mentioned int he below blog

Configurable ODBC: The Documentation description

But after setting the server name and Username and Password I am getting an error

FATAL: no pg_hba.conf entry for host "IPaddress", user "user", database "db", SSL off

but using same DSN I am able to connect to the database in the Qlikview application

can you please help me reslove this issue

Regards,

Bhargav