使用Logic Apps将数据从XML文件加载到Azure中的SQL数据库 [英] Load data from XML file to SQL database in Azure using Logic Apps

问题描述

我是Azure开发的新手，我很难找到我想做的事的例子. 我在Azure文件存储中有一个XML文件，并且我想使用Logic App将XML数据获取到SQL数据库中.

I'm new to Azure development, and I'm having trouble finding examples of what I want to do. I have an XML file in Azure file storage and I want to use a Logic App to get that XML data into a SQL database.

我想我需要先在Azure中创建一个"SQL数据库"，然后才能编写Logic App(正确吗?). 假设我有一些目标SQL数据库，是否可以使用Logic App连接器/触发器/进行以下操作:1)识别文件已上传到Azure，以及2)处理XML进入数据库? 如果是这样，是否可以配置/编写这样的连接器/触发器/任何东西，以便可以指定我拥有的用于在XML和数据库之间进行数据按摩的任何业务规则?

I guess I will need to create a "SQL Database" in Azure, before the Logic App can be written (correct?). Assuming that I have some destination SQL database, are there Logic App connectors/triggers/whatever that I can use to: 1) recognize that a file has been uploaded to Azure, and 2) process that XML to go into a database? If so, can such connectors/triggers/whatevers be configured/written so that any business rules I have, for massaging the data between the XML and the database, can be specified?

谢谢！

推荐答案

为了在Azure SQL数据库上执行CRUD操作，可以使用SQL连接器.可以在以下位置找到连接器上的文档: Logic App SQL连接器 将SQL连接器添加到逻辑应用

In order to perform CRUD operations on an Azure SQL Database, you can use the SQL Connector. Documentation on the connector can be found here: Logic App SQL Connector Adding SQL Connector to a Logic App

我自己也写了一个博客，内容涉及如何使用SQL连接器通过存储过程和OpenJSON执行批量操作:

I've also written a blog myself on how to use the SQL Connector to perform Bulk operations using a stored procedure and OpenJSON : Bulk insert into SQL

如果您选择使用存储过程，这可能会帮助您设计Logic App.

This might help you in designing your Logic App if you choose to use a stored procedure.

这篇关于使用Logic Apps将数据从XML文件加载到Azure中的SQL数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！