Blog
Data engineering, in practice.
How to move data from any source to any destination — extraction, CDC, transformation and loading, told by the team that builds Januss.
All articles
20 articlesData migration: what it is, when to do it and how to keep running
Every migration looks like a volume problem until it turns into a format problem. What changes between migrating and integrating, when each approach fits and how to check the data arrived intact.
Januss or Dataddo: what each one guarantees once the data lands
Comparing integration platforms by connector count is the fastest way to choose wrong. Compare them by what each one guarantees in the destination — and by what happens when the data arrives broken.
Januss or Fivetran: what sits behind the Enterprise plan
Both read the transaction log and transform in SQL at the destination. From there they diverge on where the data runs, who writes the connector and what the bill does when volume goes over.
Excel slowing down with large data: where the limit really is
Everyone quotes the one-million-row limit in Excel. Except the spreadsheet stops being usable long before that, for a different reason. What actually weighs, what only postpones and what solves.
Mirroring, versioned history and SCD type 2: which one per table
Mirroring keeps the destination identical to the source — and erases the past with it. Understand what SCD type 2 is, what it costs and how to pick the sync mode table by table.
Five paths from an API to Power BI — and what each one costs
Getting API data into BI has five possible paths. Four of them charge you in time, sooner or later. Compare what each one solves, where it breaks and the four questions that settle the choice.