Microsoft Dynamics GP

Version 24.3.9120


Microsoft Dynamics GP


You can use the Microsoft Dynamics GP connector from the CData Sync application to capture data from Microsoft Dynamics GP and move it to any supported destination. To do so, you need to add the connector, authenticate to the connector, and complete your connection.

Add the Microsoft Dynamics GP Connector

To enable Sync to use data from Microsoft Dynamics GP, you first must add the connector, as follows:

  1. Open the Connections page of the Sync dashboard.

  2. Click Add Connection to open the Select Connectors page.

  3. Click the Sources tab and locate the Microsoft Dynamics GP row.

  4. Click the Configure Connection icon at the end of that row to open the New Connection page. If the Configure Connection icon is not available, click the Download Connector icon to install the Microsoft Dynamics GP connector. For more information about installing new connectors, see Connections.

Authenticate to Microsoft Dynamics GP

After you add the connector, you need to set the required properties.

  • Connection Name - Enter a connection name of your choice.

  • URL - Enter the URL for your Microsoft Dynamics GP account.

  • Company Id - Enter the unique identifier of the company that you want to access as a data source.

CData Sync supports authenticating to Microsoft Dynamics GP in several ways. Select your authentication method below to proceed to the relevant section that contains the authentication details.

Web Services Security

To connect with your Web Services Security (WS-Security) credentials, set the following properties:

  • Auth Scheme: Select WSS.

  • User - Enter the username that you use to authenticate to your Microsoft Dynamics GP account.

  • Password - Enter the password that you use to authenticate to your Microsoft Dynamics GP account.

NTLM

To connect with NTLM user credentials, specify the following properties:

  • Auth Scheme – Select NTLM.

  • User - Enter the username that you use to authenticate to the Microsoft Dynamics GP server.

  • Password - Enter the password that you use to authenticate to the Microsoft Dynamics GP server.

Basic

To connect with your user credentials, set the following properties:

  • Auth Scheme: Select Basic.

  • User - Enter the username that you use to authenticate to your Microsoft Dynamics GP account.

  • Password - Enter the password that you use to authenticate to your Microsoft Dynamics GP account.

Digest

To connect with digest-authentication credentials, specify the following properties:

  • Auth Scheme – Select Digest.

  • User - Enter the username that you use to authenticate to the Microsoft Dynamics GP server.

  • Password - Enter the password that you use to authenticate to the Microsoft Dynamics GP server.

None

To connect without authentication, select None for Auth Scheme. No additional properties are required.

Negotiate

To connect with Kerberos credentials, specify the following properties:

  • Auth Scheme – Select Negotiate.

  • User - Enter the username that you use to authenticate to the Microsoft Dynamics GP server.

  • Password - Enter the password that you use to authenticate to the Microsoft Dynamics GP server.

  • Kerberos KDC - Enter the Kerberos Key Distribution Center (KDC) service that you use to authenticate.

  • Kerberos Realm - Enter the Kerberos 5ealm that you use to authenticate.

  • Kerberos SPN - Enter the service principal name (SPN) for the Kerberos domain controller.

  • Kerberos Keytab File (optional) - Enter the path to the keytab file that contains your pairs of the Kerberos principals and encrypted keys.

  • Kerberos Ticket Cache (optional) - Enter the full path to an MIT Kerberos credential cache file. Sync uses the specified cache file to obtain the Kerberos ticket that is required to connect to Microsoft Dynamics GP.

Complete Your Connection

To complete your connection:

  1. Define advanced connection settings on the Advanced tab. (In most cases, though, you should not need these settings.)

  2. Click Connect to Microsoft Dynamics GP to connect to your Microsoft Dynamics GP account.

  3. Click Create & Test to create your connection.

More Information

For more information about interactions between CData Sync and Microsoft Dynamics GP, see Microsoft Dynamics GP Connector for CData Sync.