Connecting to Microsoft Dynamics Great Plains

This document is a step-by-step guide for setting up the Microsoft Dynamics Great Plains integration within BrightGauge. 


Step 1 - Log in to your BrightGauge Account

If you haven’t created an account yet, go here to get started.

If you are logged in with a New Account:

From the account Overview page, click Add a Datasource:

If you are logged in with an Existing Account:

Click on the Data menu at the top righthand corner of the screen, and select Datasources from the drop-down menu:


Find the Microsoft Dynamics GP datasource under All or under the appropriate category:


Whether a new or existing account, you'll come to datasource settings screen below. Leave this page open as it will be used in Step 4. You can now proceed onto the next steps.



Step 2 - Download and Install BrightGauge Agent

Since Great Plains runs off a SQL database, you’ll need to download and configure the BrightGauge Agent. Click the Download link to download the agent.  Documentation to help set up configure the BrightGauge Agent can be found here.  Make sure to install the BrightGauge agent on a machine somewhere within the same network as your MS-SQL database for Great Plains.  If you have issues, you can view known issues here or you contact Support by selecting Help > Open a Ticket from the top menu bar.


Step 3 - Create a SQL user within the Great Plains database

After the agent is up and running, you’ll now need to create a SQL user within the Great Plains database. Great Plains runs off of MS-SQL, so here’s a guide on how to do that.  Make sure to enable the user to log into the Great Plains databases. We'll need read (the permission is db_datareader) access to 2 databases in your setup:

  • Dynamics
  • Your company's database. This is the important one.  This one actually contains the information for your company.  The name here differs for each setup, so make sure to use the one associated with the data you want to pull


Step 4 - Configure the Datasource Settings


Refer to the screenshot above and match the corresponding numbered fields:

  1. Name: A name for the connection.
  2. Agent Host: The computer on which the agent is installed.
  3. Database Internal IP/Hostname: Internal IP address or hostname for the database server (if using multiple SQL instances, use the IP or machine name followed by a backslash and then the instance name:\instance or SQLServer\instance).
  4. Database Name: The database name (e.g., cwwebapp_brightgauge).
  5. Database Internal Port: This field is for advanced SQL setups not using the default SQL port (1433). Enter the non-default port in this field. Leave BLANK if using the default SQL port (1433).
  6. Database Username: Your database username.
  7. Database Password: Your database password.


Step 5 - Test Connection

After you complete all fields, make sure to test the connection.  If successful, save the connection.

Please note, a common issue we have seen clients experience is with the AutoFill feature in web browsers inputting the wrong credentials for the database user field. When a test connection is successful, the page is refreshed and the autofill takes effect automatically without the user realizing. The user then selects save, accidentally saving the autofilled credentials which are incorrect. A way to prevent this issue is to open a private browsing window (or incognito window) to fill out the datasource configuration page, or simply retyping the credentials after the test connection and clicking Save.


Dashboards, reports, datasets, and gauges are added to your account after the datasource is saved. They will start syncing immediately and typically complete syncing after 20-30 minutes. 

Your Default Dashboards

  • Bookings
  • Receivables
  • Receivables Aging 

Your Default Reports

  • Receivables Last Month
  • Sales & Receivables Today

Your Datasets

  • Account Balances Trending This dataset shows the balances of accounts for each period in the last 6 years
  • Account Transactions - This is a listing of all, non-voided account transactions in the last 24 months
  • Purchase Orders  - Information on Purchase Orders modified in the last 24 months
  • Receivables Transactions Information on receivables transactions performed in the last 24 months
  • Sales Transaction Line Items - This dataset pulls in information for line items on each sales transaction. It pulls in vendor info from associated purchase orders. This is for sales transactions in the last 24 months
  • Sales Transactions - Sales transactions from the last 24 months
  • Vendor - This is a dataset looking at information for vendors setup within Great Plains

For a list of all default gauges, please visit the Gauges section of your account, sort by the Datasource you'd like to see, and select for Default.  

If you have any questions, please contact Support by selecting Help > Open a Ticket from the top menu bar.

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