2 Replies Latest reply: Oct 10, 2018 1:55 AM by Petter Skjolden RSS

    Loading data into qlik sense from the file available on unix box

    bhawna Agrawal

      Hi All,

       

      Can you please confirm me if it is possible to connect qlik sense( access this application from windows machine) with unix server and load the data from the file available on the unix server.

       

       

      Thanks in advance.

        • Re: Loading data into qlik sense from the file available on unix box
          Petter Skjolden

          Depending on how your Unix box can serve up files you could use:

           

          A) FTP transfer protocol to get file(s) - then your Unix box has to have an FTP server installed and running. Many Unix computers acting as servers have or it is easy to set up.

           

          B) Samba/SMB/CIF protocol - which is Windows own file sharing protocol. Can be installed on most Unix operating systems - then a file share mapping could be done towards the Unix box acting as a "Windows" file server. And you can retrieve the files via a drive letter like you would do with a Windows server.

           

          The A option would look like this:

           

          LOAD

              @1

          FROM [lib://FTP]

          (txt, codepage is 28591, no labels, delimiter is '\t', msq);

           

          You will have to create a connection named FTP and it has to be a "Webfile" type of connection. Specify:

           

          2018-10-10 07_43_17-Qlik Sense Desktop.png

           

          <user>   would be replaced by the actual user name that you have for the FTP account

          <password>    the password for the FTP account

          <ftpserver>     should be the IP-address or hostname of the Unix computer

          <file>              the file that is on the default directory of the FTP account, you might need a path to override

           

           

          Be aware that FTP is not a secure communication protocol if it is not done on a secure net or combined with an SSH-tunnel - so study the security implications before using FTP.

          • Re: Loading data into qlik sense from the file available on unix box
            Petter Skjolden

            Come to think of it ... HTTP could also be used if the file could be made available via a web server on the Unix box in question. The procedure would be similar to what I said about FTP in my previous post.