Hi @rohit_kumar, How are you dong today?

To answer to your subject line question, If you're looking for flexibility and integration, Databricks Workflows might be better since it offers native support for complex data transformations and seamless integration with Spark. However, Azure Data Factory (ADF) is ideal if you prefer a more visual and managed approach, especially for orchestrating data pipelines with multiple sources. ADF is also great for integrating with other Azure services. Ultimately, choose based on your team's familiarity and the complexity of the tasks.

Give a try and let me know if it works.

Regards,

Brahma