The SQL Server connector allows Mekorma applications, such as Mobile Workflows and Invoice Capture, to communicate with the Dynamics GP database via the on-premises data gateway.
The SQL connector can be used for both Mobile Workflows and Invoice Capture simultaneously. For example, the connector created for Mobile Workflows 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 Mobile Workflows service account (svc_mobileworkflows@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
Need more help with this?
We value your input. Let us know which features you want to see in our products.