The key idea of CloverETL is that even very complex tasks can be described by a workflow. In CloverETL, we call these jobflows. Jobflows split into smaller operation units called transformation graphs, which are built using generic versatile components such as file reader, sorter, aggregator, etc.
In order to process a data set, multiple components are interconnected to form a data flow (a graph), which represents a data transformation job. For example, the task of reading the content of a Excel file, sorting it based on a certain column, filtering out all non US customers, and writing the result into database tables is called a CloverETL graph (a job) which consists of four components: an Excel reader, a Filter, a Sorter, and a component called DBOutputTable.
Transformation graphs can be combined into a jobflow defining the sequence in which the individual graphs are executed and, for example, what to do in case error occurs. We call this an orchestration.
Fundamental Aspects of CloverETL:
Have you ever received an Excel file full of raw data? Trying to dig through all of the fields and make sense out of them is not easy.
CloverETL provides a rich set of transformation tools for you to take a raw dataset, convert it to an organized structure, and provide the basis for a meaningful report.
Discover the product yourself.
A 45-day trial is available for use
Data integration software and ETL tools provided by the CloverETL platform offer solutions for such data management tasks such as data integration, data migration, or data quality. CloverETL is a vital part of such enterprise solutions as data warehousing, business intelligence (BI) or master data management (MDM). CloverETL’s flagship applications are CloverETL Designer and Server. CloverETL Designer is a visual data transformation designer that helps define data flows and transformations in a quick, visual, and intuitive way. CloverETL Server is an enterprise ETL runtime environment. It offers a set of enterprise features such as automation, monitoring, user management, real-time ETL, clustering, or cloud data integration.