want to connect blob using sftp from remote system .

Question

Hi ,
I have a datalake storage and i have enabled sftp on that and have created a local user. I followed the below link

https://learn.microsoft.com/en-gb/azure/storage/blobs/secure-file-transfer-protocol-support-how-to?tabs=azure-portal

Now i have an open air back up tool tool which exports .csv files daily . This is the backup tool

Now i want to transfer these backup files to azure blob using sftp that i have created. Please help me achieving this .

Answer 1

@Amar Agnihotri Thank you for reaching out to Microsoft Q&A. I understand that you want to transfer backup files from your openair backup tool to Azure Blob using SFTP. For steps to do the same, I would suggest you refer to the Admin guide of your tool: https://www.openair.com/download/OpenAirAdminGuide.pdf

Here is what it says:

How do you want the data sent — Select how the data should be sent. Options include SCP, SFTP or
Email. Emails will not be sent if the files are larger than 60 MB. You can also suspend the service

■ SCP/SFTP settings
□ Address — Enter the IP address or DNS name for your SCP or SFTP connection.
□ Directory — Specify a directory to put the exported file in.
□ User name — Enter the user name used for your SCP or SFTP connection.
□ Password — Enter and verify the password for the SCP or SFTP service.
□ Status email — Enter an email address for status emails to be sent to.

□ Status notification — Select which events are included in status emails. You can include all events
or errors only.
□ Disable remote file attribute copy — Try to check this box if you receive setstat errors during
the ABS transfer.
□ Try to resume transfer when it fails — Check this box to try and resume the transfer in case the
connection to the SFTP server is interrupted. This is only available if you choose to send your data
using SFTP.
If the SFTP connection is interrupted, OpenAir will attempt to retry the scheduled automatic backup
transfer twice. After the third unsuccessful attempt, an error is logged and a status notification
email is sent to advise that the automatic backup was unsuccessful. The status notification email
also indicates if the connection is interrupted but the automatic backup completes successfully on
the second or third attempt.
□ Seconds between retry attempts — Enter the time interval (in seconds) between ABS transfer
attempts. The interval can be between 5 seconds (default) and 5 minutes.

Note: After you change the transfer method to SFTP, click Save to see the Try to resume
transfer when it fails box and Seconds between retry attempts field.

Hope this helps. Please let us know if you have any further questions and we will be glad to assist you further. Thank you!

Remember:

Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.

Want a reminder to come back and check responses? Here is how to subscribe to a notification.

Answer 2

@SaiKishor-MSFT Thanks