Defining 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.

The database information consists of:

  • The database type(s) available on the system
  • Parameters and database copies of the database type(s)
  • The tables assigned to databases
  • Logical tables
  • Remote databases

The databases are used to store tables. You can use different database types, for example, ORACLE, Informix, and so on. Tables can also be located on a remote system in a distributed database environment.

Note

For technical details on database management and database tools refer to the Infor Enterprise Server Technical Manual.

PLACE OF BUSINESS OBJECT

Before you define the database information you must know what database type(s) are installed on your system. For each database type you can assign tables, which means you must also know which tables are present.

After defining databases, you must convert the changed data to the Run-Time Data Dictionary in the several sessions. Then you can create the tables for a company in the Create Tables (ttaad4230m000) session.

Complete the following steps to define database data. Assume that database information has not yet been specified.

  1. Database Definitions (ttaad4510m000) Use this session to specify local or remote databases. Databases are identified by their database codes. For local databases you can specify the database type, parameters, and audit trail. Parameters for ORACLE and Informix indicate the place of the tables in that database. For remote databases you can enter the name of the remote system in the System Name field.
  2. Database Definitions (Copies/Alternatives) (ttaad4112s000) Use this session to specify copies of your database.
  3. Tables by Database (ttaad4111m000) After you have defined the database codes, use this session to assign tables to the database. You can specify per company which tables belong to which database (type).
  4. Logical Tables (ttaad4120m000) Use this session to define the logical table structure. You can define that the set of tables in a logical company must be stored under another physical company. In this way, you are able to store, for example, your item data and bill of materials only once in your system, while your financial data is stored in different financial companies.