Sitecore

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...

Hello everyone, Hope everyone is doing great. This blog is one more addition to my existing blogs list. You can anytime refer my Blog Site for Sitecore related blogs. Hope this blog site will help you in learning something new. Now let's start with todays topic for discussion. In this blog we are going to see how we can create custom table in Sitecore reporting database and how we can write custom aggregation processor to pass all the user define analytics data to our custom tabel similar to how sitecore internally processes the same. This blog will be divided into two parts: We will see how we can create custom table in reporting database along with Store procedure, Table aliases required for the same We will see the custom aggregation code required for the same We will try to understand all this things using a Use Case. Use Case: We need to create a cutom table in reporting db to store all the campaign visited by the Contact along with the dates of visits. Step ...