Your idea can become a change
You’ve been trying to make.
Let’s give it and you all possible
chances of success
The tool identified for extracting, transforming and loading (ETL) data from different data sources is Talend data studio. The data from MYSQL were extracted using Talend data studio. The data from multiple MySQL database tables were joined and transformed so that no additional calculations were to be made to generate the Tableau reports. Log files were generated by the Talend job to view the last run date, number of data rows processed and status message. Capability of synchronization of the data with the source database was made by checking upon the last run date from the destination table. The data has been loaded to PostgreSQL with the required calculated fields and Tableau dashboard were created.
The reports are extracted every day at midnight in the selected time zone, and is loaded in PostgreSQL with the help of the ETL tool Talend data studio.Data from PostgreSQL is connected with Tableau to create required dashboards.