The University of Toulouse was established to train the professionals of tomorrow. Companies such as EADS, Airbus, EDF-GDF and Microsoft trust the University and regularly draw resources essential to their development from the graduates and the work of the university’s researchers.

 

The University of Toulouse has a student body of more than 16,000 in law, political science, economics, management, communications, mathematics and computer science and over 600 faculty and 500 administrative staff. As a government-owned institution, University of Toulouse is subject to various regulatory constraints. It must implement performance tracking solutions and be accountable for its use of public funds. And because it provides various IT resources to its students, it must also guarantee network security and identify violations of the accepted use policies.

 

University of Toulouse needed an easy-to-use dashboard - a user interface that organizes and presents information. In order to implement performance tracking dashboards, data needs to be extracted from back-end systems and loaded in an Oracle datamart. All data integration processes for this project are centralized.

 

Conversely, network security systems are highly decentralized and require the processing of a high volume of log files, alert emails, and the validation of permissions in LDAP directories. The resulting repository is built on MySQL. For performance reasons, processing of this data needs to happen close to its source, and, hence, needs to be highly decentralized. Indeed, over 300MB of compressed logs are processed every day.

 

University of Toulouse looked at the different solutions available on the market, including the tool from a traditional data integration vendor that was offering significant discounts to the French universities. Unfortunately, from experience, these discounts usually don’t last, and when the vendor’s priorities change, existing investments must then be reconsidered.

 

Beyond these issues, the product wasn’t suitable for decentralized process deployment. It was thus critical for University of Toulouse to find a suitable solution - from both the licensing and functionality standpoints.

 

The academic world is very sensitive to open source, and University of Toulouse looked at open source solutions and identified several products that were tried out. After discarding a few options – mostly open source projects without vendor backing – University of Toulouse shortlisted Talend Open Studio and Pentaho Data Integrator.

 

Talend Open Studio ended up proving to be the most suitable solution. Talend Open Studio’s code generation provides for more performance than a dedicated integration engine, which, also efficient to distribute the processes. Talend Open Studio generates industry standard code: Perl, Java and SQL. Because Perl is the system development language chosen by University of Toulouse, ramp-up time for the solution and its integration in the existing software stack are even easier.

 

In order to get an accelerated ramp up, University of Toulouse contracted Talend to provide an on-site training session and several days of expert consulting.


University of Toulouse chose Talend Open Studio based on technical criteria: the solution is the best fit for our requirements. We also had by strategic reasons: the open source model and Talend’s support and services around its solution guarantee our long-term investment.

 

University of Toulouse believes others should best utilize the tools that can enable significant cost and resource savings for their organization. A feature-rich, intuitive data integration product that exceeds the performance of existing proprietary solutions while eliminating steep licensing fees is a solution well worth it.

 

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access