|
<< Click to Display Table of Contents >> Raynet One Data Hub > 2026.4 > Administration and User Guide > Connectors Microsoft Dynamics CRM Connector |
The Microsoft Dynamics CRM connector connects to the Microsoft Graph API (beta endpoint) to collect user information, license data, and optional usage data from your Microsoft 365 or Dynamics CRM environment. The connector is categorized under Business & SaaS and is of type Standard.
The connector requires the following authentication settings. These values are obtained from your Azure app registration.
Setting |
Description |
Tenant |
The directory tenant from which permission is requested. Accepts either a GUID or a friendly name (for example, your Azure Active Directory domain name). |
Client ID |
The Application ID assigned by the Azure app registration portal when the app was registered. |
Client Secret |
The Application Secret generated for the app in the app registration portal. This value is masked after it is saved. |
Dynamics CRM URL |
The full URL (including protocol) of your Dynamics CRM instance. This setting is required when fetching usage data from Dynamics CRM. For native apps, an application user must be configured in the CRM portal. Example: https://yourName.crm4.dynamics.com |
The following settings control which data the connector collects and how it behaves at runtime.
Setting |
Description |
Fetch additional data |
Determines which additional usage data is collected. Available options are: •None (default) — Only core user and license data is collected. No sign-in data is fetched. •AD — In addition to core data, sign-in events are fetched from Azure Active Directory via the Microsoft Graph API (auditLogs/signIns endpoint). Produces the sign_ins_azure result table. •CRM — In addition to core data, sign-in audit records are fetched directly from the Dynamics CRM instance. Requires a valid Dynamics CRM URL. Produces the sign_ins_dynamics result table. |
Usage since |
Defines how far back in time sign-in data is collected, using ISO 8601 duration or date-time format. Default: PT90d (90 days). The maximum supported window for Azure AD sign-ins is 95 days. For Dynamics CRM sign-ins the value is converted to days and applied as a filter on the createdon field. |
Usage request interval |
Applies only when Fetch additional data is set to AD. Splits the total usage window into parallel sub-requests of this length to reduce total run time. Default: PT12h. Must be shorter than the value of Usage since. |
The connector writes data to the following result tables in the database. The tables marked as Always produced are written on every run regardless of the Fetch additional data setting. The tables marked as Conditional are only produced when the corresponding option is selected.
Contains one record per user account retrieved from the Microsoft Graph API (beta/users endpoint). Both active and soft-deleted user accounts are included.
Availability: Always produced.
Column |
Type |
Description |
Id |
String |
Unique identifier of the user object in Azure Active Directory. |
UserPrincipalName |
String |
The user principal name (UPN) of the user, typically in the format user@domain. |
GivenName |
String |
The first name of the user. |
OnPremisesUserPrincipalName |
String |
The on-premises UPN of the user. Populated only for hybrid-synchronized accounts. |
Surname |
String |
The last name of the user. |
String |
The primary email address of the user. |
|
DisplayName |
String |
The display name of the user as shown in the directory. |
DeletedDateTime |
String |
The date and time when the user was soft-deleted. Empty for active accounts. |
UserType |
String |
Indicates the type of user. Typical values are Member or Guest. |
Country |
String |
The country or region where the user is located. |
Department |
String |
The department in which the user works. |
OfficeLocation |
String |
The office location in the user's place of business. |
UsageLocation |
String |
A two-letter country code (ISO 3166) that is used by Microsoft to verify service availability in the user's location. |
AccountEnabled |
Boolean |
Indicates whether the user account is enabled. True if the account is enabled; False if it is disabled. |
LastSignIn |
String |
The date and time of the user's most recent sign-in. Populated only when Fetch additional data is set to AD (requires the signInActivity permission). Otherwise empty. |
CountryLat |
Double |
The latitude coordinate derived from the user's country. Populated from a lookup table based on the Country field. |
CountryLng |
Double |
The longitude coordinate derived from the user's country. Populated from a lookup table based on the Country field. |
Contains one record per subscribed SKU (license product) in the tenant, fetched from the v1.0/subscribedSkus endpoint.
Availability: Always produced.
Column |
Type |
Description |
Id |
String |
Unique identifier of the subscribed SKU record. |
SkuId |
GUID |
The unique identifier (GUID) of the service SKU. |
SkuPartNumber |
String |
The product part number of the SKU, for example ENTERPRISEPACK for Microsoft 365 E3. |
DisplayName |
String |
The human-readable display name of the SKU. |
AppliesTo |
String |
Indicates whether the SKU applies to users or to the company (User or Company). |
CapabilityStatus |
String |
The capability status of the subscription. Typical values are Enabled, Warning, Suspended, Deleted, or LockedOut. |
ConsumedUnits |
String |
The number of license units that have been assigned to users. |
A relationship table that maps each user to the SKUs assigned to them. Used to join the users and skus tables.
Availability: Always produced.
Column |
Type |
Description |
UserId |
GUID |
References the Id column of the users table. |
SkuId |
GUID |
References the SkuId column of the skus table. |
Contains one record per service plan assignment per user. A single SKU may include multiple service plans, so a user can have multiple records in this table for a single assigned SKU.
Availability: Always produced.
Column |
Type |
Description |
Service |
String |
The internal name of the service plan component. |
CapabilityStatus |
String |
The provisioning status of the service plan for this user. Typical values are Success, PendingActivation, or Disabled. |
AssignedDateTime |
DateTime |
The date and time when the service plan was assigned to the user. |
UserId |
GUID |
References the Id column of the users table. |
ServicePlanId |
GUID |
References the Id column of the service_plans table. |
Contains one record per unique service plan. A service plan is a component of a SKU (for example, Exchange Online is a service plan within the Microsoft 365 E3 SKU).
Availability: Always produced.
Column |
Type |
Description |
Id |
GUID |
Unique identifier of the service plan. |
Name |
String |
The internal name of the service plan. |
ProvisioningStatus |
String |
The current provisioning status of the service plan within the subscription. |
AppliesTo |
String |
Indicates whether the service plan applies to users or to the company. |
DisplayName |
String |
The human-readable display name of the service plan. |
A relationship table that maps each SKU to the service plans it includes. Used to join the skus and service_plans tables.
Availability: Always produced.
Column |
Type |
Description |
SkuId |
GUID |
References the SkuId column of the skus table. |
ServicePlanId |
GUID |
References the Id column of the service_plans table. |
Contains sign-in audit records retrieved from Azure Active Directory via the Microsoft Graph API (v1.0/auditLogs/signIns endpoint). Only successful sign-ins (errorCode = 0) within the configured Usage since window are included.
Availability: Conditional. Produced only when Fetch additional data is set to AD. The maximum lookback window is 95 days.
Column |
Type |
Description |
Id |
GUID |
Unique identifier of the sign-in event. |
UserId |
GUID |
References the Id column of the users table for the user who performed the sign-in. |
AppId |
GUID |
The application identifier of the client that performed the sign-in. |
AppDisplayName |
String |
The display name of the application that the user signed in to. |
CreatedDateTime |
DateTime |
The date and time when the sign-in event occurred. |
UserPrincipalName |
String |
The UPN of the user who performed the sign-in. |
IpAddress |
String |
The IP address of the client that performed the sign-in. |
LocationCountryOrRegion |
String |
The country or region from which the sign-in originated. |
LocationState |
String |
The state or province from which the sign-in originated. |
LocationCity |
String |
The city from which the sign-in originated. |
LocationGeoCoordinatesLatitude |
Double |
The latitude of the geographic location from which the sign-in originated. May be empty if location data is unavailable. |
LocationGeoCoordinatesLongitude |
Double |
The longitude of the geographic location from which the sign-in originated. May be empty if location data is unavailable. |
Contains sign-in audit records retrieved directly from the Dynamics CRM instance (api/data/v9.1/audits endpoint). Only audit records with action code 64 (user sign-in) within the configured Usage since window are included.
Availability: Conditional. Produced only when Fetch additional data is set to CRM. Requires a valid Dynamics CRM URL and an application user configured in the CRM portal.
Column |
Type |
Description |
Id |
GUID |
Unique identifier of the audit record in Dynamics CRM (mapped from the auditid field). |
UserId |
GUID |
The identifier of the system user in Dynamics CRM who performed the sign-in. |
UserPrincipalName |
String |
The domain name (UPN) of the Dynamics CRM system user who performed the sign-in. |
CreatedOn |
DateTime |
The date and time when the sign-in audit record was created in Dynamics CRM. Stored in UTC. |
Users with the Data Admin role are currently not able to create tasks for the Microsoft Dynamics CRM connector, either from the Connectors page or via the task creation wizard. This is a known limitation in Data Hub 2026.2 that will be resolved in a future release. Users with the Administrator role should create and configure Dynamics CRM tasks on behalf of Data Admin users until this limitation is resolved.