topic Re: Configure UDC for Oracle in Qlik Sense in QlikView

Configure UDC for Oracle in Qlik Sense

sujith1011 — Mon, 27 Jul 2015 16:25:26 GMT

I am new to QlikSense and I keep getting error while trying to configure UDC on Oracle ODBC

I have created Oracle ODBC using 64 Bit ODBC Driver "ORACLEODBC"

User Table Name : Group

Attribute Table Name : Entity

Visible Connection String : Driver={Oracle in OraClient11g_home1};dbq=ORACLEODBC;uid=SCOTT;pwd=Tiger;

Encrypted Connection : ___________

Synchronization timeout : 240

When I click on Apply

The User Directory connector (UDC) is not configured, because the following Error occured:

Exception When trying to connect to the data source. Edit the connection string in the user directory connector configuration

The User Directory Connector(UDC) is not operational

Note :I also have the 32 Bit ODBC on the server.

Re: Configure UDC for Oracle in Qlik Sense

Tue, 17 Nov 2015 17:23:10 GMT

I got similar issue of Mysql

Re: Configure UDC for Oracle in Qlik Sense

sujith1011 — Tue, 17 Nov 2015 19:01:27 GMT

My recommendation is to uninstall all MySQL drivers (64 and 32 ) if any

and then install only 1 64 bit driver

inorder to construct the string go to C:\Windows\System32\odbcad32.exe--> Drivers

Get the Driver name from "Driver " Tab and make sure there is no extra space

eg for oracle

Driver={Oracle in OraClient11g_home1};dbq=ORACLEODBC;uid=SCOTT;pwd=Tiger;

Driver={Oracle in OraClient11g_home2};dbq=ORACLEODBC;uid=SCOTT;pwd=Tiger;

Driver={Oracle in OraClient11g_home4};dbq=ORACLEODBC;uid=SCOTT;pwd=Tiger;

you can even try with multiple versions of 64 bit drivers but make sure you only have one driver installed at any time

also make sure you have 2 tables created in the schema

NOTE : table name can be anything but column name is important.

Data type all strings

Create table Q_USER

(USERID VARCHAR2(100),

NAME VARCHAR2(100) );

Create table Q_ATTRIBUTE

( USERID VARCHAR2(100),

TYPE VARCHAR2(100),

VALUE VARCHAR2(100) );

Re: Configure UDC for Oracle in Qlik Sense

wangxusq — Tue, 19 Sep 2017 02:58:28 GMT

Hi，

I tested it according to what you said, but still error.

could you help me ?

https://community.qlik.com/message/1344908#1344908

Re: Configure UDC for Oracle in Qlik Sense

sujith1011 — Wed, 20 Sep 2017 15:06:50 GMT

Scott,

could you verify the oracle driver please, make sure you only have one oracle driver and preferably 12c

there are some bugs in 11g versions of driver

Re: Configure UDC for Oracle in Qlik Sense

wangxusq — Wed, 20 Sep 2017 23:42:53 GMT

Hi,

Thanks for your reply.

Now my PC has 32-bit client(11 version) and 64-bit 11g DB driver. I tried to unistall 32-bit client and just stay the 64-bit before,but at last the error still existed.

So you mean I must uninstall 32-bit and 64-bit 11g version,and then just install 12c driver ?And no matter 32bit or 64bit?

Re: Configure UDC for Oracle in Qlik Sense

wangxusq — Thu, 21 Sep 2017 03:09:48 GMT

Thanks, I have sovled it.

Re: Configure UDC for Oracle in Qlik Sense

sujith1011 — Thu, 21 Sep 2017 18:38:45 GMT

cool, glad it resolved, just curious what did you do to resolve it

Re: Configure UDC for Oracle in Qlik Sense

zahidrahim_ocp — Wed, 18 Oct 2017 09:58:17 GMT

Dear Experts,

I am also facing the same issue creating UDC for Oracle:

I have installed Oracle 11g Client.

Created two tables.

Created a DSN with the name TEST.

Giving below entries in UDC form:

Identification:

Name: TEST

Type: ODBC

User Sync Settings:

Uncheck

Connection:

User Directory Name: TEST

User Table Name: apps.q_user

Attribute Table name: q_attribute

Visible Connection String: Driver={Oracle in OraClient11g_home1};dbq=ORACLEODBC;uid=apps;pwd=apps;

Encrypted Connection String: <blank>

Synchronization timeout(seconds):240

Getting error: "Exception while tring to connecting to the datasource"

Regards,

Zahid Rahim

Re: Configure UDC for Oracle in Qlik Sense

sujith1011 — Wed, 18 Oct 2017 13:44:52 GMT

Zahid,

Please install 64 bit oracle driver, and make sure you do not have any 32 bit client

thanks,

Sujith

Re: Configure UDC for Oracle in Qlik Sense

Anonymous — Tue, 03 Apr 2018 11:45:15 GMT

Hi Scott Wang,

Can you guide me how did you solved this case ?

Re: Configure UDC for Oracle in Qlik Sense

wangxusq — Mon, 09 Apr 2018 08:06:17 GMT

I used 12c driver