UDC Oracle ODBC Connection Issue

Rehan — Thu, 09 Jan 2020 17:05:22 GMT

I am using Qlik Sense Sever 13.51.4. I am trying to connect to the Oracle Database tables for UDC using the below string

Driver={Oracle in OraClient 12Home3};dbq=Databasename;uid=NUser_Name;pwd=Password;

I am getting the error as attached.

I am able to created a ODBC connection on the sever successfully but not in UDC. what am I missing here

I have the User table name defined as Owner.User_Table

Attribute table as Owner.Attribute_Table

Re: UDC Oracle ODBC Connection Issue

dialog_sistemi — Wed, 08 Apr 2020 07:50:14 GMT

I solved all my problems wuth UDC using "windows" ODBC connection not Qlik.

In UDC, I use the same string as in "data connection", insert the DSN name as in the following image

UDC connectionData connection