Database Management

LN data is stored in database tables. LN supports several Relational Database Management Systems (RDBMSs). To access a database, the LN users must be authorized to access the RDBMS.

  • Database information
    You must specify database information for each database type used by LN. During setup you also must create a database definition and assign tables to it.
  • Remote databases
    The client/server architecture as supported by Tools enables the user to work with several database types. These databases can be distributed over one or multiple systems. A configuration where databases are distributed over multiple systems is called a remote database configuration.
  • Table sharing
    In an LN installation with multiple companies, you can require two or more companies to share tables to meet a particular business requirement. For example, if several of your companies purchase items from the same suppliers, these companies can share the business-partner table.
  • Database administration
    The Database Administrator (DBA) module is used by the database administrator to create, maintain, and view links between LN users and database users, database groups, and the tables and indexes repository in the databases.