Configure UDC for Oracle in Qlik Sense

[sujith1011]

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.

[#2]

I got similar issue of Mysql

[sujith1011 · Accepted solution]

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) );

[wangxusq]

Hi，

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

could you help me ?

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

[sujith1011]

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

[wangxusq]

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?

[wangxusq]

Thanks, I have sovled it.

[sujith1011]

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

[zahidrahim_ocp]

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

[sujith1011]

Zahid,

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

thanks,

Sujith