Installation and Setup Steps
1. Download the Dynamics GP Gateway.
2. Install the Gateway following the steps below:
a) Select Next in the installer to begin.
b) Select the desired folder where the files will be installed. By default, the Program Files (x86) directory will be chosen.
c) Provide the credentials to connect to the SQL Server that hosts the Dynamics GP data.
· Server: The local address and the instance to the SQL Server, and the port as necessary (ex. Demo1SQL,49721).
· System Database: The name of the Dynamics GP System database (usually DYNAMICS).
· Username: The desired SQL Server user. This user does not need to be “sa” but they must have access to be able to read the SYS tables in order to access the metadata.
· Password: The password for the SQL Server user listed above.
d) Choose the Authentication type that Popdock will use to connect with the Gateway. We highly recommend using Token as it is easier and more secure, but we will cover Basic authentication as well.
· Token
Create a Token that will be used by Popdock to connect. The Token can be created however you like whether through a random generator or a custom one. Store this value somewhere safe for later use.
· Basic Authentication
Create a Username and Password that will be used by Popdock to connect to the gateway.
e) Select Install to finish the process.
If using Token, continue with the following steps:
Once you have finished up with the installer, go to the Dynamics GP data Gateway folder in your file browser and open the appsettings.json file.
(C:\Program Files (x86)\Popdock\Dynamics GP data Gateway\appsettings.json)
Inside the appsettings.json file, delete everything within the password line from the authentication section of the file EXCEPT the double quotes (The Gateway installer will automatically encrypt the blank field of the password section for basic authentication, and this will error out during the validation of the connector).
After this is deleted, save the file, and then continue onto the IIS section of the Gateway setup process.
If using Basic Authentication, continue with the following steps:
Once you have finished up with the installer, go to the Dynamics GP data Gateway folder in your file browser and open the appsettings.json file.
(C:\Program Files (x86)\Popdock\Dynamics GP data Gateway\appsettings.json)
Inside the appsettings.json file, delete everything within the token line from the authentication section of the file EXCEPT the double quotes (The Gateway installer will automatically encrypt the blank token section for token authentication, and this will error out during the validation of the connector).
After this is deleted, save the file, and continue onto the IIS section of the Gateway setup process.
3. Add the Gateway to an existing website within IIS Manager.
a) In IIS Manager, right-click Application Pools and then select Add Application Pool.
b) Name the Application Pool something related to the GP Gateway, for example DynamicsGPGateway.
c) Expand the Sites node in IIS Manager and then select the site in which you want to add the Dynamics GP Gateway. For example, you could add it to the Default Website. Right-click and then select Add Application.
d) In the Alias field, name the application something simple, for example DynamicsGPGateway. You could use something simpler like GP Gateway, as well. Choose the Application pool from the previous step and then select the path used to install the Gateway in Step 2b. Then select OK.
4. Ensure the Gateway is properly bound with SSL security and is externally facing.
a) In IIS Manager, go to the site that you installed the Gateway on. In the upper right-hand corner, select Bindings.
b) In the bindings menu, select Add and within the Edit Site Binding window, change the Type to https, leave the IP address as All Unassigned and the Port will be set to 443 (if you are using a nonstandard port use that instead). From there, add in the Host name as mentioned in the pre-requisites. Then select the SSL certificate that will be used for this binding. Finally, select OK.
5. Once the SSL security is setup, return to the site in IIS and select the new web service URL on the right-side. Browse to the site to make sure the Gateway is working.
If everything is correct and setup properly, you will get this screen when you browse to the Gateway site.
6. Return to your Popdock web application and add your new GP Connector.
a) In Popdock, from the main menu, select Connectors.
b) Select Add Connector from the settings menu on the left side of the page and then select Dynamics GP from the list of connectors.
c) From the Connection type dropdown list, select the connection type you choose during the setup (Token or Basic Authentication).
· Gateway with Token Authentication: In the Gateway URL field, choose the URL that you used in IIS, and then use the Token you created previously.
· Gateway with Basic Authentication: In the Gateway URL field, choose the URL you used in IIS, then use the Username and Password that you created previously.
d) Select Validate from the Action menu to ensure that Popdock can connect to the GP Gateway.
e) Select Connect from the Action menu to start the process of creating the Dynamics GP lists in Popdock.
Questions on setting up your Dynamics GP Gateway? Contact support@eonesolutions.com.