Logic App Service with ISE(Integrated Service Environment) connecting to onprmeise SqlDatabase with out OnPremiseDatagateway

Amar-Azure-Practice 646 Reputation points
2020-08-29T18:16:26.673+00:00

Hi All,

I am using Logic Apps with ISE,With out OnPremiseDatagateway I want to connect on premise SqlServer .
Is this possible with the ISE.

Thanks,
-Amar

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
1,820 questions
No comments
{count} votes

Accepted answer
  1. MayankBargali-MSFT 49,711 Reputation points Microsoft Employee
    2020-08-31T04:01:35.78+00:00

    Hi @Amar-Azure-Practice

    If an ISE connector is available then you can access to system/ data source without OPDG when you are using ISE. You can find the list of supported ISE connecter here.

    As mentioned in the supported ISE connector if you need to access SQL Server from an ISE and use Windows authentication, you must use the connector's non-ISE version and the on-premises data gateway. The connector's ISE version doesn't support Windows authentication.

    For other Azure AD Authentication and SQL Server Authenticate, you can read the prerequisites and follow this article for configuration.

    ---------------

    Please 'Accept as answer' and ‘Upvote’ if it helped so that it can help others in the community looking for help on similar topics.


0 additional answers

Sort by: Most helpful