Use cases
Why teams choose Yres
Unreliable dashboards
Reports lag behind or are incorrect, and a lot of time goes into checking and correcting. Yres ensures data is loaded automatically and stays consistent.
Features
Everything you need. Nothing in the way.
Yres automates your Azure data warehouse from source to dashboard. These are the capabilities that make it possible.
Connect
Connect any source — from ERP to open data
Yres supports dozens of sources out-of-the-box. From standard ERP connectors to open data and custom APIs — your data warehouse is as broad as your organization needs.
- Exact Online, AFAS, SAP (official partners)
- SQL Server, PostgreSQL, MySQL, Oracle, DB2, Snowflake
- REST APIs, OData, Microsoft Graph
- SharePoint, Teams, Dynamics 365, Salesforce
- Azure Blob Storage & Data Lake
- Preset Dutch sources: CBS, Tweede Kamer
- Smart JSON Interpreter for complex API responses
Load
Load data the way you need it — with rollback as a safety net
Seven load types give you full control over how data ends up in your warehouse. And if something goes wrong, you simply roll it back.
- 7 load types for every scenario
- Per-load rollback — recover without stress
- Delta + overlap loading for incremental updates
- Slowly Changing Dimensions (SCD)
- Row hash & key hash for change detection
- Surrogate key generation
- Schema drift detection
- Dual storage (staging + warehouse)
Orchestrate
Design pipelines visually — Yres builds them in ADF
Draw your workflows in a visual designer. Yres automatically translates them to Azure Data Factory pipelines — including scheduling, conditions and scaling.
- Visual workflow designer → Azure Data Factory
- 7 action types for flexible orchestration
- Conditional chaining between steps
- Wait action with timezone support
- Dynamic scaling of Azure resources
- Power BI auto-refresh after data load
- View persistence for stable reports
- Custom JSON definitions for advanced scenarios
- Scheduling & triggers
Monitor & Manage
Always know how your platform is doing
Automated health checks, alerting and an operational dashboard give you real-time insight into the health of your data platform.
- Automated health checks
- Load logging with full audit trail
- Row count validation
- Error alerting
- Performance monitoring
- Data freshness tracking
- Azure cost monitoring
- Operational dashboard
Lineage & Impact Analysis
See the impact of a change — before you make it
Visual lineage shows how data flows through your warehouse. Impact analysis reveals downstream dependencies so you can make changes safely. Lineage works at object level (tables, views, procedures) — not at column level.
- Visual lineage at object level
- Impact analysis on tables, views, procedures, functions and materialized views
- Downstream dependency tracking
Security, CI/CD & Compliance
Enterprise-grade security in your own Azure tenant
Your data stays in your Azure environment. Yres runs as an application, not as a data processor. With ISO 27001, SSO and full CI/CD integration.
- ISO 27001 certified
- Data stays in the customer's Azure tenant
- SSO via Azure AD (Entra ID)
- Role-Based Access Control (RBAC)
- CI/CD via Azure DevOps
- DTAP support
- Support for existing databases
- Automatic documentation
- Naming conventions
- Multi-tenant architecture
Ready to get your data setup under control?
Book a short session and we'll show you how Yres structures and automates your data platform.
Why organizations choose Yres
“It not only speeds up our IT process, but also ensures data is available faster for reporting and invoicing towards clients.”
“Yres is truly worth its weight in gold. It reduces complexity towards Power BI reporting and makes data a lot more accessible.”
“Plainwater has truly become a partner we can fall back on for knowledge and support.”
The Azure data platform for a reliable and scalable data environment
Built for organizations already using Azure and Power BI. Yres helps teams connect, structure and manage their data without manual work or hidden complexity.