DWH4CLICK
Your enterprise data warehouse, built step by step in a dedicated tenant, without writing queries.
A data warehouse doesn't have to start with a six-month project. It starts with a few clicks, layer by layer, from the data you already have. DWH4CLICK is the Miriade platform that builds your data warehouse in a dedicated tenant — on-premises or in the cloud, securely connected via site-to-site VPN. A guided front end walks you through creating the staging, modeling, and analysis layers, with the relationships between tables described in natural language.
Valuable data, but no single view
Many companies have valuable data spread across multiple databases but no data warehouse that connects it — and traditional projects demand months of analysis before producing the first table. DWH4CLICK is designed for organizations that want to start from the data they already have, without disrupting the business. Typical situations:
Product data sheet
| Product | DWH4CLICK |
|---|---|
| Category | Guided data warehouse platform (PaaS) |
| Delivery | Dedicated customer tenant, subscription-based |
| Deployment | On-premises or in the cloud, at the customer's choice |
| Connectivity | Site-to-site VPN to the customer's infrastructure |
| Structure | Three layers — Staging · Facts & Dimensions · Analysis |
| Modeling | Relationships described in natural language, with no SQL queries or DDL |
| Engagement models | Self-Service · Assisted · Managed |
| Application licenses | No additional licenses beyond the service |
| Data sovereignty | Full: data stays within the customer's infrastructure |
From staging to analysis, one layer at a time
Onboarding
We define the dedicated tenant, the site-to-site VPN connection, and the access required to the data sources.
Provisioning
We activate the DWH4CLICK environment, on-premises or in the cloud, dedicated to the customer.
Layer 1 · Staging
From the front end, you configure connections and select the tables to import into the first layer, mirroring the sources.
Layer 2 · Facts & Dimensions
You describe relationships in natural language and the system generates the dimensional model, which can be validated before final creation.
Layer 3 · Analysis
Analysis tables, ready for reporting and BI, are generated from the model in the previous layer.
Continuous evolution
Your team can keep all three layers up to date as sources and analysis needs change.
A guided front end, from connection to analysis
Connections and table selection
From the front end, you configure the connection to the source databases and the target data warehouse, choosing which tables to import into the first layer.
Staging import
Selected data is imported as a mirror of the sources, with no transformations: this is the first layer of the data warehouse.
Natural-language modeling
Users describe the relationships between tables in natural language; the system automatically generates the dimensional model, with facts and dimensions.
Validation and refinement
The proposed model is validated before final generation, with manual adjustments to relationships, keys, and hierarchies when needed.
Analysis tables
The third layer is generated from the facts-and-dimensions model: analysis tables ready to be consumed by reporting and BI tools.
Self-managed updates
All three layers can be updated over time as data sources or analysis needs change.
From untapped data assets to data that drives decisions
Data scattered across multiple systems
Information resides in heterogeneous databases and applications that are hard to consolidate into a single view.
Guides connection setup and structured import into the first layer.
Missing modeling skills
Building a dimensional model requires specialized skills that are often not available in-house.
Relationships are described in natural language: the system generates facts and dimensions.
DWH projects that take too long
Traditional projects require months of analysis before delivering value.
The first layer is built quickly; the model evolves layer by layer.
Historical data assets left untapped
Years of data flows and datasets remain an unused asset, because starting over seems easier.
Starts from existing data and data flows, with no need to start from scratch.
No structure for analysis
Without a dedicated model, decisions are made on manual extracts and scattered files.
Generates a third layer of analysis tables, ready for reporting and BI.
What it includes, and what it delivers
What the service includes
Service output
Metrics and expected outcomes
Success metrics
Expected outcomes
Three models, as much support as you need
DWH4CLICK does not replace internal teams: it gives them a guided front end and, when needed, hands-on support from Miriade engineers.
Your internal team uses the front end independently: management of the three layers stays with the customer.
On-demand support from Miriade for source configuration and modeling.
Ongoing management of the three layers by Miriade, with a technical point of contact for model evolution.
Not a months-long project, but a guided path
Many data warehouse projects don't fail because of a technical problem: they never get started.
DWH4CLICK turns “we should have a data warehouse” into a data warehouse that grows layer by layer — starting from data flows and datasets built over the years, with relationships described in natural language, in a dedicated tenant with full data sovereignty.
Other Miriade services
Database Managed Service (MirDB)
When the data warehouse relies on databases that need continuous DBA management of source administration and performance.
Product · Annual managed serviceMirCrypt
When the data warehouse tables include critical or sensitive data that must be protected with post-quantum encryption.
Frequently asked questions
Do we need an additional license to use DWH4CLICK?
No. It is a platform delivered as PaaS in a dedicated tenant: it requires no additional application licenses beyond the service itself.
Does our data stay within our infrastructure?
Yes. The tenant is dedicated to the customer and can be deployed on-premises or in the cloud; the connection runs over a site-to-site VPN.
Do we need to write queries to create the dimensional model?
No. Relationships between tables are described in natural language from the front end; the system generates the facts-and-dimensions model.
Can we start from the data and data flows we already have?
Yes. DWH4CLICK is designed to make the most of the data flows and datasets collected over the years, with no need to start from scratch.
What is the difference between Self-Service, Assisted, and Managed?
With Self-Service, the customer manages everything independently from the front end; Assisted adds on-demand support from Miriade; with Managed, Miriade manages all three layers on an ongoing basis.
Want a data warehouse built on the data you already have?
Tell us about your environment — data sources, on-premises or cloud, preferred engagement model: we'll schedule an initial call with a Miriade expert to qualify your sources, size the dedicated tenant, and activate DWH4CLICK.
Let's build your data warehouse on the data you already have
Tell us about your environment — data sources, on-premises or cloud deployment, connectivity requirements, and preferred engagement model: we'll schedule an initial call to qualify your sources and size the dedicated tenant.
We use the data you submit only to contact you about this request. Do not enter credentials, passwords, or sensitive data: access details and confidential technical information will be handled through agreed secure channels (site-to-site VPN).
