每分钟获取API数据并存储到Azure SQL DB中 [英] Get API Data every minute and store into a Azure SQL DB

问题描述

大家好，

我有一个场景，我需要每分钟从API获取遥测数据并将此数据存储到Azure SQL DB中。我正在寻找可用于解决此问题的服务。我有2个服务，我想：

- 逻辑应用程序

- Azure Scheduler

- Azure数据工厂

您对每种方法有何看法？你能给我一些推荐给我场景的东西吗？

---

Atenciosamente Julio Araujo

解决方案

< blockquote>

在Data Factory中设置这样的任务很容易。 但是要考虑的一些问题是：

你打算扩大规模吗？或者您的流量是否仍然是每分钟不变的1个API调用？

执行API调用需要多长时间？ （某些数据工厂服务有长时间延迟的麻烦）。

您是否需要在存储之前对数据执行任何转换？

是时机电话重要吗？

一旦你得到了这些问题的答案，就可以提出更多建议。

Hi Guys,

I Have a scenario where I need to get telemetry data from an API every minute and store this data into Azure SQL DB. I am looking for a service that could be used to solve this problem. I have 2 services that I am thinking:

- Logic Apps

- Azure Scheduler

- Azure Data Factory

What do you think about each approach? Could you suggest me something recommended to my scenario?

---

Atenciosamente Julio Araujo

解决方案

Setting up such a task would be easy in Data Factory.  However some questions to consider would be:
Do you plan to scale up/out? or will your traffic remain a constant 1 API call per minute?
How long does the API call take to execute? (Some Data Factory services have trouble with long delays).

Do you need to perform any transformations on the data before storing?

Is the timing of the call important?

Once you have the answers to these questions, more recommendations can be made.

这篇关于每分钟获取API数据并存储到Azure SQL DB中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！