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.
