Monday 5 January 2009
The Big Oxford Computer Co. Ltd.

Ports of Convenience Database Integration Case Study - ITF

Overview

The International Transport Workers' Federation (ITF) is an international trade union federation of transport workers' unions. Membership of the ITF includes 654 unions representing 4,500,000 transport workers inĀ 148 countries worldwide.

Objective

The International Transport Workers' Federation (ITF) launched a worldwide 'Ports of Convenience' (POC) campaign at the ITF's 41st Congress in Durban in August 2006, to ensure that decent standards apply across the world's ports.

The ITF provided funds to affiliate 'Maritime Union of Australia' to develop a database for the POC that is hosted in Australia.

The ITF wanted to provide access to the database for users already utilising the existing 'My ITF' secure extranet facility on the main ITF website.

Solution

BOCC developed a mechanism to seamlessly pass the existing extranet login credentials to the POC database in order for users to gain access.

BOCC created an export of the user list from the My ITF extranet system that is imported into the POC users database as a regular scheduled process. BOCC liaised with the POC developers to agree the method of passing the login credentials from the extranet to the POC database.

The database information is integrated with the existing multilingual website, which is facilitated by a customised version of BOCC's content management system (CMS), tailored to the ITF's requirements.

TechnologiesĀ 

The system utilises:

  • Microsoft SQL Server 2005
  • Adobe ColdFusion
  • Microsoft Internet Information ServerĀ 
  • Hosting on a fully managed dedicated web server at BOCC
  • SSL (Secure Server Certificate)
  • Extensible HyperText Markup Language 1.0
  • Cascading Style Sheets (CSS) 2.0 compliant