Dell Boomi vs. Microsoft Azure Data Factory!

Richie Bachala
3 min readAug 19, 2019

Dell Boomi:

Dell Boomi AtomSphere is an on-demand multi-tenant cloud integration platform for connecting cloud and on-premises applications and data cloud-based integration processes. transfer data between cloud and on-premises applications. Each Atom defines what is necessary for the integration.

The atom is hosted on premise however workflow, rules and cross reference tables are updated via the cloud.

Microsoft Azure Data Factory:

Cloud-based data integration service that allows the users to create data-driven workflows in the cloud for orchestrating and automating data movement and data transformation.

Easy-to-use drag-and-drop interface, supports multiple programming languages and is highly and very easily scalable platform.

One of the biggest strengths of the Microsoft services is low cost of ownership, and integrates easily with other Azure services, with embedded security.

— — — — —

Both the products are created for providing end-to-end capabilities including application /data integration, API management, data quality governance, B2B network management, low-code workflow automation and application development. Dell acquired Boomi in 2010 and has a decade headstart over Microsoft. Dell has been chipping away the market share ever since.

Below are my notes from analyzing both products…

Connectors:

Boomi:

153 applications are supported, including... SAP, Oracle e-Business suite, Salesforce, Netsuite, Workday, Microsoft Dynamics GP.

ADF:

80+ prebuilt connectors — including Azure data services, on-premises data sources, Amazon S3 and Redshift, and Google BigQuery.

Pricing:

Microsoft ADF: Must have Microsoft Azure subscription you pay for the consumped compute, and the pricing is only for the Data pipeline jobs.

Activity, trigger, and debug runs: $1 per 1,000 runs

Self-hosted integration runtime: $1.50 per 1,000 runs

Pricing for SQL Server Integration Services integration (SSIS) runtime nodes start from: $0.840 / hour

Source: Microsoft ADF v2 detailed pricing. (as Aug 2019)

Dell Boomi: licensing cost per user starts from $549

Source: Dell Boomi pricing.

— — — — — — — — — — — — —

Gartner’s Magic Quadrant

Microsoft and Dell Boomi are both in the leaders quadrant this year, I anticipate Microsoft to be making a huge swing in the next years magic quadrant.

Source: Gartner
Source: Microsoft was not in the 2017’s Gartner MQ’s leader’s quadrant.

Although the market for integration platform as a service (iPaaS) shows strong growth, the first signs of market consolidation are starting to emerge. Gartner, Inc. predicts that by 2023, up to two-thirds of existing iPaaS vendors will merge, be acquired or exit the market.

Source: Gartner

In summary, Azure Data Factory is a relatively new service in the Microsoft Azure stack and has been gaining quite a traction with the companies that are joining Microsoft cloud platform. It has low total cost of ownership and has a familiar interface.

Dell Boomi has had a 10 year headstart in this space, the products has user experience that has potential for improvements — has had progressive growth since the acquisition, and currently has a large customer base of 8000+ enterprise customers. Customers with multiple ERP systems that have cloud offering have historically been choosing Boomi.

--

--

Richie Bachala

Distributed SQL, Data Engineering Leader @ Yugabyte | past @ Sherwin-Williams, Hitachi, Oracle