Skip to main content

Notifications

Community site session details

Community site session details

Session Id : TqIgf7OUQrDHjesVyHrekr
Power Apps - Building Power Apps
Unanswered

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

Like (0) ShareShare
ReportReport
Posted on 17 May 2019 13:16:41 by 635

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:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/gateway-reference
https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem
https://docs.microsoft.com/en-us/azure/analysis-services/analysis-services-gateway
and this download site
https://powerapps.microsoft.com/en-us/downloads/ 

I am currently writing from a stage where our admin installed the gateway and share it with me.
image.png
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 docs.microsoft.com/forum/blog 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
    image.png
    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
    https://powerapps.microsoft.com/en-us/blog/on-premises-data-gateway-may-2019-update-is-now-available/

    only allow Read access, as suggested in this older blog entry
    https://www.kingswaysoft.com/blog/2018/11/22/Leveraging-PowerApps-with-Microsoft-Dynamics-On-Premise
    image.png
    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)
    http://dynamics365.ie/flow-synch-d365-onprem-database/
    image.png
  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?
    image.pngimage.png
  • Community Power Platform Member Profile Picture
    on 06 Jun 2019 at 13:57:57
    Re: Questions about On-Premises Data Gateway for a On-Premise Dynamics 8 IFD

    Bumping this for visibility 

     

    @Anonymous 

  • SaWu Profile Picture
    635 on 28 May 2019 at 11:41:10
    Re: Questions about On-Premises Data Gateway for a On-Premise Dynamics 8 IFD

    Hello.

    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:
    @v-xida-msft@v-yuxima-msft@v-monli-msft


    Thank you,
        Sa.

  • SaWu Profile Picture
    635 on 17 May 2019 at 14:08:18
    Re: Questions about On-Premises Data Gateway for a On-Premise Dynamics 8 IFD
    1.  
    2.  
    3.  
    4.  
    5.  
    6.  
    7. Am I interpreting this configuration page for a SQL connection via the On-Premises Data Gateway correct in saying the following:
      image.png
      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?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Building Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 98 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 60

#3
stampcoin Profile Picture

stampcoin 48

Overall leaderboard
Loading started