SSIS与Azure Data Lake Analytics [英] SSIS vs Azure Data Lake Analytics

问题描述

大家好，

只是一个专业的市场工作问题： 

您认为Azure Data Lake Analytics（除了Azure数据工厂）有一天会取代SSIS吗？ 

I我使用SSIS在转换后加载Azure中的数据，一切正常但我做的越多，我认为我需要更新我对这些工具的知识。 

解决方案

嗨  DIEGOCTN，

Azure Data Lake Analytics和  SQL Server Integration Services有不同的 优点。

Azure Data Lake Analytics ：

Azure Data Lake Analytics是一种按需分析作业服务，可简化大数据。您可以编写查询来转换数据并提取有价值的见解，而不是部署，配置和调整硬件。分析服务可以通过设置您需要多少功率的拨号来立即处理任意规模的
工作。

SQL Server Integration Services ：

Microsoft Integration Services是一个用于构建企业级数据集成和数据转换解决方案的平台。使用Integration Services通过复制或下载文件，加载数据仓库，清理
和挖掘数据以及管理SQL Server对象和数据来解决复杂的业务问题。

最好的问候，

Mona Lv

Hi guys, 

Just a professional market job question: 

Do you think that Azure Data Lake Analytics (besides Azure data Factory) is going to replace SSIS one day? 

I am using SSIS to load data in Azure after having transformed them, everything works but the more I do and the more I think that I need to update my knowledge on these tools. 

解决方案

Hi DIEGOCTN,

Azure Data Lake Analytics and SQL Server Integration Services have different  advantages.

Azure Data Lake Analytics:

Azure Data Lake Analytics is an on-demand analytics job service that simplifies big data. Instead of deploying, configuring, and tuning hardware, you write queries to transform your data and extract valuable insights. The analytics service can handle jobs of any scale instantly by setting the dial for how much power you need. 

SQL Server Integration Services:

Microsoft Integration Services is a platform for building enterprise-level data integration and data transformations solutions. Use Integration Services to solve complex business problems by copying or downloading files, loading data warehouses, cleansing and mining data, and managing SQL Server objects and data.

Best Regards,

Mona Lv

这篇关于SSIS与Azure Data Lake Analytics的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！