Alteryx是ETL工具吗？它与SSIS有何不同？ [英] Is Alteryx an ETL tool? How it differs from SSIS?

问题描述

我的客户希望我使用Alteryx来实现ETL流程，因为他们已经获得了许可证。我对Alteryx是否是ETL工具感到困惑。我相信Alteryx通常用于为Tableau数据可视化工具准备数据。

请告知其是否为ETL工具？

感谢

解决方案

Alteryx是数据准备/高级分析应用程序。由于它可以进行数据准备，空间分析和预测，因此人们以多种不同的方式使用它。

我与许多选择纯粹将Alteryx用于其ETL的客户一起工作将数据从一个数据库移动到另一个数据库的功能，例如我曾与一位使用Alteryx从MySQL自动将其负载自动加载到其Amazon Redshift数据库的客户端一起工作，另一位正在使用SQL-> Tableau数据引擎的客户端，以及许多其他涉及一系列数据输入的示例（Alteryx支持自定义API的所有功能） -> Excel）。

如果您已经在使用SSIS，那么您会发现Alteryx有了新鲜的呼吸，说实话，我在过去的生活，因此发现Alteryx的开发速度要快得多。它更容忍数据更改，并允许更紧密地集成许多不同的数据源。新的数据库内工具使SQL与SQL的集成更加紧密，从而可以在数据库内部完成工作。

最后，与SSIS相比，我认为您会发现Alteryx非常简单易学。他们网站上的在线培训视频将为您提供所需的介绍。

享受吧，我想您会喜欢的。

克里斯

My client want me to implement ETL process using Alteryx as they have a license of it. I am confused whether the Alteryx is an ETL tool or not. I believe that Alteryx is commonly used to prepare data for Tableau data visualization tool.

Please advise whether its an ETL tool or not? How it differs from SSIS?

Thanks,

解决方案

Alteryx is a data preparation / advanced anaytics application. People use it in many different ways due to the fact it allows data preparation, spatial analytics and predictive.

I work with many clients who choose to use Alteryx purely for its ETL capabilities moving data from one database to another, e.g. I have worked with one client who has used Alteryx to automate their loads into their Amazon Redshift database from MySQL, another who is using SQL -> Tableau data engine, and many other examples involving a range of data inputs (Alteryx supports everything from custom APIs -> Excel).

If you're already working with SSIS then you'll find Alteryx a breathe of fresh air to be honest, I was working with SSIS in a past life and have since found Alteryx to be much faster to develop with. It is more forgiving to changes to data and allows tighter integration of many different data sources. The new in-database tools give a much tighter integration with SQL as was previously possible allowing the work to be done inside the database.

Finally, compared to SSIS, I think you'll find Alteryx very simple to learn. The online training videos on their site will give you as much introduction as you need.

Enjoy, I think you'll enjoy the experience.

Chris

这篇关于Alteryx是ETL工具吗？它与SSIS有何不同？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！