ELTMaestro is a data integration tool that loads and transforms data faster than traditional ETL tools at a fraction of the cost. Its edge computing architecture allows loading data from distributed geographic locations efficiently and economically.
"We've used ELTMaestro in production for four years, and it has proved extremely reliable and cost-effective."
ELTMaestro uses an intuitive visual dataflow language where icons connected by arrows represent sources, operations, and targets of data. Spend much less time both creating queries, and waiting for them to complete.
Testing and deployment framework
ELTMaestro comes with advanced debugging and logging features to make deployment and maintenance easy.
Built-in jobs and batch scripts
ELTMaestro presents users with a hierarchy of jobs and batches which can be easily integrated into production environments.
Advanced agent security scheme
Agents are processes that communicate between the source and target machines. They keep communications private by using strong encryption.
Unlike traditional ETL tools, ELTMaestro has no engine, since it relies on the underlying Spark (Netezza, Redshift, etc.) engine. This significantly reduces ELTMaestro's footprint.
Flexible cloud or on-premises design
ELTMaestro is a complete improvement package for existing local ETL implementations, and will happily sit behind your firewall. It can also be used with cloud based solutions.
Modern data warehouse platforms allow businesses to analyze efficiently terabyte, even petabyte-sized datasets. But that capability is only useful if you can load the data into the data warehouse! ELTMaestro gives you a powerful set of tools to solve bottlenecks and move huge data volumes quickly.
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. ELTMaestro also includes fast decoders and adapters such as ASN.1 decoders for telecom.
The result: 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. To eliminate the ETL servers and make the data integration servers perform in the required role, however, some inexpensive “glue” is required. ELTMaestro is that glue. The result: ELTMaestro is an order of magnitude less expensive than the ETL systems it replaces. ELTMaestro essentially eliminates the cost of traditional ETL systems.
ELTMaestro is designed to look and feel familiar to the users of traditional ETL systems such as Informatica and DataStage. ELTMaestro users write data integration programs using an intuitive visual dataflow language where icons connected by arrows represent sources, operations, and targets of data. ELTMaestro presents users with a hierarchy of jobs and batches which can be readily integrated into production environments. ELTMaestro provides parameters to control job behavior and to pass information between jobs. ELTMaestro has debug modes and log information to help developers determine what is going wrong with their programs. The result: ELTMaestro is easy for anyone to learn and use. For users of traditional ETL systems, ELTMaestro will look and feel familiar.