MS Dynamics GP Stored Procedures

Support for MS Dynamics GP is done through two different connectors. The MS Dynamics GP SQL connector is used to read data from GP and the MS Dynamics GP SP (Stored Procedure) connector is used to update and insert data into GP using the Stored Procedures in the GP database (which is the same method as GP own integration tools uses).

Support for the old GP systems may also be supplied - please ask us.

The following versions of MS Dynamics GP are supported

• MS Dynamics GP 2013
• MS Dynamics GP 2009

MS Dynamics GP supported Data Types

Additional installation

Installing the RapidiConnector

If you want to transfer data to/from MS Dynamics GP Data Sources, you have to do the following:

• Install "MS-SQL Client" on the computer from where you have the RapidiConnector running. This might already be done if you for example have the MS Dynamics GP client installed on that computer.

Configuration

The fields of the Dynamics GP SQL Connector Card are as follows:

• Code: The code of the connection. This field is automatically generated and cannot be changed.
• Description: Enter a text describing the Connection.
• Server Connect:Specify the name of the MS-SQL Server. (In some cases you can also specify the TCP/IP Address of the server).
• Database: Specify the name of the database (for the specific company that you want to transfer data from) on the MS-SQL Server.
• Use Windows Authentication: If you use the same UserID and Password to access the database when logging on to your Windows, you can mark this field. Please note that it is the username that the RapidiConnector is running under that is used. If you use windows authentication, the fields UserID and Password are ignored.
• UserID: If access to the database requires a UserID you have to specify the UserID here.
• Password: If you enter a UserID the corresponding Password is applied here.

Copy, Test, Activate Changes and Read Design

Copy Connection

Connection Test

Activate Changes

Read Design