Talend adds monitoring to open source ETL platform

Talend has enhanced the enterprise management of its Open Studio open source extract, transform, and load software, which it released late last year, to include a brand new monitoring tool.

The most notable new feature that Los Altos, California-base Talend has added to version 2.2 of its Open Studio software is a Activity Monitoring Console that lets users track the progress of distributed data integration jobs.

The console provides a centralized environment to collect and display statistics on remote and local data integration processes to analyze trends and pin down potential processing bottlenecks. Before, users had to manually program their own monitoring traps to send email alerts on specific jobs. The console is an optional plug-in for Open Studio and the Eclipse IDE. It can also be used standalone.

Open Studio 2.2 embeds event-driven logic to intelligently trigger data integration processes, for example, when a new record is added to the database.

There is better SOA integration, enabling users to expose and publish data integration tasks as callable web services. Other improvements in the 2.2 release center around database connectivity, with a broader set of specialized data connectors for slowly changing dimensions, including types 1,2 and 3, for Oracle, DB2, SQL Server, Sybase, MySQL, and Ingres database environments.

Open Studio now also handles stored procedures for all these databases except Sybase and natively supports Teradata and IBM System i platforms as well. Talend now offers over 150 native data connectors.

Finally Talend has updated Open Studio to bring in into step with the latest 3.3 version of the Eclipse open source development environment, which means that users can run the software on Windows Vista.

Most of the improvements we've added to Open Studio 2.2 make the software more enterprise-ready and scalable, said Yves de Montcheuil, vice president of marketing at Talend. The event-driven and web services publishing additions advance our support for real-time data integration and push our software in the realm of data services.

Open Studio has garnered over 150,000 user downloads since its general release a nearly a year ago. While its main focus is on analytic data warehousing, Talend is increasingly positioning the software as a more general purpose data integration tool that can be used in a variety of operational uses.

De Montcheuil also said the Open Studio platform is starting to prove its ability to be deployed in niche and specialized environments, highlighting a recent OEM deal the company struck with CamptoCamp, a European developer of open source geographic information systems, to provide geospatial data integration.

The OEM has resulted in a re-branded version of Open Studio called Spatial Data Integrator, which was unveiled at the Free and Open Source Software for Geospatial (FOSS4G) conference held in British Columbia, Canada last month. Talend also has partnerships with other open source BI and database providers like JasperSoft and Ingres.

• Share:
• 
• 
• 
• 
• 
• 
• 
• 
•