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
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.
Similarly, in the Bold Reports Server page, the icon is located under the same section as depicted in the image.
Upon clicking the icon, you will be redirected to the Bold ETL site homepage, as illustrated in the image
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.