Establishing the SSH connection to pull the files from mainframe system to populate the data in ServiceNow table

[Abhijeet Anand]

Hello All,

We have a requirement to fetch the users and groups from the mainframe system and populate in the servicenow table. We are trying to establish the SSH connection to pull the text files containing users and groups from the mainframe system.

Can anyone help me with the list of steps that need to be done in order to do the above steps?

I am pretty new to this kind of integration and any help would be appreciated.

Thanks

[MattiasJonsson · Accepted solution]

SSH as a protocol is available in Integration Hub Professional / Automation Engine Professional.

Once you have that, along with credentials for the connection, you initiate the connection, traverse to the folder and parse the files.

Left - Terminal SSH connection to client and a list of a file content.

Right - SSH step connecting.

Bottom, result from SSH step test showing contents of text file.

If helpful or correct, please indicate so!

[Abhijeet Anand]

Hey Mattias,

Thank you for your input, requirement has changed a little bit,  we need to retrieve the .csv file from the mainframe system through SSH connection established. till now we have been able to set up the connection and the credentials has been validated. can you please let me know the script to retrieve the csv file from the mainframe system please?

I am assuming in the above screenshot, there has to be a step for script(to retrieve the file) and then SSH step.

let me know if i am going in a wrong direction.

[IanH1]

Hi Abhijeet,

Take a look here for a solution can help you with mainframe/ServiceNow integrations:  https://www.precisely.com/product/precisely-ironstream/ironstream-for-servicenow

Let me know if you have any questions - happy to help.