Guides

Step-by-step answers to the jobs people automate with DRE. For every option and key, see the documentation.

Move SAS reporting workflows to DRE

Keep Oracle or SQL Server, inspect checked Excel workbooks, watch a real run and download the synthetic overdue-loan example. SAS reference unexecuted.

How to automate SQL reports to Excel

From a query to a formatted workbook emailed on schedule: the Python script way, the DRE way, and when to keep the script.

How to schedule SQL reports

Named schedules in YAML, a preview of every firing, and reruns that keep their period, with cron, Airflow, Dagster or Databricks Jobs.

From dbt models to Excel reports

Read the tables dbt builds as sources and deliver them as formatted workbooks, with the dbt habits you already have.

Moving from SSRS or Crystal Reports

Port paginated reports to SQL, YAML and PDF templates, and prove each one matches with a parity check.