Glossary
What are data access templates?
A data access template is a predefined, tested data operation that packages business logic, table relationships, field selections, and access rules into a reusable unit. Instead of each consumer writing or generating queries from scratch, templates provide a governed recipe: use these tables, apply these joins, enforce these filters, respect these access rules.
Think of it as the difference between asking someone to cook from memory every time and handing them a tested recipe. The template is created once by someone with domain expertise and reused by everyone else, whether a business user, a connected system, or an AI agent.
Why enterprises use data access templates
Without templates, every data consumer reinvents access. A business user asks IT for a report. An AI assistant generates SQL on the fly. A connected system builds custom API calls. Each approach guesses independently at tables, joins, and business definitions. The result: conflicting numbers, security gaps, and no audit trail.
Templates solve this by capturing institutional knowledge once. The person who understands "active customer" (last purchase within 90 days, excluding test accounts, counting parent entities only) writes that logic into a template. Everyone else reuses it. Same definition, same result, every time.
This is especially critical when AI enters the picture. A text-to-SQL approach generates a new query for each request, with no guarantee it applies the right business rules. Templates remove the guesswork entirely by providing deterministic execution: same template, same parameters, same answer.
How data access templates work
Three steps from definition to consistent results.
Template creation
A domain expert defines the data operation: which tables, how they join, which fields to return, what filters and business rules apply, and who has permission to use it.
Parameter binding
A consumer selects a template and supplies the variable inputs: a date range, a region, a customer segment. The template logic stays fixed. Only the parameters change.
Deterministic execution
The platform runs the predefined logic with the supplied parameters. Same template plus same parameters always equals same result. Every execution is logged for auditing.
How dhino implements data access templates
dhino uses data access templates as the core mechanism across all four products. Each product applies templates to a different consumer type, but the governing principle is the same: define once, enforce everywhere.
Fetch
Business users get self-service access to templates for segmentation, reporting, and data extraction without writing queries.
dhino Trust
AI tools like Microsoft Copilot connect to templates for deterministic answers instead of generating queries from scratch.
Integrate
System-to-system data flows run through templates with full governance and audit trails.
Publish
External audiences access template-backed data through governed API endpoints.
See data access templates in action
Learn how dhino uses templates to give every data consumer governed, consistent access to enterprise data.