Introduction 6 2. Overview 7 3. System Architecture 11 3. User Interface Tier. Application Tier. Database Tier.
|Published (Last):||16 August 2004|
|PDF File Size:||20.85 Mb|
|ePub File Size:||14.61 Mb|
|Price:||Free* [*Free Regsitration Required]|
Introduction 6 2. Overview 7 3. System Architecture 11 3. User Interface Tier. Application Tier. Database Tier. Software Architecture 16 4. Version Management 18 5. Derivation of Package Versions. Package Combinations. Companies and Users 22 7.
Database Handling 24 7. Database tables. Primary keys. Transaction handling. Delayed locks. Table locks.
Application locks. Table naming convention. Column naming convention. Data type mapping. The ODBC interface. Programming 32 8. Data types. Programming Statements. Report scripts. Database integrity checks. Business methods. UI function calls.
DAL hooks. Enterprise Modeler 39 9. Roles and Authorization Types. Consistency rule. Parameter-setting rule. Transformation rule. Enterprise-structure modeling. Glossary 43 B. About the instructor The default client of a user must have the same package combination as this user. BaanERP three-tier architecture. Application and Database Server on the same computer.
Packages, modules, sessions. Version management in BaanERP. Users and Developers. BaanERP packages. The most important ones are emphasized. Enterprise resource planning ERP systems are generic and comprehensive business soft- ware systems based on a distributed computing platform including one or more database management systems.
They combine a global enterprise information system covering large parts of the information needs of an enterprise with a large number of application programs implementing all kinds of business processes that are vital for the operation of an enterprise. The goal of this tutorial is to present the information technology of BaanERP, as a representative of the ERP system paradigm, from a computer science rather than from a business management perspective, relating it to established database and distributed systems concepts and techniques.
A critical assessment of BaanERP will point out some of its merits and weaknesses. The tutorial will help attendees to understand the potential of ERP system technology in general, and of Baan ERP system technology in particular, and how it relates to their own research and development work. Terminology In Table 2. Application Administration : users, clients, database management, SQL queries, etc. User interface customization : version management, menus, forms, reports, sessions, etc.
Some application administration functions, such as Software Installation, Device Manage- mentor Audit Management, are only of interest to Baan system administrators. User Management The name of a Baan user is normally the same as the system login name.
The client determines the data set on which the user will work. See Figure 2. Text Management Internal texts that have to be edited with the built-in rather old fashioned text editor, and that are being stored line by line and optionally by language , are used for delivery conditions, item descriptions, invoice footers, and the like. The resulting answer set is displayed on screen or printed on paper by means of a Baan report.
Figure 2. This includes: Menus consist of a list of choice options leading to application programs or to submenus. They are used to create complex documents like bills of lading or invoices, and also for displaying or printing the results of SQL queries. Messages and Questions are named short texts used to display messages or ask ques- tions during the execution of an application program.
BaanERP programming consists of version management and of the creation and main- tenance of program scripts. Version management includes: 1. Libraries allow to maintain re-usable function and procedure code. BaanERP supports a three-tier architecture consisting of a user interface tier, an ap- plication tier, and a database tier. The user interface tier provides presentation and input services for user interaction. The application tier consists of the BaanERP appli- cation server and the application programs.
Figure 1 depicts the BaanERP architecture. The emphasis of this document is the BaanERP database driver. After the database server retrieves the requested information, the database driver then passes the data back to the BaanERP application server. User Interface Client "BW". Application Server Application "bshell" Programs. Together, the application programs and the application server provide much of the functionality of BaanERP. The application programs include the compiled BaanERP applications and the data dictionary.
The BaanERP application server schedules and runs the application programs, sends and receives information to and from the user interface server, and initiates an instance of the database driver as necessary for communication with the database server. If a BaanERP installation stores data tables in multiple databases, the application server must start one instance of the database driver for each database with which it must communicate.
Throughout the remainder of this document, it is referred to as the BaanERP application server or the application server. The database driver provides a common interface between the BaanERP application server and the database server. Communication between the application server and the database driver is the same, no matter which RDBMS product is used as the database server.
Communication between the database driver and the database server is tai- lored to the RDBMS being used. The ow of data through the system is described below. When a user performs an operation at a GUI workstation, the user interface server interprets the input and sends the information to the BaanERP application virtual ma- chine. Based on the information it receives, the application server causes the appropriate application object to be executed.
When a running application object requires information that is stored in the database, the application server sends the request to the database driver. If there is no database driver running, or if the running database driver in- stances are communicating with a database server other than the one storing the needed data, the application server starts a new instance of the database driver.
The applica- tion server parses the BaanERP SQL database query it receives from the application object and sends an internal representation of the query to the database driver. The internal representation of the query that the database driver receives is still RDBMS independent. Any error conditions are caught and handled by the database driver. The database driver then returns the data and status information to the application server, where it provides the information to the application that re- quested it.
The application server may also send a message to the user interface server, which displays an appropriate message on the users workstation. In standalone mode, an end user can work from the host machine or from a thin client machine, such as an X-Terminal running BI. An instance of the application server and at least one instance of the database driver is started for each user. All users have access to the same application programs and database servers.
When two machines are available to be used as servers, the application tier is placed on one server, while the database driver and the database server are placed on another.
Menu Session Table. Modules Business functions are grouped in modules with a three-character code.
FAQ - Sponsors - Staff. Remember me. Create new account Request new password. Older polls. BaaN manuals. Thread is clear! Are there places to find this holy manuals?
The Baan Corporation was created by Jan Baan in in Barneveld , Netherlands to provide financial and administrative consulting services. The Baan company focused on the creation of enterprise resource planning ERP software. Baan rose in popularity during the early nineties. Baan 4GL and Tools is still considered to be one of the most efficient and productive database application development platforms. Baan became a real threat to market leader SAP after winning a large Boeing deal in Several large consulting firms around the world partnered to implement Baan IV for multi-national companies.
Baan , BaanSupport. In the year , I started working on Baan IV b2. One of my first end-to-end implementation was a small industrial value manufacturing company called Virgo Engineers Ltd, being fresh out of IIT Bombay, I was full of enthusiasm. Baan became one of the best thing I had learned ever. Virgo Baan Implementation lasted for more than 15 months, during the same, we also worked on few other implementations like Dana Spicer, Thermax Chemicals and so on. Baan is one of those companies, where product strength surpassed the strength of company, Baan company went through troubled times for several years and hence was sold multiple times, but anybody who has worked or consulted on Baan can vouch for its strength.