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 articles

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.

Read article

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.

Read article

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.

Read article

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.

Read article

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.

Read article