Explore All Highlights: Data Hero Summit 2025

Explore All Highlights: Data Hero Summit 2025

Microsoft SQL Server Connector

Overview.

The Microsoft SQL Server Connector enables seamless integration with Microsoft SQL Server (on-premises, Azure SQL Database, and Managed Instance). It provides reliable, high-performance JDBC access for querying, updating, and synchronizing relational data, including support for stored procedures and transactions.

Key Features.

  • JDBC Access – Execute SQL queries, join tables, and call stored procedures.
  • Full CRUD + Bulk – Insert, update, delete, and bulk-load data for high-throughput pipelines.
  • Enterprise Security – Supports TLS/SSL encryption, Windows Integrated Security (Kerberos), SQL Authentication, and Azure AD.
  • Advanced Capabilities – Transactions, batching, streaming, temp tables, and query pushdown for optimal performance.
  • Broad Compatibility – Works with on-prem SQL Server, Azure SQL Database, and Azure SQL Managed Instance.

Use Cases.

  • Operational Integration – Sync app data with SQL Server for finance, ERP, or CRM processes.
  • Analytics and Reporting – Feed BI tools and data warehouses with curated SQL Server datasets.
  • Data Migration – Bulk-move data to/from SQL Server for modernization or consolidation projects.

Get Started.

Setting up the Microsoft SQL Server Connector is easy. Talk to one of our experts to help you get started quickly.

Data Hero Summit X | 12 March 2026 | Rotterdam