Jaspersoft ETL is a fully functional and ready-to-use ETL job designer with a wide range of data integration features. It collects and converts data from a variety of systems and puts it into data marts and warehouses that are designed for reporting and analysis, such as star or snowflake schema data marts and warehouses. It also maintains up with the performance of the industry’s best ETL tools. Database architects and operational data store managers can use JasperETL to:
- 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.