What is KETL™? The KETL™ ETL tool allows companies to manage complex manipulation of data while leveraging the affordability of an open source data integration platform. KETL’s flexible and production-proven extraction, transformation and loading (ETL) engine provides the foundation.
Rather than developing custom logic that is difficult to debug, monitor and maintain, KETL™ offers a metadata-driven solution that adds robustness and functionality. With support for pluggable modules, the platform allows open source and commercial companies to build upon already existing functionality.
KETL™ Features:
Scalable, platform independent ETL engine–enables complex ETL transformations to be executed in a highly efficient manner. Supports multiple CPU’s and 64-bit servers.
Job execution and scheduling manager–dependency-driven job execution model supports multiple job types, conditional exception handling, email notification and time-based scheduling. Job types fall into three categories, with support for additional executors via the KETL API.
SQL–executes pre-defined SQL statement via JDBC
XML–executes XML defined jobs
OS–executes an operating system command
XML job definition language–allows ETL jobs to be easily defined in XML, enabling the use of widely available XML authoring tools and associated support for version control systems.
Centralized repository–supports multiple KETL instances to leverage job and parameter definitions.
Performance monitoring–collects historical and active job statistics in the repository, allowing comprehensive analysis of problematic jobs.
Comprehensive data source support–supports extracting and loading of relational, flat file and XML data sources, via JDBC and proprietary database APIs.
Scheduling engine–time-based and event-driven job execution.
