Sign Up for Training |
insightsoftware Company Site
Submit a Request
Become a Jet Insider
Give Feedback

Create a Dynamics GP Data Source in Jet Hub

This feature is available in Jet 2019 R2 and higher

Related Articles...


You can define a data source connection to an on-premises Dynamics GP database from directly within Jet Hub.


  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.


Was this article helpful?
0 out of 0 found this helpful