Hi community,

We’re currently planning a migration from an on-premise SQL Server data warehouse (with associated SSIS packages) to Databricks Unity Catalog. As part of this effort, we’re evaluating the use of Lakebridge for assessment, conversion, and validation.

I have a few questions regarding connectivity and integration:

1. JDBC Connectivity:

   • Does Lakebridge support connecting to on-prem SQL Server via JDBC for data and metadata extraction?

   • If so, are there any network requirements or best practices to enable this?

2. Unity Catalog Integration:

   • Can Lakebridge directly migrate or register extracted objects (e.g., tables, views) into Unity Catalog, or is this a post-migration step handled via UCX or manual registration?

Any guidance, examples, or documentation references would be greatly appreciated.

Thanks!