Create a Dynamics GP Jet Remote Data Source - User Guide
Overview
If you Dynamics GP data resides on a different network domain that does your installation of Microsoft Excel, System Administrators can use the JRDS Admin Guide to help them configure the Jet Remote Data Service.
Once that service is set up, users of the Jet Excel add-in can configure a data source to use the service.
Configuring the Data Source Connection
The first step in the Jet add-in is to create a new data source of the type Dynamics GP with a connection type of Remote Data Service Next, the authentication needs to be configured. The user can authenticate against the JRDS using specified Windows credentials.
It is expected that users will be given a username, domain, and password to use for authentication.
-
To create a new data source connection to your GP database, start by selecting Settings > Data Source Settings from the Jet ribbon.
-
On the Data Source Settings window, click the Add button. When the Add Data Source dialog will appear, provide a unique name for our GP data source, select Dynamics GP for the Database Type , and Remote Data Service for the Connection Method.
-
It is expected that users will be given a username, domain, and password to use for authentication.
-
The connection information for the instance of the JRDS must be configured:
-
Note that the
S
erver
is the one which is hosting IIS and the JRDS. The
Port
is the one which was entered into PowerShell when the Application Container was created. The
Instance
is the name entered into PowerShell when the Service Instance was created.
The dropdown to select the company will populate when opened if the settings are correct.
-
Once the Data Source Settings are correct, you can test them by clicking the Test Connection button at the top of the Data Source Settings window and should see the Test Connection Succeeded message. If there are any issues, the message should help you in troubleshooting.