Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.
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.
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
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