- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
Hi Marcel,
nms:trackingLog schema is a template schema that trackingLogXXX schemas inherit from. Same applies for nms:deliveryLog. Hence it has no corresponding physical SQL table. TrackingLogs are not merged into a single table. You may refer to this page for a description of the datamodel.
Real-time events, broadlogs and trackings logs are stored in different tables depending on which instance you look at:
- On the Real-Time execution instance:
- RT events / broadlog / tracking logs: nms:rtEvent, nms:broadLogRtEvent, nms:trackingLogRtEvent
- Batch events/ broadlog / tracking logs: nms:batchEvent, nms:broadLogBatchEvent, nms:trackingLogBatchEvent
- On the Control instance (Marketing), all the data coming from RT is synced and consolidated via technical OOTB workflows into same tables regardless of batch or RT events:
- Events / broadlog / tracking logs: nms:eventHisto, nms:broadLogEventHisto, nms:trackingLogEventHisto
Thanks,
Serge