Custom Table To Store Sitecore Analytics data in Reporting Database Part 2
Hello everyone, this is continuation to previous blog, Part 1 of this series where we have seen, steps to create custom table in reporting database. Link for the same is here Part 1 This part, we will be concentrating more one the code logic required to update data in the custom table. Let's start with the code part without any delay. We will create 4 classes respectively: CampaignVisitKey.cs : Which will have the key on which the table entry will be done CampaignVisitValue.cs : The value for our columns which will be inserted CampaignVisit.cs : This class is inheriting from Fact table. It merges the current datatable of Campaign visits to existing table CampaignVisitProcessor.cs : This processor executes the actual logic of reading and assigning the values to our model. Let's see the code for all the classes one by one CampaignVisitKey.cs using Sitecore.Analytics.Aggregation.Data.Model; using System; using System.Collections.Generic; using Syste...