Liquidation Check Example of CloverETL Data Integration Software

Sample Data Transformation Graphs.

Clover packs so many punches, it is sometimes easier to show than explain. Click on the tabs below to see some selected examples.

Data Load

Credit Cards

Web Service

Email Validation

Web Site Log

Company Checks

Click the image to enlarge it. The sample images show annotated transformation graphs.

Company Liquidation Check

We have a customer database and every week we want to match our customers with a file we receive from a 3rd party that contains a list of all companies that are in liquidation. We validate our customer company IDs and then perform the match, finally writing the output to for database tables

Invalid customer company IDs
Customers that are in liquidation
Customers that are not in liquidation
Customers where the liquidation status is unclear

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.