From the Blog

An icon for a calendar

2017-05-26

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:

ETL Example: Convert Data Such as CSV to XML

OrchestrationĀ approach:

ETL Example: Convert Data Such as CSV to XML

Data Mapping is used in both the approaches for conversion:

ETL Example: Convert Data Such as CSV to XML