Build data solutions#
Querona turns scattered, heterogeneous sources into one governed, SQL Server–compatible model — with nothing copied unless you choose to materialize it. Building a solution is a workflow that shapes data progressively from raw sources into a published, business-ready model. A typical solution moves through the stages below; each builds on the previous, and you can stop wherever your needs are met.
For a hands-on first pass, follow the Quickstart; for the ideas behind each stage, see the Concepts; for worked end-to-end examples, see the Tutorials below.
1. Connect your sources#
Establish access to each source — a database, file, API or SaaS application — through a data source connection. Nothing is copied: Querona reads source metadata, and later data, on demand.
Connections — create and manage source connections.
Data sources — supported sources and their specifics.
How-to guides — connectivity how-tos.
2. Model virtual databases, tables and views#
Create a virtual database over a connection and expose source objects as virtual tables — metadata-only relational tables, with no data copied.
Databases overview — create and manage virtual databases.
Primary and Foreign Keys, Indexes — add keys and indexes for the model to use.
Virtual tables and views — the building blocks explained.
3. Integrate and conform#
Combine, clean and reshape data from one or more sources into a canonical, business-friendly model with views — independent of how any individual source stores it.
Managing views — build the integrating and canonical views.
4. Accelerate where it pays off#
When a view is queried often or is expensive to compute, materialize it into a processing engine for warehouse-class speed — selectively, only where it helps.
Materialization — materialize views, with full, incremental and on-demand refresh.
Query Retargeting — transparently redirect queries to a pre-aggregated target.
5. Serve and query#
Publish the model through one SQL Server–compatible surface for consumers to read, or query it yourself in the portal.
Client Connectivity — connect Power BI, Tableau, Excel, SSMS and other SQL clients.
Open data endpoints — expose objects over REST, GraphQL and MCP.
Query editor, Search — query and find data in the portal.
6. Operate and maintain#
Keep the solution healthy — refresh statistics and materialized views, and manage many objects at once.
Management Tasks — maintenance tasks (statistics, materialized-view refresh).
Bulk operations — bulk object operations.
7. Secure and govern#
Apply access control, data protection and auditing centrally, enforced consistently across every consumer.
Access rights — users, roles and permissions.
Data masking — dynamic data masking and pseudonymization.
Governance — discovery, lineage, access control, masking and auditing.