Extracting and loading large tables from OLTP databases such as Oracle can take days using conventional tools. ELTMaestro/Corelli parallel extraction and load cuts that time to a few hours which also includes fast decoders such as for ASN.1 encoded data.
Our customers have saved millions of dollars, and are able to put data in their warehouses that was previously impractical to load.
Traditional ETL systems contain powerful engines that implement efficient joins, sorts, filters and other operations on large datasets. To work well, these systems require powerful dedicated servers. These servers become sources for data integration servers – which, ironically, are even more powerful servers that are more capable of performing the joins, sorts, filters, and other large dataset operations than the ETL servers are. The traditional ETL systems have become, for historical reasons, costly duplications of effort.
ELTMaestro is an order of magnitude less expensive than the ETL systems it replaces by eliminating the cost of traditional ETL systems.
Our software is designed to look and feel familiar to the users of traditional ETL systems such as Informatica and DataStage. It users write data integration programs using an intuitive visual dataflow language where icons connected by arrows represent sources, operations, and targets of data. It presents users with a hierarchy of jobs and batches which can be readily integrated into production environments. It provides parameters to control job behavior and to pass information between jobs. It has debug modes and log information to help developers determine what is going wrong with their programs.
ELTMaestro is easy for anyone to learn and use.
Clay Wolfe: Director, Marketing Analytics, ATNI