Master thesis : Creation of a domain specific language for an Extract-Transform-Load system

Abstract

Organisations use different systems with different structures to run their day to day activities. The number and variety of these systems is increasing and this led to some concerns such as in- compatibilities. In response to that, a technology called Extract-Transform-Load (ETL) is used. It allows organisations to interconnect and manage their different systems. The easiest way to build ETLs is to use ETL tools. ETL tools are mainly used by developers and IT staff because they require some programming knowledge. This work aims at creating a Domain Specific Language (DSL) that makes the creation of ETLs easier. By doing so, the ETL technology could be used by a larger public having little to no programming experience. The DSL will use ETL.NET framework which allows to build ETLs into any .NET application. A transpiler will translate code from the DSL that we created into ETL.NET code. This thesis will first give a better overview about ETL and ETL tools. Then, It will detail how the DSL was created, as well as its implementation. Then, it will confront the DSL to the literature to identify the completeness of the language and give some guidelines for further development.