Search results
Suggest a FeaturePDF

Working with Bold Data Hub in Bold Reports

Overview

The primary objective of the Bold Data Hub application is to facilitate the extraction, transformation, and loading of data from diverse sources such as PostgreSQL, MSSQL, MySQL, Oracle, Google BigQuery, Snowflake, and Apache Doris databases. We can conveniently schedule recurring jobs to retrieve data from these sources and utilize SQL scripts for data transformation purposes.

Integrated Bold Data Hub Architecture

Source

For Windows OS, Python 3.9 version is required along with Bold Reports for Bold Data Hub. If Python 3.9 version is already installed, please specify the Python path in {Drive}:\BoldServices\etl\etlservice\appsettings.json and restart the app in IIS server.

"PythonPath": "<Drive>:\\BoldServices\\Python39"

Using the Bold Data Hub Application In Bold Reports

To access the Data Hub site, click the Data Hub icon displayed on the page. The site opens in a new tab, displaying the homepage as shown in the image.

Source Source

Important: Bold Reports and Bold Data Hub applications can be accessed using the same login credentials, as they are integrated with our Identity Provider (IdP).

This section explains how to work with projects, schedule jobs, and create Bold Reports data sources.

For more details on working with Bold Data Hub, click here for further information.

Data Store

Working with Projects

Transformation and Preview

Scheduling ETL Jobs