Showing results for 
Search instead for 
Did you mean: 
Level 8

Questions about On-Premises Data Gateway for a On-Premise Dynamics 8 IFD

Please so kind as to read my full post before responding.
Thank you for your consideration.

We have been tasked with checking if it's possible to design a Canvas App for storage managment in a company that has a Dynamics 8, On-Premise, IFD Installation.
I know nothing about On-Premise installations.
I only found the On-Premises Data Gateway via google and know nothing about except for the following linked documentation which does not seem to contain all the information I am seeking.
I am aware of these documentation:
and this download site 

I am currently writing from a stage where our admin installed the gateway and share it with me.
I haven't yet used it in a canvas app yet and am still collecting my thoughts and questions.

My questions:

  1. Is there some sort of full documentation of that On-Premises Data Gateway?
    The documentation I found via google seems to be incomplete and consist either of just a few pages of entries.
    None of that looked like it was supposed to be a reference.
  2. After the installation with GatewayInstall.exe the sign in didn't work initially
    We got it to work after our Sysadmin turned on Javascript for the Internet explorer.
    He doesn't want to keep Javascript turned on for Internet explorer on the Windows server.
    Can we turn it off again or does the On-Premises Data Gateway still need Javascript?
    Do we need to login to the Windows Server and use Sign-In (this appears to be the only part needing Internet Explorer Javascript) in the Data Gateway again at some point in the future?
  3. The data gateway only cares about the underlying SQL Datasource, i.e. the Dynamics version doesn't matter as long as the Microsoft SQL Server is the same, right?
    At least the Docs that I found seem to mention Dynamics almost nowhere, in particular now among the Data Source content.
  4. Do I have to do something special because of the IFD/ADFS deployment?
    I couldn't find anything tangible on that.
  5. Does the current iteration of the On-Premises Data Gateway

    only allow Read access, as suggested in this older blog entry
    This other post however seems to suggest that creation, update, delete are also possible (if (?) those sql actions can be done from connecting those SQL tables in PowerApps via the SQL connector and the On-Premises Data Gateway as well)
  6. The description of how the On-premises data gateway works suggests that there will be traffic using the Azure Service Bus.
    Do I need a Azure Service Bus Namespace/subscription to connect PowerApps Canvas App to the On-Premise Dynamics installation?
Level 8

Re: Questions about On-Premises Data Gateway for a On-Premise Dynamics 8 IFD

  7. Am I interpreting this configuration page for a SQL connection via the On-Premises Data Gateway correct in saying the following:
    Each connection using the SQL Server connector is bound to one fixed username.
    Using those connections it is not possible to have multiple users use one single PowerApp (with one SQL Server connection) but different login credentials on the On-Premise SQL server.
  8. Is there another connector which allows different On-Premise-user-credentials for different PowerApps-Users?
Level 8

Re: Questions about On-Premises Data Gateway for a On-Premise Dynamics 8 IFD


Has anyone read this?
Anyone who know something or can point me to the right direction?
Tagging some moderators just to possibly get a response:

Thank you,


Re: Questions about On-Premises Data Gateway for a On-Premise Dynamics 8 IFD

Bumping this for visibility 



Helpful resources


Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.


Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020


Power Platform World Tour

Coming to a city near you


PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

Top Kudoed Authors
Users Online
Currently online: 326 members 1,708 guests
Please welcome our newest community members: