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

[#1]

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.

[disqr_rm · Accepted solution]

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.

[#3]

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.

[rwunderlich]

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

[trey_bayne]

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