Dynamics GP
Dynamics GP Data Gateway
Popdock

Setting up the Dynamics GP Data Gateway for Popdock

August 25, 2021

Pre-requisites

  • Internet Information Services (IIS) installed on a Microsoft Windows computer (How to install IIS)
  • Install the .NET Core Hosting Bundle (6) (download)
Important Tip

It is very important that IIS is installed initially before the .NET Core Hosting Bundle. In some cases IIS will also need to be restarted after the bundle is installed.

Installation and Setup Steps

    1) Download the Dynamics GP Gateway

    2)Install the Gateway following the steps below:

A) Select the Next button to begin

Dynamics GP Gateway Welcome Setup


B) Pick the desired folder where the files will be installed. It will default into the Program Files (x86) directory.



C) Provide the credentials to connect to the SQL Server that hosts your Dynamics GP data.

  • Server: The local address to the SQL Server and add instance, port if necessary (ex. Demo1\SQL,49721)
  • System Database: The name of the Dynamics GP System database (usually DYNAMICS)
  • Username: The desired SQL Server user. Doesn't need to be sa but must have access to read SYS tables to access the metadata
  • Password: The password for the SQL Server user above



D) Choose the Authentication type that Popdock will use to connect with the Gateway. Our recommendation is Token but we will cover both methods.

Token


Create a Token that will be used by Popdock to connect. Please store this value for later use.

Basic Authentication

Create a Username and Password that will be used by Popdock to connect:



E) Select the Install button to finish the process.


    3) Add the Gateway to an existing website in IIS Manager.

A) In the IIS Manager, Right-click on the Application Pools and choose, Add Application Pool.

 

B) Name the Application Pool something related to GPGateway, in the example below we called it DynamicsGPGateway.

 

C) Now, expand the Sites in the IIS Manager, select the site you want to add the GP Gateway (I have chosen the Default Website in the example below). Right-click and choose Add Application.

 

D) In the Alias field, name the application something simple (I’ve chosen DynamicsGPGateway in the example below but something simpler like GPGateway would be fine). Choose the Application Pool from the previous step above (Step 3-B) and finally browse to the location where we installed the Gateway in Step 2-B.

 

    4) Test that the Gateway is working by browsing to the website.

    5) Inside Popdock, Add a new Dynamics GP Connector and change the Connection type to one of the Gateway options (Depending on if you chose Token or Basic Authentication in Step 2-D above).

A) Gateway with Token Authentication: In the Gateway URL field, choose the URL that was tested in Step 4 above, then use the Token that was created in Step 2-D above.

B) Gateway with Basic Authentication: In the Gateway URL field, choose the URL that was tested in Step 4 above, then use the Username and Password that was created in Step 2-D above.

C) Select the Validate button to ensure that Popdock can connect to the GP Gateway.

D) Select the Connect button to start the process of creating the Dynamics GP lists in Popdock.

 

Please contact support@eonesolutions.com if you need further assistance.

 

 

TOP-RATED

Experience Popdock.

Request 1:1 Demo

We're committed to your privacy. eOne Solutions, the creator of Popdock, uses the information you provide to us to contact you about our relevant content, products, and services. You may unsubscribe from these communications at any time. For more information, check out our Privacy Policy.

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

Recorded Demo

We're committed to your privacy. eOne Solutions, the creator of Popdock, uses the information you provide to us to contact you about our relevant content, products, and services. You may unsubscribe from these communications at any time. For more information, check out our Privacy Policy.

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.