Connections

Microsoft SQL Server

On-prem application databases.

Built by Eagle
Website microsoft.com/sql-server
CategoryDatabases
Profiled schema
  • Operational tables12,360 rows
  • Reference data16,480 rows
  • Foreign key relationships20,600 rows
  • Change timestamps24,720 rows
Proposed treatments
  • Operational tablesLocation0.9
  • Reference dataCustomer0.9
  • Foreign key relationshipsTime0.7
  • Change timestampsAP invoice0.7

Overview

Microsoft SQL Server reads operational tables directly from an application database or replica so shop-floor and operations data stays current.

How it works

Eagle connects to a read replica, profiles tables and foreign keys, and proposes which tables represent business objects. Incremental reads use updated-at columns where they exist.

Configure

  1. 1Point Eagle at a read replica, not the primary.
  2. 2Grant SELECT on the schemas to profile.
  3. 3Review proposed objects and the location mapping for facility identifiers.

What it brings in

Operational tablesReference dataForeign key relationshipsChange timestamps
Method · Read-only login