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.
Internet has made the world seem smaller in my opinion! As a young developer i figured out more things about Dynamics AX from blogs, MSDN, Dynamics community etc. It is amazing to see people sharing their experiences related to AX with others at the cost of their time(Opportunity cost!). This blog is one such attempt.