14 Replies Latest reply: Oct 9, 2016 12:20 PM by Rohit Kumar RSS

    ODBC connection to MariaDB

    VENELIN DIMITROV

      Hi everybody,

       

      I can not establish ODBC connection to MariaDB.

      I use next driver: mariadb-connector-odbc-2.0.12-win64 . But I also tried with mysql-connector-odbc-5.3.6-winx64 and previous version of MariaDB driver: mariadb-connector-odbc-1.0.6-win64.

      Please help me if someone already fixed the same issue.

       

      Regards,

      Venelin

        • Re: ODBC connection to MariaDB
          Toni Kautto

          Your question is a bit unclear. Please clarify what you are doing, what error you see and how you have tried to resolve it.

           

          My suggestion for using ODBC connection is to start with adding a Windows DSN which uses the desired driver to connect to your data source. The DSN should be added as a System DSN to be available for all users with access to the system, including the Qlik Sense service user.

           

          Does your conneciton work in Windows?

          - If NO, discuss further with your database administrator on how to establish the connection. The admin can confirm the required drivers and credentials.

          - If YES, add a data connection in Qlik Sense and connect and fetch data.

          • Re: ODBC connection to MariaDB
            Fernando Keuroglian

            Hi

             

            Can not establish? but what kind of error do you have?

             

            can you post an image to the error to be easier to help you?

             

            Fernando K.

            • Re: ODBC connection to MariaDB
              Rohit Kumar

              Hi Venelin,

               

              The point here is if you can create a connection between your machine and database so yes Qlik can use the same connection and retrieve the data.

               

              Now every database has different drivers , Please be sure which driver you are using and after installing driver check teh connection is working if yes then use the same connection in ODBC or OLEDB.

               

              I am sure you are using this driver :

              https://downloads.mariadb.org/connector-odbc/

               

              Please let me if you still face any issue

              • Re: ODBC connection to MariaDB
                VENELIN DIMITROV

                Hi everybody,

                 

                First thank you for the help, but the issue it was a dummy problem. We made a mistake when we filled in the QlikSense IP address in the Windows Firewall in MariaDB server.

                Now I have another problem with extracting the data from database. @Kumar, I use the same ODBC driver. QlikSense has a problem to reload the data from database. I see all tables in database, but I can't extracted some of tables.

                Previous version of database It was a normal MySQL server and everything was fine. Now we upgraded to last version of MariaDB and we can not extracted all tables from the same QliKSense Script.

                 

                Anyone can help me ?

                 

                Regards,

                Venelin