# Centralize your data in Azure SQL Server

> Load data from 100+ sources into Azure SQL Server with Erathos. Incremental ELT pipeline with automatic UPSERT, no code. Get started for free.

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

Azure SQL is Microsoft Azure's managed relational database service, built on SQL Server. Fully managed in the cloud, it delivers high availability, automatic backups, built-in intelligence for performance tuning, and advanced security, all without the need to manage infrastructure. It is the natural choice for companies already using the Microsoft ecosystem, featuring native integration with tools like Power BI.

To connect Azure SQL Server as a destination in Erathos, simply whitelist the Erathos IP in the database firewall (via the Networking section in the Azure portal) and provide the host, database name, port, and access credentials. From there, Erathos automatically creates the tables, types the data, and keeps everything up-to-date with smart UPSERTs: new records are inserted and existing records are updated, preventing duplicate rows and eliminating the need for manual deduplication logic.

With Azure SQL Server as a destination, companies within the Microsoft ecosystem can centralize data from CRMs, ERPs, marketing platforms, and other sources into a single relational database, ready to power dashboards in Power BI or any other SQL-connected BI tool.

## Centralize your data in Azure SQL Server in minutes

### Plug-and-play connectors

Send data from over 100 sources directly to Azure SQL Server with plug-and-play connectors. Eliminate manual pipelines and consolidate CRMs, ERPs, and marketing platforms into a single analytical environment, ready to drive actionable insights.

### Greater control over pipelines

Quickly set up ingestion pipelines for Azure SQL Server: select sources, define sync schedules and frequencies at the table level, all without writing a single line of code. You maintain complete control with total flexibility.

### Cutting-edge observability

Monitor the health of your Azure SQL Server pipelines with real-time alerts via email, Slack, or Discord. Every run is logged with execution time, rows processed, and error context, allowing you to debug in minutes, not hours.

## Connect all your sources to Azure SQL Server and create a single source of truth

Erathos is a complete ELT platform that loads data into Azure SQL Server from over 100 different sources via instant integrations. With plug-and-play connectors, you can centralize all your data in a single analytical environment and build a Data Warehouse in minutes.

## Questions about Erathos and Azure SQL Server

### What data sources can I connect to Azure SQL Server with Erathos?

Erathos connects over 100 data sources directly to Azure SQL Server, including CRMs, ERPs, marketing platforms, financial data, CS tools, and much more.

### Is data ingestion into Azure SQL Server via Erathos incremental?

Yes! All ingestion pipelines for Azure SQL Server run incrementally by default, with configurable sync frequencies ranging from every 5 minutes to daily, at the table level. Only new or updated data is synced during each run, ensuring maximum efficiency and lower compute costs.

### Can I test data ingestion into Azure SQL Server for free?

Yes! You can try the Azure SQL Server integration free for 14 days. Just connect a new source and set Azure SQL Server as the destination, no credit card required.

### Does Azure SQL Server require any special configuration to receive data from Erathos?

No. Erathos automatically manages the entire connection to Azure SQL Server. You just need to provide the access credentials, and Erathos takes care of the rest: table creation, data typing, and incremental loading.

### Does Erathos support point-to-point integration using Azure SQL Server?

No. Erathos does not perform direct system-to-system integrations (“pin-to-pin”) using Azure SQL Server as an intermediary. Our focus is to centralize data in Azure SQL Server as the analytical destination, creating a single source of truth for data-driven decision-making.