Transferring scheduled report/export set to SFTP (Azure Blob)

[sreter]

Afternoon, 

We've recently received a request to change a scheduled report that's been going to email recipients on a weekly basis over to an export / upload to an azure blob sftp destination.

We are not licensed for the SFTP Spoke in Integration Hub and the copy file activity in Orchestration isn't what we need either. I currently changed it over to be an export set going to our mid server, and created the Credential/Alias in SN (which can test connection fine), but am unsure how to get it moved over to the SFTP from the mid server. Is there a way to do this outside of workflow or flow designer, and instead just keep my report and use a scheduled job? Or is the mid server the best route, and just need to identify a way to kick off a script on the mid server side to transfer the file?

Thanks so much!

[Ankur Bawiskar]

@sreter 

Once you push file to SFTP there is no OOTB mechanism available to push it to SFTP.

You will require custom logic/solution for this which will be somewhat challenging to handle and maintain going forward.

You can write mid server script include which involves code of java packages along with ServiceNow javascript.

I will recommend place the file to mid server.

Let the customer's team write a powershell script to push the data from Mid server to SFTP. It will be maintained by customer's team.

check these links

Using export sets for SFTP file transfer 

Push .csv file from mid server to an SFTP location 

If my response helped please mark it correct and close the thread so that it benefits future readers.