Go Back

User login

Frontpage Sponsor


For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
Installation Wizard into new VRC
Manual into existing VRC
Manual into new VRC
Total votes: 38

Baanboard at LinkedIn

Reference Content

Items for 'English' (by date)
By Date  
Alphabetically By Date  


You are browsing all items of this content category sorted by date (most recent first). Note that forum posts/threads are not included here.


If you would like to search through the content then please refer to the Site Search page.


Common DBA Misconceptions
By patvdv at 23 Feb 2008 - 22:00

Common DBA Misconceptions

by Jeremiah Wilton


These articles are from the Common Oracle Misconceptions series by Jeremiah Wilton at

Copyright (c) 2001 Jeremiah Wilton


Appendix B: About the Author
By patvdv at 19 Feb 2008 - 23:54

About the instructor


Appendix A: Glossary
By patvdv at 19 Feb 2008 - 23:52


Enterprise Modeler
By patvdv at 19 Feb 2008 - 23:45

The Enterprise Modeler assists in developing a vision on:

  • How to functionally structure an organization
  • How to organize the business processes of the organization
  • How to integrate the information system with these business processes

In addition, the Enterprise Modeler can also be used to assist in the actual implementation of the Baan applications by:

  • Setting parameters in BaanERP.
  • Creating BaanERP users, based on the role and employee data of the Enterprise Modeler.
  • Creating the menus and session authorizations for users.

A reference model represents a line of business or business typology and can be built from libraries (repositories) of the following enterprise-modeler components:

  • Business control diagrams
  • Business function models
  • Business process models
  • Organization models

By patvdv at 19 Feb 2008 - 23:32


The development tools supplied by the BaanERP Tools package enable developers to program additional functionality for existing BaanERP applications or to build entirely new applications. The features provided by the development tools include:

  • The BaanERP 3GL programming language.
  • 4GL language features that enable you to add to or modify the default behaviour of sessions, reports, and the Data Access Layer.
  • Baan SQL, which enables you to retrieve database data.
  • Support for Dynamic Link Libraries (DLLs).

3GL scripts are program scripts that are either linked to sessions without forms or not linked to sessions at all. They do not have any relationship with the 4GL Engine (previously known as the Standard Program). When creating such scripts, you must specify the entire program flow, including the main function. You cannot use 4GL event sections or functions.


Database Handling
By patvdv at 19 Feb 2008 - 23:08

All of the application data used by BaanERP is stored in database tables in the underlying RDBMS. To keep the majority of the BaanERP processing independent of the RDBMS, BaanERP uses its own data dictionary. The data dictionary includes domain, schema, and referential integrity information that is stored in a database independent manner.


The BaanERP system provides a RDBMS interface, called 'database driver', to the major RDBMSs (Oracle, Informix, Sybase, DB2, and Microsoft SQL Server). The BaanERP database driver has a built-in mechanism for preserving referential integrity; it does not depend on the underlying RDBMS for maintaining referential integrity.


Companies and Users
By patvdv at 19 Feb 2008 - 22:51

BaanERP companies are defined by company number, name, currency, and a package combination that associates a specific database schema with the company.


Figure 1: Users and Developers:



Version Management
By patvdv at 19 Feb 2008 - 22:40

Complex application software systems, like ERP systems, are subject to continuous change. Both the discovery of programming errors and new technical as well as legal requirements call for modifications of the ERP system software. In addition, various parts of the standard software have to be customized for supporting country-, branch- and company-specific business processes. In order to be able to perform all these changes in a systematic way, different versions of software components (notably tables and sessions) can be maintained and configured into customized versions of a BaanERP system. Therefore, all components exist on a logical naming level and on the level of special instances or versions, like shown in Figure 1.


Figure 1: Version management in BaanERP:


Software Architecture
By patvdv at 19 Feb 2008 - 22:19

Both tables as well as application programs ('sessions') and their software components are assigned to modules grouping related business functions.


Figure 1: Packages, modules, sessions:


Business areas such as distribution, manufacturing, and finance are mapped into pro-gram packages that have a two character identification code, as listed in Table 1. The most important ones are: tc/Common, td/Distribution, ti/Manufacturing, and tf/Finance.


Table 1: BaanERP packages. The most important ones are emphasized.

System Architecture
By patvdv at 19 Feb 2008 - 22:09

BaanERP supports a three-tier architecture consisting of a user interface tier, an application tier, and a database tier. The user interface tier provides presentation and input services for user interaction. The application tier consists of the BaanERP application server and the application programs. The database tier includes the BaanERP database driver and a third party RDBMS product that acts as the database server.


All times are GMT +2. The time now is 16:55.

©2001-2017 - -