New Destination: Azure SQL Server
Azure SQL Server is now a destination on Erathos. Centralize data with incremental ingestion and automatic alerts.
Introducing Azure SQL Server as a Destination in Erathos: Enterprise-Ready Data Warehousing on the Microsoft Platform
Today we are excited to launch Azure SQL Server as a fully supported destination in Erathos, making it easy for teams to use Azure-hosted SQL Server as a scalable and reliable data warehouse.
Many organizations already standardize their data platform on SQL Server, and now you can centralize all your data for analytics, reporting, and BI directly in an Azure SQL Server database using Erathos ingestion workflows.
What This Means
With this release, you can now:
- Move data to Azure SQL Server without custom engineering work
- Maintain a familiar T-SQL and SQL Server ecosystem for analytics
- Use Erathos' scalable pipeline orchestration to keep your data always up to date
How Ingestion to Azure SQL Server Works
Like any other relational destination in Erathos, Azure SQL Server supports the sync modes you already know from PostgreSQL and Supabase destinations:
- Append: Each run adds new records without overwriting historical data
- Upsert: Existing records are updated by primary key, and new ones are inserted
- Full Refresh: The target table is recreated from scratch on every sync, useful for small sources where reprocessing everything is simpler than tracking incremental changes
Schema evolution is also handled automatically: when the source adds a new field, Erathos adjusts the table structure in Azure SQL Server without requiring manual intervention.
Quick Setup
Connecting your Azure SQL Server destination in Erathos takes just a few steps:
- Prepare your Azure SQL database by whitelisting Erathos' IP in your database firewall
- Gather your SQL credentials (host, database name, admin username, and password)
- Configure in Erathos: Go to Settings → Data Warehouse → Azure SQL Server and fill in the connection details
- (Optional) Configure an advanced connection via SSH if you need a secure tunnel
Why This Matters
Many analytics workflows become overly complex when moving data between systems. With Azure SQL Server support:
- You keep your workloads in a reliable relational data warehouse
- BI tools like Power BI, Tableau, and Looker connect natively
- Your team doesn't have to manage multiple disconnected systems
This complements the existing set of destinations in Erathos and offers more choices to teams based on their architectural needs. Sources like GitHub and Linear, for example, already sync to the Microsoft ecosystem via Azure Synapse, and now get Azure SQL Server as an additional option for those who prefer a traditional relational database over an analytical warehouse.
Once the data is in Azure SQL Server, it is best practice to organize these tables into progressive quality layers, as proposed by the Medallion Architecture: raw data, cleaned data, and business-ready data.
Frequently Asked Questions about Azure SQL Server Destination
Is Azure SQL Server the same as Azure Synapse? No. Azure SQL Server is a managed relational database based on SQL Server, optimized for transactional and moderate-scale analytical workloads. Azure Synapse is an enterprise analytics platform optimized for large volumes and MPP (Massively Parallel Processing). Erathos supports both as separate destinations, each serving a different use case.
Do I need to allow network access for Erathos to sync with my database? Yes. You need to whitelist Erathos' IP in the Azure SQL database firewall, or configure an SSH tunnel if you prefer not to expose the database directly.
Does Azure SQL Server support incremental syncs? Yes, in both append and upsert modes. Full refresh mode is also available for cases where recreating the entire table on each sync makes more sense.
Which BI tools connect natively to Azure SQL Server as an Erathos destination? Any tool that already communicates with SQL Server, including Power BI, Tableau, and Looker, without requiring any additional configuration beyond the standard database connection.
Get Started Now
Create your Erathos account and connect your sources to Azure SQL Server in minutes. Visit the documentation for a detailed step-by-step guide.