topic Variables from file (SSH Automation) in Talend Studio

Variables from file (SSH Automation)

Anonymous — Sun, 23 Oct 2016 15:56:58 GMT

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
Thanks for any answers.

Re: Variables from file (SSH Automation)

cterenzi — Mon, 24 Oct 2016 16:23:09 GMT

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.

Re: Variables from file (SSH Automation)

Anonymous — Tue, 25 Oct 2016 19:18:29 GMT

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