MS Dynamics is a series of products to assist ERP. The products are:
Dynamics 365 - Enterprise Edition
Dynamics 365 - Business Edition
Dynamics NAV
Dynamics GP
Dynamics SL
Dynamics 365 Applications
Some Dynamics 365 applications include
Dynamics 365 Sales
Dynamics 365 Customer Service
Dynamics 365 Talent
… ?
These applications use Microsoft Dataverse (formerly Common Data Service) to store and secure data used by the application.
Customization
«Things» that can be customized:
Application Ribbon
Entity: Definition of record types / description of kinds of data. Entities correspond to a SQL table.
Field (which is a property of an Entity and can probably be thought of as an SQL table column or attribute)
Entity relationship?
Form
Business process flow
Message?
Option Set?
Site Map?
Dashboard
Interface
Web Resource?
Workflow
After customizing some thing, the customizing needs to be published (or deployed?).
Metadata driven architecture
An app is customized using PowerApps customization tools. This basically adds or updates metadata.
Metadata driven architecture promises to customize (=configure) applications without writing code. Hmm... didn't we have that already with SQL?
Entities
ID (unique identifier)
The PowerApps environment mandates all entities to have an ID attfibute whose value is a GUID.
Relationship
A relationship defines the association between two entitites.
There are 1:n, n:1, n:n and self-referential relation types.
Views
A view defines how records for an entity is displayed: Which columns (= field), their widths, the sort order and filters (which corresponds to an SQL where condition).
Three types of views:
Personal
System (such as Quick Find, Advanced Find, Associated and Lookup)
Public
Views are created and edited with the app designer or the solution explorer.
Forms
Form Scripts / Events
Forms can trigger events to which so called form scripts can be attached.
Such form scripts can then, for example, make sure that the data entered is valid.
Solution
A Solution is something that can be independently moved/copied across different organizaions.
Thus, it allows to create sellable solutions.
Qlik Microsoft Dynamics CRM Connector
The Qlik Microsoft Dynamics CRM Connector lets you run FetchXML queries to fetch Microsoft Dynamics CRM data and load it directly into your Qlik Sense app.