I have my Sitecore multisite up and running.(Version 8.2).The values and data are populated on both Mongodb and SQL databases.But May I know what is the use of Analytics Database stored on the SQL server, and how the data is being captured and stored on the sql database.Is there any links/documents available ,to explain the same.
Add a comment
|
1 Answer
The Analytics DB is used as a reporting database for xDB. MongoDB is the collection database and periodically this is aggregated and stored in the Analytics db (also called the reporting db).
If you are disabling xDB and Tracking, then there is no need for the Analytics DB.
You can read more here: https://doc.sitecore.net/sitecore_experience_platform/82/setting_up_and_maintaining/xdb/platform/reporting_database_reference
-
Thanks for the update.I'm not disabling xDB and Tracking.The data is stored on both Mongodb and SQL.I just need to know Analytics data is directly captured from MongoDB or not !.– ramsFeb 19, 2018 at 12:48
-
It is directly added from MongoDB through Processing server, or Content Management server if you are enabling Processing functionality there. Hope this answers your question. Feb 19, 2018 at 12:54