The Directorate for Maritime Affairs improves data quality and business intelligence with Talend

Quality controls directly integrated into data flows, data consolidated and distributed to different departments, and streamlined deployments help the Directorate for Maritime Affairs and its partners to optimize business intelligence
Suresnes (France)

Talend, a global open source software leader, today announced that the Directorate for Maritime Affairs (DAM) of the Ministry of Ecology had deployed Talend Enterprise Data Integration to create a data warehouse for business intelligence populated by heterogeneous data. It is used to produce a lot of data via its business intelligence information system: statistics on commercial vessels (e.g., number of merchant ships or controlled fishing vessels), recreational permits or the activities of seafarers. The consolidation of this data allowed to complete dashboards that support the decision-making of the Directorate for Maritime Affairs (e.g. statistics on maritime employment or monitoring of vessel activity). They were also distributed to the services of the Interregional Sea Departments, the Sea and Coast Commissions, and other administrations according to the specific or specialized needs.

Our goal was to create a data warehouse (based on Sybase IQ) from heterogeneous sources – 14 in total, each of which are based on different data base technology, particularly Oracle – in order to apply various consistency and quality controls,” explains Michel Lollichon, Project Director at the Directorate for Maritime Affairs. “This data warehouse was constructed based on several shared repositories – the vessel, the parties involved (sailor, owner, shellfish industry, etc.), the profession and activity of the sailor. While the data volumes to process are not necessarily significant, the data – very dispersed – must be consolidated to obtain a cross-disciplinary vision and improve business intelligence.

At the same time, the Directorate transferred numerous batch processing series for the consolidation, update, export and distribution of data to Talend, which were previously based on COBOL. The objective was to streamline this processing on which data exchanges with external partners are based (such as the National Establishment for Disabled Seamen, which is the social security regime for seamen). In all, six data exchange interfaces were developed to facilitate exchanges with partners who have different information systems.  Talend enables the use of Web Services to send or receive data in automatic exchanges.

Today, most of this processing is in production, the first of which were implemented in 2009. The statistics are returned via an information portal based on SpagoBI, which should eventually grant access to approximately 1,000 users of the Ministry of Ecology.

The Directorate for Maritime Affairs stresses how easy the Talend solution is to use, in addition to the wealth of components inherently offered. Meanwhile, the Directorate for Maritime Affairs appreciates the portability of the Talend solution.  Lastly, the Directorate for Maritime Affairs appreciates the clear and easy-to-create documentation which enabled the deployment of good practices. This contributed to making activities sustainable by facilitating knowledge and skill transfers.

The Talend solution meets all our needs and, above all else, makes us independent. We are often surprised by the wealth of the new versions, allowing us to plan future extensions, such as interapplication business data exchanges. With Talend, we can broaden the spectrum of analysis of our department and our partners,” concludes Michel Lollichon.

About the Directorate for Maritime Affairs (DAM)

The Directorate-General for Infrastructure, Transportation and the Sea (DGITM) of the French Ministry of Ecology, Sustainable Development and Energy is responsible for all matters relating to land and sea transportation (except for road safety) and airport planning. It is composed of three departments, including the Directorate for Maritime Affairs, which is responsible for maritime safety, maritime training and education, monitoring of seafarers, development of the national flag, recreational policies and nautical activities.

A constant source of important information and applications ​​since its inception, the Sub-Directorate for Maritime Information Systems (SDSI) is a service of the Directorate for Maritime Affairs, responsible for creating and maintaining IT applications and providing guidance for other services. It includes about 50 individuals whose duties range from project management assistance to IT project management and providing user support.