4 Replies Latest reply: Oct 16, 2016 11:43 PM by Brijesh Maurya RSS

    Configure UDC for MySql in Qlik Sense

    Brijesh Maurya

      Hi All,

      I have a Urgent Need. Kindly Help me to resolve this.

       

      Say I Created 2 Table in MySql database .

      User Table:

      LOAD `userid`,

          name;

      SQL SELECT `userid`,

          name

      FROM justtry.`q_user`;

       

      And

      Attribute Table:

      LOAD `userid`,

          `type`,

          value;

      SQL SELECT `userid`,

          `type`,

          value

      FROM justtry.`q_attribute`;

       

      And in UDC , I Used  SQL(Via ODBC)

       

      and i created visible connection string :

      Driver={MySQL ODBC 5.3 ANSI Driver};Server=172.10.5.146;Database=justtry;Trusted_Connection=yes;dsn=justtry;

       

      But Still i am Getting an Error,

       

      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

       

      As Well find the image for Error. Both the Table i can able to fetch using Script Editor.