Adobe Creative Cloud data model
This section describes the Adobe Creative Cloud data model that was introduced in Snow License Manager 9.8.1. All data tables and schema changes are listed in Adobe Creative Cloud data tables.
Adobe Creative Cloud data is processed and stored as relational and event-sourced data models.
Relational data tables hold a current state of the data, mirroring Adobe Creative Cloud portal data collected through the Snow Integration Connector and then enriched by Snow Inventory data and manual inputs from the Snow License Manager user interface.
The following tables are added to adobecc database schema:
- Portal
- SubscriptionPlan
- User
Event-sourced data tables track changes by using the following events:
- PortalAddedEvent
- PortalInstanceNameUpdatedEvent
- PortalRemovedEvent
- SubscriptionPlanAddedEvent
- SubscriptionPlanLicenseQuotaUpdatedEvent
- SubscriptionPlanPriceUpdatedEvent
- SubscriptionPlanProfileAddedEvent
- SubscriptionPlanProfileRemovedEvent
- SubscriptionPlanRemovedEvent
- SubscriptionPlanServicesUpdatedEvent
- SubscriptionPlanUpdatedEvent
- SubscriptionPlanUserCountUpdatedEvent
- UserActivityEvent
- UserRemovedEvent
SnowEventWarehouse
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 was introduced in Snow License Manager 9.6.2 as a replacement for the 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 the ew schema:
- ew.Event
- ew.TenantSource
-
The service communication is implemented via NATS messaging system.
-
The service performance is optimized to Snow needs.
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.