# SQL Server + Supabase

> Integrate tables and objects from SQL Server into Supabase with Erathos. An incremental, no-code pipeline with full observability. Start for free.

Source: https://www.erathos.com/en/pipelines/sql-server-supabase
Em português: https://www.erathos.com/pipelines/sql-server-supabase

SQL Server is a relational database management system developed by Microsoft, used to store and manage large volumes of data. Amazon Redshift, on the other hand, is a cloud data warehouse designed for fast and efficient analysis of massive datasets

With Erathos, SQL Server data lands in Supabase ready to power applications via REST, GraphQL, or Realtime Subscriptions, without your team needing to build the sync layer from scratch.

### What SQL Server data does Erathos sync with Redshift?

The integration automatically syncs key SQL Server objects:

- **Selected tables** incremental replication of any configured table
- **Schema drift** new columns automatically detected and added to the destination
- **Primary keys and timestamps** used for efficient incremental syncs
- **Historical data** full initial load followed by incremental updates

### Why sync SQL Server with Supabase?

In Supabase, SQL Server data becomes available via REST, GraphQL, and Realtime Subscriptions, ready to power applications built by teams that are not data engineering specialists.

### How it works

Erathos connects to SQL Server via the official API and syncs your data incrementally: only new or updated records are processed in each run, keeping pipelines fast and Supabase costs predictable. You choose the sync frequency (from 5 minutes to daily), the objects to sync, and the destination dataset. Every run is logged with full observability: runtime, processed rows, contextual errors, and instant alerts via Slack or email if anything goes wrong.

## Get SQL Server data into Supabase in minutes

### Ready-to-use SQL Server connector

Connect SQL Server to Supabase and automatically export data. Centralize your database data for analysis — no spreadsheets and no scripts.

### Full control over your SQL Server pipelines

Configure scheduling, frequency, and sync type at the table level. Configure sync frequency and type on a per-table basis. Erathos uses smart UPSERT in Supabase — data is available via REST, GraphQL, and Realtime Subscriptions as soon as it lands in the database.

### End-to-end observability

Stop finding out about SQL Server failures only when the business team starts complaining. Every run is logged with execution time, processed rows, and error context. Automatic alerts via Slack, Discord, or email the moment anything deviates from expected behavior — so your analytics always stay fresh.

## Centralizing data from SQL Server into Supabase has never been easier

Erathos is a data ingestion platform built for data and engineering teams. With the SQL Server connector, you can automatically centralize SQL Server tables and objects in Supabase — always up-to-date data, full observability into every run, and zero maintenance.

## FAQ

### What is Erathos, and how can it help my business?

Erathos is a data ingestion platform built for reliability, transparency, and control. We help data teams connect tools like SQL Server to their data warehouse — with full observability into every run, zero maintenance, and none of the black-box behavior you get from traditional market tools.

### Which SQL Server data does Erathos sync to Supabase?

Erathos performs incremental or full replication from SQL Server to your destination Data Warehouse, including tables, schemas, and relationships. Sync frequency and schedule are configurable, with no code required.

### How often does Erathos sync data from SQL Server to Supabase?

You can configure sync frequency from every 5 minutes up to daily, at the table level. Erathos uses incremental sync — only new or updated records are processed on each run, keeping the SQL Server pipeline efficient and Supabase costs predictable.

### What happens if a SQL Server synchronization fails?

Erathos automatically detects failures and sends alerts to your email, Slack, or Discord with full context — not just “job failed.” Smart retries handle transient errors, and every run is logged with runtime, rows processed, and error context so your team can debug in minutes, not hours.

### Is there a free trial period for the SQL Server connector?

Yes. Every Erathos connector includes a 14-day free trial. Connect SQL Server to Supabase and start syncing right away — no credit card required.