SuiteCRM Data Integration handles the population of the Data Warehouse. Its job is to pull data from SuiteCRM, denormalise the data and prepare it for analytics using SuiteCRM Analytics

Linux OS (Tested with Ubuntu 18.04) • Oracle Java 1.8 • wget • curl • unzip • root privileges to MySQL

On the commandline execute the following:

• sudo add-apt-repository ppa:webupd8team/java
• sudo apt-get update
• sudo apt-get install oracle-java8-installer

We need to create an empty database in MySQL to hold the data warehouse tables. Once created keep a note of the name of the database as we will need it later when we configure the solution

• Download the SuiteCRM-Data-Integration.zip
• Unzip somewhere on the file system

• Open the install.properties in a text editor
• Configure the database connection properties
    ◦ Properties that start with SUITECRM_ should point to your existing SuiteCRM Installation
    ◦ Properties that start with SUITECRM_ANALYTICS_ should point to the newly created database in the previous steps.
    ◦ NOTE: The user for the SUITECRM_ANALYTCS database should have root permissions so that the installation can create the Data Warehouse tables

Run the setup script to create the data warehouse and configure the solution. On the commandline execute: ./setup-suitecrm-data-integration.sh

Now that the solution is configured we can populate the Data Warehouse with data from SuiteCRM. Simply run: ./run-suitecrm-data-integration.sh This script will get all the data from from SuiteCRM on the first run and with any future runs, it will get the latest changed data. This means the first run could take some time but subsequent runs will be faster depending on the volume of new data. Check The Data Warehouse Once the script above has been completed without errors you can log into MySQL to check that the SuiteCRM Data Warehouse contains data.