Jaspersoft ETL is a complete and ready-to-run ETL job designer with an extensive set of data integration capabilities. It consistently and accurately extracts and transforms data from multiple systems and loads it into data stores optimized for reporting and analysis such as star or snowflake schema data marts and warehouses. And it easily keeps pace with the performance of other leading ETL tools. With JasperETL, database architects and operational data store administrators can:
Use the business modeler to access a non-technical view of the information workflow.
Display and edit the ETL process with Job Designer, a graphical editing tool.
Define complex mappings and transformations with Transformation Mapper and other transformation components.
Generate portable Perl or Java code that can be executed on any machine.
Track ETL statistics from start to finish with real-time debugging.
Allow simultaneous output from and input to multiple sources including flat files, XML files, databases, web services, POP and FTP servers with hundreds of available connectors.
Configure heterogeneous data sources and complex file formats including positional, delimited, CSV, RegExp, XML, and LDIF with metadata wizards.
Use the Activity Monitoring Console (AMC) to monitor job events (successes, failures, warnings, etc.), execution times, and data volumes.