Kettle is an interpreter of ETL procedures written in XML format. Kettle is also a good tool, with everything necessary to build even complex ETL procedures. Kettle provides a Java Script engine to fine tune the data manipulation process. Kettle is an interpreter of procedures written in XML format. These ETL capabilities are based on the Kettle project. KETL major features include support for integration of security and data management tools, proven scalability across multiple servers and CPU’s and any volume of data and no additional need for third party schedule, dependency, and notification tools.Īccording to Pentaho itself, it is a BI provider that offers ETL tools as a capability of data integration. The engine is built upon an open, multi-threaded, XML-based architecture. It is made of java oriented structure along with XML and other languages. KETL is one of the best open source tools for data warehousing. Cros Database ETL operations, import/export from/to CSV, text and XML and other formats. Database migration, interoperability with LDAP, JDBC, XML and other data sources. The features include executing scripts written in SQL, JavaScript, JEXL, Velocity. It is a very simple and easy tool for use and it is basically popular due to its ease of use. Scriptella is an open source ETL tool launched by Apache, which along with the functioning of the extracting, transforming as well as loading processes is also used in the executing java scripting. See Also: Basic Steps for Designing Big Data Architecture
0 Comments
Leave a Reply. |