Installing Python for Bold Data Hub Services

Overview

When Install Bold Data Hub is selected during the Bold BI installation, Python will be installed automatically if no Python package is found on the machine. If Python is already installed, the installer will skip this step.

where python

If Python is not installed, follow the steps below,

Step 1: Download and Install Python

• Python 3.11.5 (recommended for security fixes): Download here

Install the downloaded package on your system.

Step 2: Update Bold BI Configuration

• After installation, update the Python path in the following configuration file:

  {Deployed Location}\BoldServices\etl\etlservice\appsettings.json

  

• For example, if Python is installed within the Bold BI location:

   "PythonPath": "../../Python311"
  

Step 3: Verify pip Installation

• Ensure pip is available at:

    Python311/Scripts/pip.exe
  

• If pip is not installed:

  • Download the attached get-pip.py file.

  • Place it in the Python installation folder (e.g., {DeployedLocation}:\BoldServices\Python311).

  • Open Command Prompt in that folder and run the below script: (pip file is attached in the article below)

      python get-pip.py
    

Step 4: Install Required Python Packages

• Once pip is installed, navigate to the Scripts folder and run the following commands to upgrade pip and install the required Python packages:

  {DeployedLocation}:\BoldServices\Python311\Scripts\pip.exe install
  {DeployedLocation}:\BoldServices\Python311\Scripts\pip.exe install duckdb===1.1.2 dlt===0.5.4 pymysql pyodbc pg8000 poetry pandas sqlalchemy “dlt[filesystem]” pymongo pymssql pyodbc elasticsearch

Step 5: Restart IIS

After installing the packages, restart application service.

Additional Reference:

• Bold Data Hub