Microsoft SQL Server integration
Microsoft SQL Server data, in your warehouse.
A built-in ingestr connector: add credentials, pick tables, schedule it.
name: raw.dbo_customers
type: ingestr
parameters:
source_connection: microsoft_sql_server
source_table: 'dbo.Customers'
destination: snowflake
incremental_strategy: merge$ bruin run assets/raw/microsoft_sql_server.asset.yml
- extract · Microsoft SQL Server dbo.Customersincremental
- load · snowflake raw.dbo_Customersmerged
- checks · not_null, unique
Loaded and checked. Downstream models can run.
How it connects
Connected in three steps.
Microsoft SQL Server is an enterprise-grade relational database with comprehensive BI tools.
- 01
Add a Microsoft SQL Server connection with its credentials.
- 02
Pick the tables to load and how: replace, append or merge.
- 03
Bruin runs it on your schedule and checks every load.
Connection parameters
- username
- SQL Server login
- password
- Login password
- host
- Server name or IP
- port
- Port number (default 1433)
- database
- Database name
- encrypt
- Use encryption (true/false)
- trustServerCertificate
- Trust certificate
Tables
3 tables, ready to load.
dbo.CustomersSales.OrdersProduction.Products
Step-by-step
Pick a destination.
Microsoft SQL Server → Snowflake
Read the guide
Microsoft SQL Server → Google BigQuery
Read the guide
Microsoft SQL Server → Databricks
Read the guide
Microsoft SQL Server → Amazon Redshift
Read the guide
Microsoft SQL Server → PostgreSQL
Read the guide
Microsoft SQL Server → ClickHouse
Read the guide
Microsoft SQL Server → DuckDB
Read the guide
Microsoft SQL Server → MotherDuck
Read the guide
The platform
Part of the Bruin platform.
Data in, ready for everything downstream: the models, the checks, the lineage and the AI layer.
Sources
DatabasesWarehousesApps & APIsFiles & storageStreams & webhooksWeb scrapingMove
Data IngestionFrequently asked
Questions about Microsoft SQL Server.
Does Bruin have a built-in Microsoft SQL Server integration?
Yes. Built-in ingestr source. Built-in ingestr destination. Runs SQL and Python assets.
Which Microsoft SQL Server tables can Bruin load?
dbo.Customers, Sales.Orders, Production.Products.
Where can Microsoft SQL Server data go?
Snowflake, BigQuery, Databricks, Redshift, ClickHouse, Postgres, DuckDB, MotherDuck, Microsoft Fabric and more, plus files on S3 and GCS.
How fresh is the data?
As fresh as your schedule. Incremental loads append, merge or replace a time window, every few minutes if you like.
Do we need Bruin Cloud?
No. The Bruin CLI and ingestr run locally, in CI or in your own orchestrator. Bruin Cloud adds scheduling, lineage, alerts and the AI data analyst on top.
Ready to connect Microsoft SQL Server?
$100 in credits and 50 AI tasks. No credit card.
A demo walks through your own data.