Skip to content

Autotask Mirror

Autotask Mirror continuously mirrors data from the Autotask PSA REST API into a SQL Server database, giving you direct SQL access to your Autotask data for reporting, analytics, and integration with tools like Power BI.

Key Features

  • Continuous sync — Automatically mirrors 200+ Autotask entity types on configurable schedules
  • Incremental updates — Tracks last-modified timestamps to sync only changed records, minimizing API usage
  • Power BI ready — Foreign key relationships are maintained in SQL Server for seamless Power BI auto-detection
  • Configurable schedules — Per-entity sync intervals from every 30 minutes to weekly
  • Web dashboard — Monitor sync status, configure settings, and trigger manual syncs from a browser
  • Secure — Supports OpenID Connect authentication with any OIDC provider (Entra ID, Okta, Google, Keycloak, ADFS)