.svg)
Microsoft SQL Server Overview
Microsoft SQL Server is a relational database management system (RDBMS) that supports a wide variety of transaction processing, business intelligence and analytics applications in corporate IT environments. The latest version, SQL Server 2022, integrates with Azure Synapse Link and Microsoft Purview to enable customers to drive deeper insights, predictions, and governance from their data at scale. Cloud integration is enhanced with managed disaster recovery (DR) to Azure SQL Managed Instance, along with near real-time analytics, allowing database administrators to manage their data estates with greater flexibility and minimal impact to the end-user. Performance and scalability are automatically enhanced via built-in query intelligence.
Decodable + Microsoft SQL Server
Decodable can output to a Microsoft SQL Server database as a sink. To use Microsoft SQL Server as a source you'll need to use the Microsoft SQL Server CDC (Change Data Capture) connector which converts table changes into a stream of change records. Decodable is a convenient way to populate Microsoft SQL Server tables with data sourced from a range of source systems including messaging systems such as Kafka, a REST API or a CDC source. Decodable transports the data and provides a SQL-based transformation to ensure that the data arrives at Microsoft SQL Server for ingestion in an optimized form.
