Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-22-2026 06:35 AM
Yes, it is possible to integrate SSIS packages with Delta tables using JDBC/ODBC connectivity.
Required on Databricks side:
- SQL Warehouse or interactive cluster
- JDBC/ODBC driver
- Hostname, HTTP Path, Port 443, and PAT token
- Proper table permissions in Unity Catalog
Recommended approach:
SSIS → JDBC/ODBC → Databricks SQL Warehouse → Delta Tables
For better performance, use batch/bulk loads instead of row-by-row inserts.
In modern architectures, many teams use SSIS for orchestration and move heavy transformations to Databricks notebooks, Lakeflow, or ADF.