Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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) );
I got similar issue of Mysql
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) );
Hi,
I tested it according to what you said, but still error.
could you help me ?
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
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?
Thanks, I have sovled it.
cool, glad it resolved, just curious what did you do to resolve it
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
Zahid,
Please install 64 bit oracle driver, and make sure you do not have any 32 bit client
thanks,
Sujith