A fully Open Source and completely extendable BI platform comprised of two major components; Data Integration & Web Analytics - This is the ETL solution
SuiteCRM Data Integration
Due to size (980 MB) please download via sourceforge
SuiteCRM Data Integration is an Extract, Transform and Load (ETL) solution. It connects to any SuiteCRM instance, extracts source data from the MySQL/ MariaDB database and loads it into a Data Warehouse which has been optimised for analytical functions. SuiteCRM Data Integration can be installed as a stand-alone solution and can be used with other reporting tools if desired.
The fully extensible foundation solution extracts data only from SuiteCRM and embraces other third party data sources for complete data mashups. For example, users could pull in weather data from a meteorological site, historical sales data from ERP and compare it against global and regional sales account performance data in SuiteCRM to gain deeper insights into customer behaviour.
- Open Source
- Optimised for Performance
- Visual UI for developing and adding third party data sources
- Data Extraction Scheduling
- Data Warehouse Schema
Other add-ons of interest
Analytic Reporting Tool Basic
Dynamic Reports and Interactive Charts.
Powerful tool for SuiteCRM report creation and data analytics. Includes a variety of chart types, detailed, summary and pivot tables. This Reporting Tool is for anyone, no need for technical knowledge or SQL. Comes with over a hundred prebuilt reports.