Loading properties to the database

All database supported properties are loaded to your IBM Sterling® Order Management System environment and the developer toolkit database by default, as the DATABASE_PROPERTY_MANAGEMENT property is set to true.

The loadProperties.sh command line script loads all the default properties and factory values to the database. This script is not available to run in SaaS environments, but is available on the developer toolkit environment. This tool reads tagged property files and converts them into XML format, which can be loaded to the database, conforming to the PLT_Property_Metadata and PLT_Property property tables.

The processing of each properties file results in two sets of data:
  • PropertyList.xml, which contains properties to be loaded to the database.
  • filesystem.properties, which contains a list of properties that are not supported in the database.

The script passes install_dir/properties as the input directory, process es all the property files within it, and all the property tag and value changes are audited. It does not process customer_overrides.properties, filesystem.properties, and any property files that have DATABASE_SUPPORT: N defined at the file-level.

Managing properties in the database

You can use the manageProperty API or the Property Management user interface in the System Management Administration application to manage properties in the database. In the developer toolkit environment, you can also use the manageProperties command line script to manage properties in the database. The manageProperties command line script is not used in SaaS environments.

For more information, see Managing properties in the database.