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
23 articlesExcel 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.
How to enable CDC on PostgreSQL, MySQL, SQL Server and Oracle
Before anything can read the transaction log, each database needs its own preparation. The exact commands for PostgreSQL, MySQL, SQL Server and Oracle, self-hosted and on Amazon RDS.
Januss or Kondado: which one fits your case
Kondado and Januss both bill in reais, speak Portuguese and integrate data. From there they diverge — on sources, on billing and on what they do with history. An honest comparison, with no thumb on the scale.