The SQL Server connector allows Mekorma applications, such as Power Approvals and Invoice Capture, to communicate with the Dynamics GP database via the on-premises data gateway.
The SQL connector can be used for both Power Approvals and Invoice Capture simultaneously. For example, the connector created for Power Approvals can be shared to the Invoice Capture’s service account (e.g., svc_invoice@mycompany.com). Likewise, the Invoice Capture SQL connector can be shared to the Power Approvals service account (svc_powerapprovals@mycompany.com).
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)
|
Connection
These topics are included in this section.
- Creating a Connection to Your On-Premises SQL Server in Your Power Apps Environment
- Sharing the SQL Connector
Last modified:
April 24, 2025