Adding Tables in Database Manager

The Database Manager Tables tab allows the administrator to add a table to the database that does not correspond to an entity in the entity model. To create a table and an entity at the same time, you must create an entity in the Entity Manager that also creates the table. See Creating a new entity

Note: The system administrator can only access these features. These features are not available in Oracle environments.
  1. Select Administration > Database Manager on the navigation bar. The Database Manager details view is displayed.
  2. Click the Tables tab.
  3. Click New Table in the Task Pane. The Add Table window is displayed.
  4. Click Yes if you want to continue creating a table, if prompted.
    Note: Click No if you want the new table to be part of the Entity model. This cancels creating the table. You can create a new entity in Entity Manager. See Creating a new entity
  5. Specify the Table Name that adheres to the following rules required by Infor CRM SLX system. Tables with names that do not follow these conventions does not reveal associated fields.
    Note: These rules omit some items allowed by Microsoft SQL Server and some items allowed by Oracle to remain compatible with both server platforms:
    • You cannot use Microsoft SQL Server or Oracle keywords or reserved words for a table name.
    • The table name must begin with a letter (A-Z). Subsequent characters can be A-Z, 0-9, _ (underscore), $ (dollar sign) or # (pound sign). However, Oracle strongly discourages the use of $ and #.
    • The table name cannot contain embedded spaces or special characters.
    • The table name can be a maximum of 128 characters long for Microsoft SQL Server, or 30 characters long for Oracle.
    • The table name must be unique. Table names are not case sensitive.
  6. Specify the table name in the Display Name field that you want to be displayed in Query Builder.
  7. Specify a brief explanation of the purpose of table in the Description field.
  8. Click the Association drop down if there is a relationship with an existing table and select the primary table from the list.
  9. Click the Type drop-down and select the relationship of the new table to the primary table. You can only have a One-to-One or One-to-Many relationship with the associated table.
    • One-to-one: For a single record in one table there is only one related record in another table. For example, a contact is related to only one account; therefore, the relationship between the CONTACT and ACCOUNT tables is One to One.

    • One-to-many: For a single record in one table there are one or more related records in another table. For example, more than one contact can be associated with an account, but at least one account is always associated with a contact; therefore, the relationship between the ACCOUNT and CONTACT tables is One to Many.

  10. Select the Enable Field Level Security check box to allow restricted user access to fields in this table.
  11. Click OK.
  12. Select the table you added and use the detail pane tabs to add, once finished:
    Note: To edit table properties, select a table in the list and use the CRM Details tab to change the Display Name or Description. See Using the database manager table CRM Details tab
Related topics