One tool. Every report.
Set it up once, never by hand again: Datriq builds your reports on schedule, files them and sends them – from your Orange time tracking or any other database.
Select an entry to see its settings.
Centralised, flexible and automatable reporting.
No more scattered reports and manual distribution – Datriq bundles, automates and delivers.
DatriqInstead of many manual steps – one automated flow.
One solution for every requirement.
Prepare results exactly the way your report needs them – from first preview to finished layout. The virtualised table stays responsive even with large data sets.
All processing options
15 processing optionsFrom data to a finished report.
Format the same result for output — number formats, traffic-light rules, title, header & footer, layout and branding. Renders as PDF or Excel; CSV stays raw.
- Records
- 9
- Columns
- 5
- Source
- MSSQL
DatriqAll formatting options
15 formatting optionsBuild once — saved as a template.
Query, filters, calculated columns and formatting are stored together as one reusable template. Next time it's a single click — or a schedule.
Stored in the template
- Query & variables
- Filters (person, row, date)
- Sorting & column order
- Calculated columns & aggregation
- Formatting & layout
- Output format & PDF options
The entire flow in one template.
Organisable in groups & favourites
Export — now, to a folder, or by email.
Export ad-hoc with one click, or let Datriq run it on a schedule — into a folder or by email, AES-256 protected and automatically split so every manager only gets their own data.
- Format
- Destination
- Rows
- 9 · anonymised
All export & delivery options
15 optionsOne pipeline, three ways to work.
Depending on how often you need the report — Datriq covers every case with the same flow. The mode is just how far you take it.
Ad-hoc
one-offA spontaneous analysis from a SQL query or template — exported straight away.
- Process data
- Format
- Save as template
- Export
- Scheduled delivery
Template
recurringPrepare once, save as a template, re-run anytime with a single click.
- Process data
- Format
- Save as template
- Export
- Scheduled delivery
Scheduled
automaticRun the template on a schedule and email it automatically — including to managers.
- Process data
- Format
- Save as template
- Export
- Scheduled delivery
Quality-of-life touches that make daily work easier.
Beyond the extensive analysis and filtering, Datriq offers many comfort features that let you work more effectively and productively.
Full SQL editor
Schema loading for tab completion, validation, one-click formatting & protection against dangerous queries.
Groups & favourites
Custom groups with favourite queries keep things tidy – drag & drop for quick changes.
Search & filter
Filter scheduled reports e.g. by email address or show only favourites.
Encrypted im-/exports
Share or back up queries, templates, database connections & email configs – encrypted.
CSV settings
Choose your delimiter, set the encoding and enable BOM if needed.
Save settings
Define a default save location and open reports automatically after export.
Preview screenshot
Create a screenshot of the result preview with one click and share it.
Export information
See how many exports are scheduled today, how many remain and when the next one starts.
Export logs & stats
Review all exports incl. errors and filter by criteria.
Preview highlighting
Validate results in the preview via search – matches are highlighted.
Dark mode
Light or dark interface – optionally following your system setting automatically.
Query history
View recently executed SQL commands incl. duration and status, and restore them with one click.
Frequently asked questions
Still have questions? Contact us via the form, by email or by phone.
With time tracking systems by Orange Software GmbH – and, on request, third-party systems using a MySQL/MariaDB or MSSQL database.
See Datriq in action
In a short demo we show you how Datriq centralises and automates your reporting – tailored to your systems.
+49 421 98 98 30-23