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)

  • :material-rocket-launch: Getting Started

    New to Autotask Mirror? Start here.

  • :material-cog: Configuration

    Connect to Autotask and configure sync settings.

  • :material-shield-lock: Authentication

    Secure your instance with OpenID Connect.

  • :material-monitor-dashboard: Dashboard Guide

    Learn how to use the monitoring dashboard.