Mirroring from a SQL Server on-premise

Hi pmscorca 

Thanks for reaching out community.

- is it necessary to enable the Change Data Capture feature for SQL Server?

Yes, you need to turn on the Change Data Capture  in SQL server. CDC takes initial snapshot of selected tables and then keeps updating Fabric with any changes. Alos, you need compulsary to install On-premises data gateway to connect with your SQL server. Read more deatils here Microsoft Fabric Mirrored Databases From SQL Server - Microsoft Fabric | Microsoft Learn 

- as a destination Fabric workload, is the mirrored database on OneLake enough or do I need to create a lakehouse/warehouse?

Since you are already mirriong the SQL server, the mirrored data automatically stored in Onelake of fabric.So when you use mirrioring in fabric, it automatically creates the follwing things in workspace.

• Mirriored database - this stores replcia of data in OneLake
• It automatically creats a read only SQL analytics end point for quering the data.

So, already you mirriored the  SQL server, it is different from Lakehouse, it's not required to create a seperate lakehouse/warehouse until and unless if you have any additional strcted changes to your data. Read more details here Mirroring for SQL Server in Microsoft Fabric (Preview) | Microsoft Fabric Blog | Microsoft Fabric

Thank you!

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!