CloverETL is among the most advanced tools on the market. https://www.etltool.com/etl-tools-comparison/
CloverETL is a Czech multiplatform product from Javlin company, developed in Java and integrated into the Eclipse environment. The CloverGUI user interface supports users in designing ETL processes including data integration, transformation and migration. CloverETL can handle both structured and unstructured data. It can be run as a standalone application or as a part of a third party software system.
“Data preparation usually takes up to 80% of the whole project duration. Thanks to CloverETL this time can be dramatically reduced. Broad choice of components available in the tool eliminates the necessity of development of complex code and for its time consuming testing. CloverETL allows us to provide complex solutions in high quality and short time.”Martin Veselý,
CloverETL supports fixed-width data as well as data with separators. Various separators are supported even in a single data file. It means that loading data from a text file, API, JSON or a database is easy. CloverETL is linguistically gifted, it supports all character sets and text conversion from one character set to another.
CloverETL supports all databases with existing JDBC driver. Native support for Derby, Firebird, PostgreSQL, MS SQL, Oracle, MySQL, SQLite, Informix and DB2 databases is implemented.
Component is as an object that performs a specific activity, e.g. conversion of measurement units. There are more than 120 components implemented in CloverGUI out of the box and users can also modify them or add new components.
Execution graph is a set of components in defined order of execution. Graphs and components can be processed in parallel which shortens the data processing time significantly.
„CloverETL is a product of Czech company Javlin. We have very positive experience with them. They are always ready to help and that is a great advantage for us and for our customers.“Martin Sakala,