ETL Example: Convert Data Such as CSV to XML
For converting any data using ETL covers a process of how the data is loaded from the source system to the data warehouse. Similarly, you can use the ETL to convert any data to any output format such as CSV to XML.
This blog covers two approaches of implementing the conversion setup:
- Using Data Interface to define the Source, Target, and Mapping (conversion) rules
- Using Process Designer and building a custom orchestration to convert data
You would also see how to attach a trigger such as File Event to both the approaches so that the data conversion occurs automatically whenever new source files are dropped into the source folder:
Date Interface approach:
Data Mapping is used in both the approaches for conversion: