Search results

Working with Bold ETL in our Bold BI / Bold Reports

Overview

The primary objective of the Bold ETL application is to facilitate the extraction, transformation, and loading of data from diverse sources such as PostgreSQL, MSSQL, MySQL, and Apache Doris and Bold BI Data Store database. we can conveniently schedule recurring jobs to retrieve data from these sources and utilize SQL scripts for data transformation purposes.

Integrated ETL Architecture

Source

For Windows OS, Python 3.9 version is required along with Bold BI or Bold Reports for Bold ETL. 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 ETL Application In Bold BI / Bold Reports

To access the Bold ETL site, please click on the “BoldETL” icon displayed on the page.

This action will open the site in a new tab. In the Bold BI Server page, the icon can be found under the working-with-etl section as shown in the image.

Source

Similarly, in the Bold Reports Server page, the icon is located under the same section as depicted in the image.

Source

Upon clicking the icon, you will be redirected to the Bold ETL site homepage, as illustrated in the image

Source

IMPORTANT: The Bold BI, Bold Reports, and Bold ETL applications are seamlessly integrated with our Identity Provider (IdP), allowing users to access them using a single set of login credentials.

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

For more details on working with ETL, click here.

Data Store

Working with Projects

Transformation and Preview

Scheduling ETL Jobs