Yara Italy
Projet Scope
Yara Ferrara and Ravenna wanted to modify the logistics handling for loading of both wet and dry cargo. The main purpose was to remove manual procedures and streamline the loading process.
The software core used is eLISA (Electronic Logistics Information Systems Automation). eLISA is an open system, and therefore a maximum of information is stored in Oracle tables of the Yara ALS system. This gives Yara the maximum access and control over the data to be used. ALS is a proprietary system of Yara Ferrara and Ravenna and is handling the orders with the related logistical actions. The eLISA Server communicates as an Oracle client with the ALS system. ALS communicates with the Enterprise Resource Planning system SAP.
Main Concept
- All registration and weighing terminals are multilingual (Italian, English, French, German, Hungarian, Spanish, Bulgarian and Romanian).
- The database running on the eLisa Server is an Oracle 10G Express database. The link between the eLisa Server and the ALS System is done by calling PL/SQL Stored procedures that are defined in the ALS System. Therefore, there is a database link mbetween the two Oracle Databases (eLisa’s and ALS’ database)
Screenshots
Registration Terminal
Weighing bridge
Management Web Site
Technologies
- DotNet Framework 2.0 and 3.5
- HMI with DotNet 2.0 (compatibility with XPe)
- eLisa Server Background in DotNet 3.5
- eLisa Web Management in DotNet 3.5