Sunopsis says it is taking a new approach to the extract, transform and load (ETL) market which involves the heavy lifting work of extracting information from production systems and squirting it into data warehouses.
Synopsis says it offers what it calls extract, load and transform (ELT) instead, with the benefit being that it harnesses the power of the database engine itself to do the transformation, instead of trying to do the transformation on the fly as with convention ETL tools.
Sunopsis claims its ELT approach is faster because target servers are more powerful than staging servers; cheaper because no staging server is required; and simpler to learn because the ELT architecture is based on standard SQL and existing RDBMS engines.
Teradata provides an extremely powerful database engine to process massive amounts of data and perform very complex calculations, said Stephen Brobst, Teradata CTO. Sunopsis’ architecture leverages this power to transform data.
Sunopsis competes primarily with the likes of Ascential Software and Informatica.
