Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Variables from file (SSH Automation)

I would like to create job that would automate some commands invocation using tSSH component. My initial design would look like this:
1. Ini file with IP of Servers (lets say 10 - 15 servers)
2. Read INI file, and then interate through every IP
3. tSSH uses IP from INI file (HOST parameter in components) to connect to server and invoke 3-5 commands.
4. Output is being saved to file for every IP address.
I managed to do it for 1 server (no iteration just hardcoded IP address in HOST parameter of components tab in tSSH). 

Question is: Can it be done? And of course how 0683p000009MACJ.png
Thanks for any answers.

Labels (2)
2 Replies
cterenzi
Specialist
Specialist

A tFileInputDelimited with a single String column titled "IP" as the schema will import your INI file. Connect that to a tFlowToIterate, and then an Iterate connection to your tSSH component.

Reference the current IP as row1.IP in the tSSH component's Host setting.

0683p000009MFt7.png
Anonymous
Not applicable
Author

Thanks, actually done it with generating rows (on the beginning).