Data Integration Software | CloverETL Data Join Tools

CloverETL Overview

For more details and videos take a look at the Quick Start Guide →

Designer UI

Anatomy of a Graph

Read & Write Data

Transform & Modify

Merge & Join

Other Actions

Clover Script

Performance

	Hash Join : very fast join. The main join is loaded into memory.			Merge Join : less fast than Hash Join, but all data is not loaded into memory. Suitable for data merges in huge data sets.
	Approximative Join : a very specialized join, this takes two or more data sources and joins them on the "Levenshtein" distance, which is a value that specifies how closely two strings are matched.			Database Join : joins two or more database tables on a common key.
	Lookup Join : uses ultra fast Lookup tables for persistent file or memory based lookup joins.			Relational Join : this receives sorted data and determines a match based on the <, <=, >, >= operators.

Joining Data

Joiners take two or more data streams and join that data on a common key. Clover offers a variety of Joiners that perform Joins rather like an SQL JOIN statement. However, Clover offers more advanced features that go beyond SQL as well as joining data from all and any data source types.

Selecting the Right Join

As you can see from the components shown above, Clover offers powerful Joiners that allow you to merge data in many different ways. You can choose between raw speed, which requires significantly more memory resources, or huge data volumes, which is more gentle on your system resources. Clover also offers some advanced and powerful Joins such as Approximative, Relational and Lookup Joins.

Seeing Joins in a Graph

Take a look at the image on the right. This shows a graph where data is read and then joined from three data sources (customer transactions, customer database and an Internet based XML file containing currency exchange rate data). Look for the components labeled "Match Customers" and "Convert Currency" to see two Joins in action.

More Graph stories

We have a range of sample data transformations that show some typical scenarios. Sample Transformations →

A full Clover Graph (click image)

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.