JasperSoft, a maker of open-source business intelligence tools, unveils software for extracting data from multiple sources and loading it into a BI data warehouse
JasperSoft, a maker of open-source business intelligence tools, on Tuesday unveiled software for extracting data from multiple sources and loading it into a BI data warehouse.
JasperETL, which stands for extract, transform and load, was developed with Talend, a provider of open-source data integration tools. The new product adds data management capabilities to the JasperSoft BI Suite, which includes server software, analytics and reporting. ETL tools are used to extract data from multiple sources, transform it into a format to meet business needs, and then load it into a data warehouse.
Key components and features of the JasperETL include a job designer that provides a graphical editor and functional view of the ETL process, and a transformation mapper that provides a view of data mappings and transformations. In addition, the tool provides real-time debugging throughout the transformation process, and a business modeler that provides a non-technical graphical view of the business information workflow. Metadata configuration wizards are also available to configure heterogeneous data sources and complex file formats, including positional, delimited, CSV, RegExp, XML, and LDIF data.
The open-source edition of JasperETL is available immediately for free download and use under the GPL license through the JasperForge.org community Web site. A professional version is scheduled to ship in the spring, and is scheduled to include a shared metadata repository that enables team development of data integration projects. Technical support and professional services are available for both editions.
The Agile ArchiveWhen it comes to managing data, donít look at backup and archiving systems as burdens and cost centers. A well-designed archive can enhance data protection and restores, ease search and e-discovery efforts, and save money by intelligently moving data from expensive primary storage systems.
2014 Analytics, BI, and Information Management SurveyITís tried for years to simplify data analytics and business intelligence efforts. Have visual analysis tools and Hadoop and NoSQL databases helped? Respondents to our 2014 InformationWeek Analytics, Business Intelligence, and Information Management Survey have a mixed outlook.