ELTMaestro for AWS Redshift, Snowflake, Yellowbrick, IBM Netezza, and other platforms is a data integration tool that loads and transforms data more efficiently than traditional ETL tools, with a smaller footprint, at a fraction of the cost.
"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.
Bottlenecks in data integration happen when data lands to disk or is transferred across a network. ELTMaestro eliminates an entire server from the series of machines that data passes through on its way from source to target and will confer a significant performance advantage. This is all the more true when the machine that is eliminated (the ETL server) is resource-bound relative to the machine that replaces it (the target data integration server – generally an MPP purpose-built platform or cluster). The result: ELT architectures have significant speed advantages over traditional architectures.
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.