Dynamics supports deployments where several different tenants access a centrally maintained Dynamics application. This is often referred to as a ‘Public Cloud’ option, as the resources are shared by multiple organizations (tenants). By sharing the resources, organizations can also share the costs and, instead, pay only for what’s needed.
Inverse of the cost benefits, this option also comes with more restrictions and less customization. One of the common restrictions is that the individual tenant has limited access and control over the underlying SQL database.
- Single-tenancy (Private): Each database stores data from only one tenant
- Multi-tenancy (Public): Each database stores data from multiple separate tenants (with mechanisms to protect data privacy)
For Jet Analytics to operate as intended, direct access to the source data is required. In a Multi-Tenant environment, where the source database has data from multiple organizations, direct access to the ERP database is uncommon. This is largely due to the database being shared, meaning access would expose data otherwise protected.
To proceed with Jet Analytics, assistance from the database provider will be required.
- Database provider can supply a SQL User account with the appropriate permissions
- Database provider can setup SQL replication to a location where access is allowed