How to set up FTP to retrieve data from a Gateway Periodically?

Question

How to set up FTP to retrieve data from a Gateway Periodically?

Nadim Khoury 0

Context: I have several gateways connected to several physical devices to provide me with granular meter readings. The gateways can push the data through email or FTP. I wish to explore the FTP option as it bypasses human intervention everytime data is received, this way the data will be pushed directly to the Azure Storage account.

Is Azure Storage the appropriate solution to my problem? If so, how to set up the account and receive the credentials to be input in to the gateway interface? Secondly, as the data is being pushed through FTP periodically from the different gateways, how to expect the output on Azure as I will have several data sources and periodic data?

Nadim Khoury 0 Reputation points

2025-04-08T04:40:37.79+00:00

Hello Hari, thank you for your reply. As per the user manual of the Gateway, I can schedule the FTP push for its own interface. All I need to do is provide the Gateway with an appropriate Server Address, Port Number, Destination Folder on Server, and a Username and Password. Can you please advise on where I could find the above? Also, does that mean I am not required to set up Azure Data Factory since the Schedule push is configured from the gateway itself?
Hari Babu Vattepally 3,345 Reputation points Microsoft External Staff Moderator

2025-04-08T11:37:24.5733333+00:00

Hi @Nadim Khoury ,

Thanks for the response.

You can find the specific information to configure their gateway's FTP Push is that the server address is the domain or IP address of the FTP server. Here, the default port number for FTP is 21 and for Secure FTP (SFTP) is 22. Please make sure that FTP server is properly configured to support the required protocol.

And, the destination folder on server is the folder path on the FTP server. Where you want to store the retrieved data. Then the username and password these are your credentials for accessing the FTP server. These credentials are setup when creating user accounts on FTP server.

Since you Gateway allows you to schedule the FTP push directly from interface. Then you don't need Azure Data Factory. However, Azure Data Factory or similar tools might be useful in future for additional data integration capabilities.

Here is the additional recommended workflow:

Install and configure an FTP server which acts as an intermediate between your gateway and Azure Blob Storage.

Use Azure logic apps to automate transferring data from FTP server to Azure Blob Storage, without the need for Azure Data Factory. Also, use containers and directories in Azure Blob Storage to segregate data from different gateways.

However, use Azure monitoring features to ensure data uploads are consistent and troubleshoot any issues.

I hope the above helps in addressing your query.

Please let us know in the comments below, if the issue is resolved or still persists. We will be glad to assist you closely.

Please do consider to “up-vote” wherever the information provided helps you, this can be beneficial to other community members. Accepted answers show up at the top, resulting in improved discoverability for others.

1 answer

Your answer

Nadim Khoury 0 Reputation points

2025-04-08T04:40:37.79+00:00

Hello Hari, thank you for your reply. As per the user manual of the Gateway, I can schedule the FTP push for its own interface. All I need to do is provide the Gateway with an appropriate Server Address, Port Number, Destination Folder on Server, and a Username and Password. Can you please advise on where I could find the above? Also, does that mean I am not required to set up Azure Data Factory since the Schedule push is configured from the gateway itself?
Hari Babu Vattepally 3,345 Reputation points Microsoft External Staff Moderator

2025-04-08T11:37:24.5733333+00:00

Hi @Nadim Khoury ,

Thanks for the response.

You can find the specific information to configure their gateway's FTP Push is that the server address is the domain or IP address of the FTP server. Here, the default port number for FTP is 21 and for Secure FTP (SFTP) is 22. Please make sure that FTP server is properly configured to support the required protocol.

And, the destination folder on server is the folder path on the FTP server. Where you want to store the retrieved data. Then the username and password these are your credentials for accessing the FTP server. These credentials are setup when creating user accounts on FTP server.

Since you Gateway allows you to schedule the FTP push directly from interface. Then you don't need Azure Data Factory. However, Azure Data Factory or similar tools might be useful in future for additional data integration capabilities.

Here is the additional recommended workflow:

Install and configure an FTP server which acts as an intermediate between your gateway and Azure Blob Storage.

Use Azure logic apps to automate transferring data from FTP server to Azure Blob Storage, without the need for Azure Data Factory. Also, use containers and directories in Azure Blob Storage to segregate data from different gateways.

However, use Azure monitoring features to ensure data uploads are consistent and troubleshoot any issues.

I hope the above helps in addressing your query.

Please let us know in the comments below, if the issue is resolved or still persists. We will be glad to assist you closely.

Please do consider to “up-vote” wherever the information provided helps you, this can be beneficial to other community members. Accepted answers show up at the top, resulting in improved discoverability for others.

Answer 1

Hi @Nadim Khoury

Yes, Azure Storage is a suitable choice for your scenario, as it enables data storage from your gateways via FTP. To set up Azure Storage and obtain the required credentials for your gateway, follow these steps:- Please create a Storage Account from the Azure Portal or through CLI.

Once the Storage account is created, under Security+Networking section, find Access Keys. There will two keys and connections string. Copy one of the connection strings or keys, which you will input into your gateway interface.
And then Setup FTP to transfer data, using the Azure Data Factory to create pipeline that will periodically retrieve data from your FTP server and push it to your Azure Storage account. Then you will need to create a linked service in Azure Data Factory to connect to your FTP server. This involves specifying the FTP server details and the credentials you received earlier.
Since data is periodically pushed from the gateways, you can set up Azure Data Factory to monitor the FTP location and transfer the data to your Azure Storage account. In Azure Data Factory, you can configure triggers to automate data transfers according to your preferred schedule.

For more additional reference, please follow the below documents:

By following the above steps, you can effectively setup FTP to retrieve data from your gateways and store it in Storage accounts.

Please let us know in the comments below, if the issue is resolved or still persists. We will be glad to assist you closely.

Please do consider to “up-vote” wherever the information provided helps you, this can be beneficial to other community members. Accepted answers show up at the top, resulting in improved discoverability for others.

Hari Babu Vattepally 3,345 Reputation points Microsoft External Staff Moderator

2025-04-09T11:12:19.36+00:00

Hi @Nadim Khoury ,

Your contribution is highly appreciated. Please do not forget to "Accept the answer” and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.
Hari Babu Vattepally 3,345 Reputation points Microsoft External Staff Moderator

2025-04-10T03:05:16.5833333+00:00

Hi @Nadim Khoury ,

Following up to see if the above answer was helpful. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Hari Babu Vattepally 3,345 Reputation points Microsoft External Staff Moderator

2025-04-11T10:02:48.66+00:00

Hi @Nadim Khoury ,

Just checking in to see if the above answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Share via

How to set up FTP to retrieve data from a Gateway Periodically?

1 answer

Your answer