Hi @Anshal ,
Thanks for posting this question in Microsoft Q&A platform and for using Azure Services.
Regarding your question about different variety of data sources and data modelling, you could consider Synapse Pipelines.
Here is the list of different supported connector in synapse: connector-overview
In case your data source is not present in the Supported list, then you may consider using Custom Activity in Pipelines or Azure Functions to write your custom code to connect to the Data Source.
For On-Premise data sources, you have to create SHIR (Self Hosted Integration Runtime) as mentioned here create-self-hosted-integration-runtime
Hope this will help. Please let us know if any further queries.
------------------------------
- Please don't forget to click on or upvote button whenever the information provided helps you.
Original posters help the community find answers faster by identifying the correct answer. Here is how - Want a reminder to come back and check responses? Here is how to subscribe to a notification