Showing results for 
Search instead for 
Did you mean: 
Impactful Individual
Impactful Individual

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?
Impactful Individual
Impactful Individual

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?
Impactful Individual
Impactful Individual

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,

Not applicable

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

Bumping this for visibility 



Helpful resources

Check this Out


Class of 2020- Season 2

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!


Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (10,115)