Create a Dynamics GP Data Source in Jet Hub

Related Articles...

Overview

Process

1. From the Jet Hub Admin menu, select Data Source Setup

   

2. On the Data Source Setup window, click the + Add Data Source button

   

3. On the Details screen...

   • Give your GP data source a descriptive name

   • For the Database Type, select Dynamics GP

   • For the Connection Method, select On Premises

   • Click Save

   

4. Move to the Authentication screen...

   Specify the user credentials needed to connect to the Dynamics GP SQL database (note: these may not be the same credentials as are used to connect to the Dynamics GP client).  Click Save.

   

5. Move to the Connection settings...

   • Specify the Server name where the Dynamics GP SQL database can be found.

   • Select the name of the Dynamics database (the default name is Dynamics, but may be different in newer versions of GP - check with your system administrator)

   • Enter the name of the default (even if it is the only) Company name within the database.

   • Click Save.

   

6. If needed, adjust any defaults in the other settings sections (contact your system administrator or specifics).

7. Click the back arrow next to the Save button

8. Your new data source will be displayed on the Data Source Setup screen.