when should we use data fusion over etl data flows
hi,
when should we use data fusion over etl data flows and what are the differences between them.
thank you
Best Answer
-
Fusion is fantastic for relatively simple joins on large datasets that number in the tens of millions of rows and greater.
The ETL and MySQL dataflows are different ways to accomplish the same end goal, allowing the user to pick the method they are most comfortable with. Some users work best in SQL, so the MySQL ETL recreates that, whereas some people prefer visual drag and drop dataflows which is Magic ETL.
All things being equal, I believe that Magic ETL is slightly more performant than MySQL ETL however.
The choice further comes down to how complicated some of your dataflows are/can be, and how they will be managed. It's easier to see what's happening from a high level with Magic, but can data transformations tricky to perform. MySQL allows for basically any data transformation to occur, but you need to go into each transform to view the logic.
0
Categories
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 38 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 259 Domo Best Practices
- 11 Domo Certification
- 464 Domo Developer
- 50 Domo Everywhere
- 105 Apps
- 714 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 26 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 653 ひらめき共有