Skip to main content

Microsoft 365 data model

This section describes the Microsoft 365 data model that was introduced in Snow License Manager 9.6.2. All data tables and schema changes are listed in Microsoft 365 data tables.

Microsoft 365 data is processed and stored as relational and event-sourced data models.

Relational data tables hold a current state of the data, mirroring Microsoft 365 portal data collected through the Snow Integration Connector and then enriched by Snow Inventory data and manual input from the Snow License Manager user interface.

The following tables are added to o365 database schema:

  • Portal
  • SubscriptionPlan
  • User

Event-sourced data tables tracks changes by using the following events:

  • PortalUsersCountUpdatedEvent
  • PortalUsersMonthlyCountUpdatedEvent
  • SubscriptionPlanAddedEvent
  • SubscriptionPlanLicensesUpdatedEvent
  • SubscriptionPlanPriceUpdatedEvent
  • SubscriptionPlanRemovedEvent
  • SubscriptionPlanUpdatedEvent
  • SubscriptionPlanActivityAddedEvent
  • ProductActivityAddedEvent
  • UserRemovedEvent
  • UserActivityEvent

SnowEventWarehouse

note

The SnowEventWarehouse service was removed in Snow License Manager 9.27.

Snow License Manager uses the service SnowEventWarehouse to store event data. The SnowEventWarehouse service replaces the previously used EventStore service. The SnowEventWarehouse has the following important implementation details:

  • The data is stored in the same Microsoft SQL database as Snow License Manager data. The data is stored in the following tables in a ew schema:

    • ew.Event
    • ew.TenantSource
    • ew.EventsRequestResultCache
  • The service communication is implemented via NATS messaging system.

  • The service performance is optimized to Snow needs.

  • Installing version 9.12 of Snow License Manager will upgrade Event Warehouse to v1.1.7.

caution

Any manual data updates, or deletions, applied to any table in the ew schema are considered as data corruption actions and thus render Snow unable to provide any support.