5.2 About Schema Creator Utility

This section describes about the Schema Creator Utility.

Creating database users/schemas is one of the primary steps in the complete OFS BD installation. This release of OFSAA provides a utility to quickly get started with the OFSAA 8.1.2.0.0. Installation by allowing easier and faster creation of database User(s)/ Schema(s), assign the necessary GRANT(s), and so on. Additionally, it also creates the required entities in the schemas and so on.

The schema creator utility must be configured and executed before installation of any OFSAA Application Pack

Configuring Schema Creator Utility for RDBMS

The Pack specific schema details need to be filled in the OFS_BD_SCHEMA_IN.xml file (path is OFS_ BD_PACK/schema_creator/conf/OFS_BD_SCHEMA_IN.xml) before executing the Schema Creator Utility. For more information on the xml file, see Configuring OFS_BD_SCHEMA_IN.xml File.

Note:

On successful execution of the utility, the entered passwords in the OFS_BD_ SCHEMA_IN.xml file are nullified.
The types of schemas that can be configured are:
  • CONFIG - This schema holds the entities and other objects required for OFSAA setup configuration information.

    Note:

    There can be only one CONFIG schema per OFSAA instance.
  • ATOMIC - This schema holds the data model entities. One ATOMIC schema is attached to one Information Domain.

    Note:

    There can be multiple ATOMIC schemas per OFSAA Instance.

Configuring Schema Creator Utility for HDFS Schema

Note:

On successful execution of the utility, the entered passwords in the OFS_BD_ SCHEMA_IN.xml file are nullified.

The following are the types of schemas that can be configured:

  • CONFIG - This schema holds the entities and other objects required for OFSAA setup configuration information.

    Note:

    There can be only one CONFIG schema per OFSAA instance. This schema is created only in RDBMS.
  • METADOM: This schema holds the data model entities. One METADOM schema is attached to one Information Domain.

    Note:

    There can be multiple METADOM schemas per OFSAA Instance. This schema is created only in RDBMS. It has only platform entities that hold the metadata details. However, it does not hold the data model entities.
  • DATADOM: This schema holds data model entities. One DATADOM schema is attached to one Information Domain.

    Note:

    There can be multiple DATADOM schemas per OFSAA Instance.

Selecting Execution Modes in Schema Creator Utility

Schema creator utility supports the following modes of execution:
  • Online Mode: Inthis mode, the utility connects to the database and executes the Data Definition Language (DDL) for User, Entities, and GRANTS.

    Note:

    To execute the utility in Online mode, you need to connect as <User> AS SYSDBA.
  • Offline Mode: In this mode, the utility generates an SQL script with all the required DDLs for User, Entities and GRANTS. This script must be executed by the DBA on the appropriate database identified for OFSAA usage.

    Note:

    For running the SQL script generated in offline mode, the script must reside in the same directory where the SQLScripts directory is available.

    1. Connect as any database user.
    2. Reconfigure the OFS_BD_SCHEMA_IN.xml (as the case maybe) file and execute the utility. For more information on reconfiguring these files, see Configuring OFS_BD_SCHEMA_IN.xml File.
    3. To execute the utility in Offline mode, you must connect as a user with the following GRANTS (alternatively, you can also connect as a user with SYSDBAprivileges):
      • SELECT ONDBA_ROLES
      • SELECT ONDBA_USERS
      • SELECT ONDBA_DIRECTORIES
      • SELECT ONDBA_TABLESPACES
      • CREATE SESSION
    4. If there are any errors during the SQL script execution, reconfigure the OFS_BD_ SCHEMA_IN.xml and execute the utility. This regenerates the scripts with corrected information. For more information, see Configuring OFS_BD_SCHEMA_IN.xml File.
    5. Do not modify the OFS_BD_SCHEMA_OUT.XML file generated after the execution of this utility.
    6. Do not keep any backup files of xml's in the download directory.
    7. Current offline installation throws an error while running the SQL in schema.

Selecting Execution Options in Schema Creator Utility

Depending on the option selected to run the OFSAA Applications Pack installer, you must select the appropriate schema creator utility execution option. To run the OFSAA Applications Pack installer in Silent mode, it is mandatory to execute the schema creator utility with -s option.