Rus / En
If you need any additional information, please do not hesitate to contact us.

Qulix Systems IT-Services

Home » Company » Case Studies » Java Case Studies

ERP System Development Using Opensource Technologies

Client

The client is 24 Online - one of the largest Internet service providers in Finland.

Background

24 Online is a major service provider which has a lot of different equipment like routers, wires, switches, different channels etc. With time the amount of equipment as well as amount of clients have been growing and therefore customer decided to perform automation of such processes as registration of network equipment, registration of clients and their connection profiles, management and balancing of workload for installed equipment, invoicing and payments and several other.

This ERP system is planned to be a continuous development as far as there is a lot of processes to be included.

Solution

The main issue at the start of the project was absence of any formal requirements. Customer had just intension to automate its processes as well as basic ideas about the look & feel and functions which the system should have. To be able to build efficient and cost-effective system with high ROI, one representative of Qulix Systems performed visit to customer on site to communicate closely with technical experts and business people there and to create a vision on the system required.

In the meantime 2 offsite analysts investigated existing systems in the same domain to extract useful ideas and approaches. The project was planned by iterations. During first 2 iterations complete analysis and prototyping was done and agreed with customer. Also, a comprehensive set of documentation was prepared including project Vision, set of Business Use-Cases, SAD, SRS to allow development team efficiently proceed with implementation activities.

Key Features

The system is mainly purposed for internal usage to monitor connections, system load, time spent in Internet etc.

The following modules are the major ones:

Equipment registration;
Monitoring and balancing of system load;
Monitoring of active connections;
Billing and payments.

Technical Overview

The ERP solution is a typical 3-tier web application based on J2EE platform and Spring framework. Three layers of the system are business logic, presentation layer and persistence (database) layer. Such division allowed independent work of design group and programmers in the project team.

Graphical interface is presented via JSP pages with servlets on server-side. It was also decided to use ORM in the project (Hibernate) for object-based data access. The main project focus was to use open source technologies to cut licenses costs, so such tools as PostgreeSQL, Spring, Hibernate were used.

Monitoring mechanism was implemented on the basis of SNMP protocol with usage of third-party controls for graphs drawing.

Benefits for Customer

Business value obtained through automation of in-house processes;
All customer business specifics is considered in the produced solution.
Back
You can talk to our represen-
tative via Skype right now.
Project Metrics
Duration:
 8 months
Team size:
 4-6 people
Used technologies:

JSP
Servlets
Spring framework
Hibernate
PostgreSQL
Tomcat
IBM Rational ClearQuest
CVS
MS Project
©2000-2009, Qulix Systems —
custom software development company