Microsoft 365 data model

This section describes the Microsoft 365 data model which is introduced in Snow License Manager 9.6.2. All data tables 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 have been 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

Snow Event Warehouse

Snow License Manager uses the service Snow Event Warehouse to store event data. Snow Event Warehouse replaces the previously used EventStore service. Snow Event Warehouse 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 will upgrade Event Warehouse to v1.1.7.

Warning

Any manual data updates or deletion applied to any tables in the ew schema is considered as data corruption actions and thus renders Snow unable to provide any support.