⚙️ Installation and Setup of ChiliDataWarehouse®

Step-by-Step Guide to Installing and Setting Up ChiliDataWarehouse®

With this solution, you can manage your HubSpot data in a centralized SQL database hosted in the Swiss Azure Cloud and seamlessly integrate it with BI tools such as PowerBI, Tableau, Excel, and others.

This guide will walk you through the installation and setup process step by step.

Prerequisites

  • HubSpot Account: You need an active HubSpot account from which the data will be synchronized.

  • Active ChiliDataWarehouse Subscription

  • BI Tool: An installed BI tool (e.g., PowerBI, Tableau) for later integration.

Step-by-Step Instructions

  1. Installation of the HubSpot App
    Install the HubSpot Marketplace App in your HubSpot account.
    Follow the instructions to establish the connection to ChiliDataWarehouse.

  2. Registration and Login
    Log in via the ChiliSSO platform (accounts.chili.ch).
    After successful registration, you will receive access to the ChiliDataWarehouse backend.

  3. Backend Setup
    When installing the HubSpot App, you will automatically be redirected to the ChiliDataWarehouse interface. If not, log in to the backend at https://datawarehouse.chili-digital.com/.
    Configure your system settings here and generate the connection string, which serves as the access point to the SQL database.

  4. Starting Data Synchronization
    Data synchronization should start automatically when connecting via the connection string. If not, use the "Immediate Synchronization" option to start the process manually.

  5. Additional Optional Steps
    Afterwards, review the Synchronization Log to ensure that all data has been transferred correctly.
    Optionally, set up notifications to be informed of successful or failed synchronizations.