# SQL Server + Amazon S3

> Store data as Parquet in S3 Iceberg with Erathos. Sync SQL Server data with Erathos — an incremental, no-code pipeline with observability.

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

SQL Server is a relational database management system developed by Microsoft, used to store and manage large volumes of data.

With Erathos, you can integrate data from SQL Server into Amazon S3 in just a few minutes. Our platform handles the entire data movement process into your data lake and makes it possible to combine that data with other sources. That way, your time goes toward what truly creates value — extracting insights and making data-driven decisions.

### Which SQL Server data does Erathos sync to Amazon S3?

The integration automatically syncs the main SQL Server objects:

- **Tables and collections** — structure, records, and metadata
- **Records and documents** — raw data with creation and update timestamps
- **Indexes** — settings and performance metrics
- **Schemas** — data type definitions and relationships
- **Audit logs** — write, update, and delete operations
- **Connections** — user and session metadata

### Why sync SQL Server with Amazon S3?

In Amazon S3 with Iceberg, your data is stored as Parquet files with support for time travel and schema evolution — ready to be queried with Athena, Spark, Trino, or any query engine in your stack. Ideal for low-cost archiving and ML feature stores.

### How it works

Erathos connects to SQL Server through the official API and syncs your data incrementally — only new or updated records are processed on each run. You choose the sync frequency (from every 5 minutes to daily), the objects to sync, and the destination in Amazon S3. The sync uses automatic partitioning and Parquet file optimization. You choose the sync frequency, the objects to sync, and the destination bucket. Each run is logged with full observability: execution time, processed rows, errors with context, and alerts via Slack or email.

## SQL Server data in Amazon S3 in minutes

### Ready-to-use SQL Server connector

Connect SQL Server to Amazon S3 and automatically export data. Centralize database information for analysis — without spreadsheets or scripts.

### Full control over your SQL Server pipelines

Configure the schedule, frequency, and sync type at the table level. Configure partitioning, file format, and write frequency at the table level. The Iceberg format ensures ACID compliance and schema evolution — without full bucket rewrites.

### End-to-end observability

Stop finding out about SQL Server failures only when the business team complains. Every run is logged with runtime, rows processed, and error context. Automatic alerts via Slack, Discord, or email the moment anything goes off track — so your data stays fresh for your analytics.

## Centralizing SQL Server data in Amazon S3 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 Amazon S3 — always up-to-date data, full visibility 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 common in traditional market tools.

### Which SQL Server data does Erathos sync to Amazon S3?

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 Amazon S3?

You can set the sync frequency from every 5 minutes to daily, at the table level. Erathos uses incremental sync — only new or updated records are processed in each run, keeping the SQL Server pipeline efficient and Amazon S3 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 Amazon S3 and start syncing right away — no credit card required.