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.

1 Answer 1


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 !.
    – rams
    Commented Feb 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. Commented Feb 19, 2018 at 12:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.