locked
VNET Endpoint - Data factory access RRS feed

  • Question

  • Hi,

    I'd like to ingest SQL PaaS data into data lake via Data factory.

    SQL PaaS is connected from an App Service Environment with VNET service endpoint

    Is Data factory able to access SQL PaaS when connected via a VNET service endpoint?

    Tuesday, March 19, 2019 9:06 AM

All replies

  • Hi Deason,

    Yes, this will still function by enabling the "Allow access to Azure services". Please see the following document: Allow access to Azure services

    If this functionality is disabled, you have to be more explicit with firewall rules and ip addresses to allow connectivity between Data Factory and the Azure SQL instance.

    Please let us know if you have additional questions.

    Regards,

    Mike

    Note: If this information answers your question or resolves your issues, please consider marking this as answered to help those looking for the same solution. 

    Tuesday, March 19, 2019 10:16 PM