Exact Online to Azure: pagination, API limits and history
Loading Exact Online stalls on pages, limits per minute and per day and access that expires after 10 minutes. Here is how Yres handles that per table.
Loading Exact Online stalls on pages, limits per minute and per day and access that expires after 10 minutes. Here is how Yres handles that per table.
AFAS data in Power BI, but no history? An AFAS connection takes an hour. A data warehouse then handles fields, tables, history and loading only changes.
The wrong load mode loses history or misses deletions. Here is how to choose per source from the seven Yres load modes, including the most common mistake.
With schema drift a source changes its columns while loading carries on. Yres spots the difference per table, but a rename always becomes two columns.
Metadata-driven Copy Data copies hundreds of tables without a pipeline per table, but copying is only half of a data warehouse.
SCD2 for one table is a day's work in Azure Data Factory. For 340 tables it becomes a maintenance burden nobody can oversee any more.
Need to undo a bad load without leaving a gap in your data? Here is how to roll back one table, including the watermark for the next load.
Data warehouse automation generates the pipelines, tables and history of a data warehouse from metadata instead of hand-written code. What it does, when it pays off and which kinds of tools exist.
Azure Data Factory executes; it does not decide what to load or how history is kept. What you build on top of it yourself, what Yres generates instead, and when you are better off keeping ADF by hand.
Yres on Azure SQL and Parquet next to Fabric, Databricks and Snowflake: cheaper or comparable in cost and far less to build and manage yourself.
Analysts work with AI assistants that produce in minutes what used to take weeks. That is a gain, as long as the figures underneath stand firm. How Yres provides the stable data foundation on which your AI and your people build freely.
Microsoft Fabric is a platform, Yres a data warehouse automation tool. What Fabric brings by itself, what you still build, how Yres connects to it today, and what is planned for the end of 2027.
The data warehouse automation platform IRIS has been called Yres since version 1.56. What changed, what stayed the same, and why you still come across IRIS inside your own database.
Why standard reports from sector vendors rarely match your own KPIs, what a housing association actually has to load, and why history weighs more heavily here than elsewhere. With the experience of Woonstichting 'thuis.
How to keep your reporting running during an SAP migration, what a manufacturer has to get out of SAP without third-party middleware, and why the integration layer must sit apart from the ERP. With the experience of Aviko.