Connect PowerApps with AX 2012

 In this blog will show you how to create Canvas App for AX 2012.

We need to Install Microsoft Gateway on the On-Premise Gateway. Sign in to the gateway with the same AD credentials with which you will login to PowerApps.

Create a new connection in the Dataverse section of PowerApps.

• Connection type is Window Authentication since we are directly connecting to AxDB.
• SQL Server name can be found in System Information > System Name.
• SQL Database Name is the AXDB name (MicrosoftDynamicsAX in my case).
• Input UserId and Password credentials for the SQL Server.
• Select the gateway you had installed on the On-Premise AX Server.

Now you have established AX 2012 DB connection with PowerApps.