Place a sequence of components into the transformation graph and connect them with edges that channel data from one component to another.
Choose from a variety of highly configurable components to build your transformations.
Easily manage your assests like input data, shared metadata, connections, scripts, Java sources in CloverETL projects either in your local workspace or remotely on the CloverETL Server.
Metadata in CloverETL describes how data looks. You define fields and properties such as type, precision, format, etc. Metadata also helps CloverETL to parse data from text files, Excel spreadsheets and other sources.
Shared metadata is a great tool to keep large projects clean and organized.
You can define debugging edges during development and then watch and filter real data coming through the edges almost in real time.
For simple mappings use the drag & drop transform dialog, which let's you even define simple expressions without any coding.
Use full drag&drop shortcuts in the interface help you accelerate the transformation development.
The CloverETL Transformation Language (CTL) is a simple, data-oriented programming language that you can use to define business logic for your data transformations. It offers direct access to data and functions.
Syntax highlighting, code assist and automatic code generation make it very easy to start with.
The Designer comes with native Java support. So whenever you need to inject a complex piece of code into the transformation, simply create a few Java classes and use the right interface for a particular component.
The Designer on a Desktop
The Designer with the Server
|The Designer can be used as a standalone data integration tool for manually driven processes and small amounts of data.||Combined with the Server, the Designer brings visual design and a debugging and management tool to enterprise scale projects.|
|Manage local projects||Manage local and Server remote projects (sandboxes)|
|Create and edit transformation graphs||Create and edit local and remote transformations|
|Run and debug local transformations||Run and debug local and Server remote transformations|
|Deploy local projects to the Server|
|Run distributed Cluster transformations|
|Create, edit and run Server jobflows|
Do you use programmers or database administrators to prepare your data? Most organizations still do and, as a result, waste huge amounts of time, effort and money. Not only are these methods prone to error, but they are also difficult to maintain and adjust to meet your changing data formats and needs.
The CloverETL Designer is a superb desktop tool for managing all your ad-hoc data transformations. It's the easiest and most flexible ETL software tool available today. And when you need even more power, you can smoothly upgrade to our Server or Cluster editions.
The Community Edition is a free, limited version of the Designer.
It offers basic functionality for entry-level user and small scale projects. Use the Community Edition to do a one-time data migration or start a production project.
|Read and write flat files|
|Connect to databases MySQL, PostgreSQL, Oracle, MS SQL, SQLite, Derby|
|Read XML files|
|Read and write basic Excel files|
|Reformat, Sort, Join, Dedup and Aggregate|
|Connect to basic HTTP Web Services|
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.