2 Replies Latest reply: Aug 1, 2018 7:19 AM by abhay singh RSS

    How to read Binary data from database Table

    abhay singh

      Hi guys,

       

      I have to read binary data from database itself, like some data is converted into binary and stored in database tables,

      i need to fetch this data into qlik and convert this data to tabular format.

       

      i am attaching the sample data as well.

       

      Please suggest.

       

      Field name is

      PublishedPDF

       

       

      thanks in advance

       

      regards

      Abhay singh

        • Re: How to read Binary data from database Table
          Bala Bhaskar

          Try like these scenarios:

          load binary in mysql load using HEX() function like this:

           

          LOAD ...;

           

          SQL SELECT

               HEX(Id) as Id,

               Name,

          FROM table01;

           

          OR

           

          ODBC CONNECT TO [PetesDFM;DBQ=xe] (XUserId is eLNcfZFPTDdKWWZK, XPassword is eSfTSSRNMLaeGaROCE);

           

          PeteDFM:

          SQL SELECT IAMGE,

             IMAGETYPE

          FROM SYSTEM.QLIKVIEWIMAGES;

           

          //info select imagetype, iamge from system.qlikviewimages;//-------- Start Multiple Select Statements ------

           

          INFO SELECT IMAGETYPE, IAMGE FROM SYSTEM.QLIKVIEWIMAGES;

           

          Refer this:

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

            • Re: How to read Binary data from database Table
              abhay singh

              Hi Bala  Thanks for reply,,.

               

               

              tried this ,,,

              LOAD ...;

               

              SQL SELECT

                   HEX(Id) as Id,

                   Name,

              FROM table01;

              but its not working...

               

              can you suggest this how i can use this ?

              ODBC CONNECT TO [PetesDFM;DBQ=xe] (XUserId is eLNcfZFPTDdKWWZK, XPassword is eSfTSSRNMLaeGaROCE);

               

              PeteDFM:

              SQL SELECT IAMGE,

                 IMAGETYPE

              FROM SYSTEM.QLIKVIEWIMAGES;

               

              //info select imagetype, iamge from system.qlikviewimages;//-------- Start Multiple Select Statements ------

               

              INFO SELECT IMAGETYPE, IAMGE FROM SYSTEM.QLIKVIEWIMAGES;

               

              thanks