Custom Table To Store Sitecore Analytics data in Reporting Database Part 1
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 ...