如何将SharePoint列表或Excel文件移动到Azure SQL DW? [英] How to move sharepoint list or excel file to azure sql dw?

问题描述

我想使用azure datafactory或替代服务将数据从sharepoint复制到Microsoft azure sql DW.我可以这样做吗?请任何人帮助我.

I want to copy data from sharepoint to microsoft azure sql DW using azure datafactory or alternative service. Can I do this. Please anyone help me with this.

推荐答案

您可以通过 load数据从blob到您的SQL数据仓库实例.

You can do this by setting up a data pipeline using Azure Data Factory to Azure blob storage. Afterwards you can use Azure's fast PolyBase technology to load the data from blob to your SQL Data Warehouse instance.

请问您打算将多少数据加载到DW中?Azure数据仓库旨在与至少TB级的数据一起使用，直至PB级的计算和存储.我只问是因为每个SharePoint列表或Excel文件每个文件最大2GB.

Can I ask how much data you intend on loading into the DW? Azure Data Warehouse is intended for use with at least terabyte level data up to petabyte compute and storage. I only ask because each SharePoint list or Excel file has a maximum of 2GB per file.

这篇关于如何将SharePoint列表或Excel文件移动到Azure SQL DW?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！