Forum Discussion
Copy activity from Oracle to Lakehouse fails without staging
Hi vietng Even if you're choosing a Lakehouse it may still be using the SQL Endpoint behind the scenes, since I'm guessing you're writing in the /Tables area. Trying opening the 1433 port and see if it works.
Hi vietng,
One small correction, if you're targeting a lakehouse, it wouldn't be using the SQL endpoint to write data as the sql endpoint is read only, but deborshi_nag is correct that it might still be using the SQL ports to do the data movement.
I always recommend opening all the ports found on this page when doing gateway maintenance:
Adjust communication settings for the on-premises data gateway | Microsoft Learn
Community SupportHi @vietng,
We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.
Thank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are
MS Fabric community support