cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SaWu
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:
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
3 REPLIES 3
Highlighted
SaWu
Level 8

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?
SaWu
Level 8

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.

Administrator
Administrator

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

Bumping this for visibility 

 

@TopShelf-MSFT 

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 330 members 5,706 guests
Please welcome our newest community members: