Introduction

This guide walks you through the installation of any of our connectors on a DigitalOcean Droplet. DigitalOcean Droplets are Linux-based virtual machines (VMs or VPSs, Virtual Private Servers) that run on top of virtualized hardware.

You can install our connectors in several ways. Some options are:

The example here only shows Power BI HubSpot Connector installed on hubspot.YourDomain.com (option 2). For Pipedrive and Jira connectors just use pipedrive.YourDomain.com and jira.YourDomain.com or whatever subdomain or domain you want.

In your case replace “YourDomain.com” with your actual domain name.

How to configure subdomain

1. Create a Droplet in DigitalOcean using the LAMP image
   https://marketplace.digitalocean.com/apps/lamp
   Droplet Type: Shared CPU / Basic
   In CPU Options we recommend: Regular, 4 GB
2. Connect to your Droplet through the console
3. Create the folder /var/www/hubspot.YourDomain.com running this command:

mkdir /var/www/hubspot.YourDomain.com

4. In your hosting panel create a subdomain as an A record pointing to your Droplet public IP address.
5. To configure Apache for hubspot.YourDomain.com, you need to create or modify the Virtual Host Configuration File. Command to create a new file:

sudo nano /etc/apache2/sites-available/hubspot.YourDomain.com.conf

6. Add VirtualHost Configuration copying the following configuration into the file. Adjust paths as needed:
   (ServerAlias allows access via www.hubspot.YourDomain.com as well.)

<VirtualHost *:80>
    ServerName hubspot.YourDomain.com
    ServerAlias www.hubspot.YourDomain.com
    DocumentRoot /var/www/hubspot.YourDomain.com

    <Directory /var/www/hubspot.YourDomain.com>
        Options Indexes FollowSymLinks
        AllowOverride All
        Require all granted
    </Directory>

    ErrorLog ${APACHE_LOG_DIR}/hubspot.YourDomain.com_error.log
    CustomLog ${APACHE_LOG_DIR}/hubspot.YourDomain.com_access.log combined
</VirtualHost>

7. Run the following commands to enable the configuration and reload Apache:

sudo a2ensite hubspot.YourDomain.com.conf
sudo systemctl reload apache2

8. Verify that Apache’s configuration is correct. If you see “Syntax OK”, your configuration is good to go.

sudo apachectl configtest

9. After completing the virtual host setup, proceed with Certbot to enable HTTPS. If this operation fails just wait some minutes and try again because DNS propagation for the subdomain can take some time.

sudo certbot --apache -d hubspot.YourDomain.com

How to Install Curl

1. Update the package lists:

sudo apt update

2. Check the PHP version:

php -v

3. Install the curl extension for your PHP version (e.g., PHP 8.2):

sudo apt install php8.2-curl

How to Copy Connector Files

1. Create file index.php executing this command:

nano /var/www/hubspot.YourDomain.com/index.php

2. In this file copy the source code from:
   https://github.com/audoxcl/Power-BI-HubSpot-Connector/blob/main/index.php
3. Save the file
4. Visit https://hubspot.YourDomain.com in your browser to confirm that HTTPS is working, you should see the message:
   {“error_code”:”401″,”error_description”:”Unauthorized”}
   This response is expected because authentication credentials were not provided. This step verifies that the connector is running at the specified URL.

Now you are ready to connect Power BI to HubSpot and create amazing reports.