Domo comparison with ETL Tools
Does Domo has all capabilities which modern ETL tools like Azure Data Factory, Apache Airflow, Informatica etc.
Answers
-
Domo has a wide variety of capabilities. No two ETL tool has feature parity so I'd be interested in knowing if there are specific capabilities you're interested in learning if Domo is capable of?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
As of now I can think of below three
- Handling large amount of data coming from source systems ( ~ GBs)
- Flexible to perform any transformations using SQL
- Single ETL Pipeline which takes data ranging from 0-5 years as input and gives output to store data in multiple target tables conditionally based on different time intervals e.g. target table T1 for storing 0-6 months data , target table T2 for storing 6 months -1 year data and similarly target table T3 for storing more than 1 year data
0 -
Domo can do all three of those things.
Regarding #2 Domo does have a MySQL type dataflow where you can utilize SQL queries to transform your data however there is also their drag and drop Magic ETL tool which does allow for some SQL like syntax as well in a formula tile and would be more performant than a MySQL dataflow.
#3 Domo allows for a pipeline to have multiple dataset outputs and recently has enabled partitioning on datasets as well so you can either have 3 physical datasets like you're describing or a single dataset with partitions
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
Please share video or document tutorial so that I can try to implement below related with #3 in Domo by following the steps mentioned in that tutorial
a) Pipeline with multiple dataset outputs
b) 3 physical datasets using partitions
0 -
Partitioning in Magic ETL:
Magic ETL documentation:
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
Can Domo perform near real time data processing with latency of (~ 6 minutes)?
0 -
Domo has a feature called Federated data which will utilize your warehouse and query directly against it so you have realtime querying of data.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
It does not support ETL it seems as per below
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 294 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 607 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 707 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive