The SQL Server connector allows Mekorma applications, such as Invoice Capture, to communicate with the Dynamics GP database via the on-premises data gateway.

Prerequisites

Gather all credential information that you will need before you start.

Item Data
SQL Server Instance Name ServerName\SQLServerName
Dynamics GP Database DYNAMICS
SQL Proxy Username and Password MekormaProxy
Data Gateway Name XYZ_DataGateway (where XYZ is the acronym of your company)
Service Account One of the following (depending on the Mekorma product you are using)
  • svc_powerapprovals@mycomany.com
  • svc_mobileworkflows@mycompany.com
  • svc_invoice@mycompany.com
Last modified: April 28, 2025