Talend Data Integration
Talend Data Integration Platform is a tool with extensive data integration functionalities.
Users can develop Talend jobs visually (drag and drop) without extensive SQL knowledge. A Talend job is a type of workflow in which data undergoes certain transformations. Both ETL (Extract, Transform, Load) and ELT (Extract, Load, Transform) are supported. Within our reference architecture, Talend ensures the migration of the data to the data lake, the loading of the data warehouse and the development of the Business Vault and extras to third parties.
Talend jobscript generation
The Vaultspeed Data Vault Automation tool is able to generate Talend Jobscript (ELT) for loading the Raw Data Vault and part of the Business Data Vault. Talend job script can be loaded into Talend, where it will result in Talend jobs. The image below shows an example of a Talend job, generated by Vaultspeed, for loading a Data Vault HUB table.