Home Information PDF Documents EULANDA Handbooks Training Book's corner Download Contact us Table of Contents About us

Glossary

Password needed Newsgroup

Remote Support system

Technology

Back | Level back

 

Many new technologies where used, developing the EULANDA® ERP. Among other these are our unique business-logic,  procedure linearization, the integrated query processor and the iFrame technique. Connection to the SQL Server is made thru the very quick OLEDB. EULANDA® ERP does not simply use the SQL Server to store data but executes many complex procedures directly in the server, using it's own API's. In version 2.0 we introduced the iScript technique which allows to newly combine existing functions and react more direct to any event occurring. 

 

Extendable

The modular system of the EULANDA® ERP allows retrofitting with client specific extensions without the need to update these extensions with every new program release. Some of these are offered directly from CN Software such as the Multi store capability, multi currency handling, multi client support and extensive data interpretations. These Plug-Ins use software interfaces which are available to external developers and solution partners as well thru the EULANDA®-API.

 

Business logic

All processes within the EULANDA® ERP are controlled by one unit – the business logic. Complex operations are wrapped in individual units  This technique allows event controlled data processing and at the same time, thru process linearization a unique user guidance.

 

Procedure Linearization

In normal event controlled programs, the user tents to quickly loose control over the workflow. EULANDA® ERP uses it's Business Logic to completely control and finalize each entry process. Further on, the path of the actual segment is shown as to enhance the user's orientation. A context related help system is available at all times showing the actual function segment.

 

Integrated Query Processor

The data entry screens are used at the same time to query the data . You can combine  any data field logically (AND / OR). The search mode  within the individual fields can be configured according to specific needs. This allows the search from left to right (*TEXT), right to left (TEXT*) or full text search (*TEXT*).  Along with these functions **TEXT allows a full text search over all available fields in the respective table. EULANDA® ERP has been designed to handle large amount of data (> 1 Mio. data records). The user may limit the amount of data returned by his query.

 

iFrame-Technique

Similar to the business-logic, iFrame uses reusable screens. For example a complete address has name, street, city and ZIP. Thos format is used in offers, orders and invoices. iFrame allows to define these areas once reuse them many times. Changes to the basic forms are cloned and therefore done quickly, thus making EULANDA® ERP easy to maintain and the user always finds the same forms in similar situations.

 

iScript-Technique

iScript-allows to create new function within EULANDA® ERP and integrate external systems, which support this technique as well.

EULANDA® ERP provides objects with powerful methods. The software supports various script languages such as VBScript and JScript to address these objects internally and  influence the program flow.

Especially for the Solution-Partners iScript offers extended possibilities to further adapt EULANDA® ERP to their specific operation procedures.

 

Program Concept

EULANDA® ERP accesses the database via T-SQL. Basically the program sends queries to the database and receives a result set of data in return. That implies, that in the broadest sense, a database itself functions as a program. This is archived thru the combination of the SQL Server on one side and the EULANDA® ERP on the other side. EULANDA® ERP never accesses the data directly but sends queries to the database server, receives the result from the server and returns this data to the screen. EULANDA® ERP exclusively uses the Microsoft® SQL Server. Other SQL Server can not be used, since the differences are too wide.
Due to the separation between front end (EULANDA® ERP) and database server, very large databases can be handled. The server can be installed on any machine dimensioned according to specific needs and the Front End may reside on any other standard PC. Branch handling on slow connections such as ISDN and or via Internet can be handled on the same way, using such a two layer (Client / Server) model.
Contrary to desktop databases such as dBase, Paradox and Access, SQL Server works quantity orientated. A SQL Server has no problem in changing all data rows in one single process, if they match the query. Desktop databases however need to view, evaluate and then alter every individual data row, as the decision has to be made by the program, hence on the PC which initiated the query. This requires a broad bandwidth, because all data has to transmitted back and forth between the PC holding the data and the one running the querying program.