different variety of data sources and data modeling

Anshal 1,036 Reputation points

hi friends we have multiple variety of datasources on premise and loading the data in to adls but adls is a file system and we need to have consistent data where we need to do dimensional data modeling it should be done in azure SQL database or synapse help me please

Azure SQL Database
{count} votes

1 answer

Sort by: Most helpful
  1. ShaktiSingh-MSFT 7,136 Reputation points Microsoft Employee

    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 130616-image.png or upvote 130671-image.png 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