topic How to load a log file from a remote server via SFTP? in QlikView

How to load a log file from a remote server via SFTP?

Fri, 24 Jul 2009 01:06:06 GMT

Hi there.

I've got my script working to LOAD a log file from my local workstation

Is there a way to load a log file from a remote linux server via SFTP?

- Simon.

How to load a log file from a remote server via SFTP?

disqr_rm — Fri, 24 Jul 2009 03:55:05 GMT

I don't think you can read directly using SFTP. What you can do is trigger a batch file, which will ftp it to a local or networked drive, then read it in QV from there.

How to load a log file from a remote server via SFTP?

Fri, 24 Jul 2009 04:09:58 GMT

That's what I'm doing now.

In fact, I'm just rsyncing the file from the remote linux server down to a the local windows server where the QlikView tool is running.

How to load a log file from a remote server via SFTP?

rwunderlich — Fri, 24 Jul 2009 05:38:01 GMT

Create a batch file that does the SFTP to a target file. In your script use either:

1. An EXECUTE statement to call the batch file.
2. Invoke a VB function that calls the batch file.

Then subsequently in the script load the target file.

-Rob

How to load a log file from a remote server via SFTP?

trey_bayne — Tue, 17 Apr 2012 19:41:31 GMT

Seems like this has been answered but I've put together a step by step solution. I thought this might help anybody else searching for an answer who needs a little more detail.

http://unconventionalqlikview.tumblr.com/post/20920052130/qlikview-and-secure-ftp-sftp