xDB Analytics Extractor
The xDB Analytics Extractor is an open-source tool designed to integrate Sitecore Analytics data with business intelligence (BI) platforms. It lets you extract data regarding visitor interactions and other analytics from xConnect and transform it into formats that can be used by BI tools like PowerBI or Google Analytics. This tool also lets you create custom charts and reports beyond what's available in the standard Sitecore Analytics dashboard. You can export your data with SQL databases or CSV files and you can extend this tool's functionality with custom exporters and processors.
You can find the full documentation on the xDB Analytics Extractor GitHub project page.
For source code, releases, and contribution information, see the public xDB Analytics Extractor GitHub repository. Some internal build or automation scripts referenced in the repository are not intended for direct customer use.
To set up xDB Analytics Extractor, first ensure you've set up all prerequisites, such as .NET SDKs, MSSQL Server, and a Sitecore certificate. To install it, you need to configure the appsettings file and run a simple installation script. After that, you can configure the workload and scheduling through tools like the InteractionsEvaluator and the Windows Task Scheduler. You can make further adjustments by changing the yourconfig.json file to manage steps like cleaning, restoring, building, and publishing the service.
You can extend the extractor by adding custom exporters and processors. Exporters convert extracted data into different formats like CSV, JSON, or SQL, while processors transform raw data from xDB into useful models for BI tools. You can create your own exporters to suit different data formats, for example to use with tools such as PowerBI, or modify the database schema for your specific project needs.