Lakeflow Connect Data ingestion from SQL Server and PostgreSQL to Databricks with CDC

shan-databricks
Databricks Partner
We have a requirement to use Lakeflow Connect for data ingestion from SQL Server and PostgreSQL into Databricks with CDC and Lakehouse federation. I would like to understand the pros and cons of Lakeflow Connect in the following areas
 
Firewall/gateway considerations
CDC capabilities
Reliability
Overall success of Lakeflow implementation
Overall success of Lakehouse federation