Background

Exea Comunicación developed Distribuciones Suner website, adding product information to it, as well as a customer reserved area in which pricing information can be browsed and orders placed.

For this system to be fully functional, data shown on the website must be the same as the ones into Suner's ERP application.

The system

Beta Lyrae creates then a synchronisation tool which obtains the necessary data from Suner ERP database, actually Microsoft SQL Server, and sends them over to the Internet server, where the website is hosted. Once data have been stored into the server, Linux shell scripts update the uploaded information to the database, thus the most recent data being shown on the website.

Technical specifications

The client system, installed on Suner computers, was developed using Java technology, taking advantage of JDBC (Java Database Connection). Shell scripts were deployed on the Internet server, which in an automated way, update the information uploaded by the client.

References

Distribuciones Suner: http://www.suner.es/

Exea Comunicación: http://www.exea.net/

more success stories