MyRapidi
MyRapidi

Search our Wiki

MS Dynamics GP SQL

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

Support for earlier MS Dynamics GP systems may also be supplied - please ask us.

The following versions of MS Dynamics GP are supported

  • MS Dynamics GP 2016 (coming soon)
  • MS Dynamics GP 2015
  • MS Dynamics GP 2013
  • MS Dynamics GP 2010

show informationhide information
MS Dynamics GP supported Data Types

Additional installation

show informationhide information
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

show informationhide information
Copy Connection

show informationhide information
Connection Test

show informationhide information
Activate Changes

show informationhide information
Read Design