Enabling data loading of the Property class type property

By default, when you run extract, transform, and load (ETL), data is loaded into the reports data warehouse for the Simple and Complex properties. To load data for the Property class type properties, you need to run the update command, as described in this topic.

For information about property types, see Adding or modifying properties in the BMC Server Automation documentation.

This topic includes the following sections:

To enable data loading of the Property class type property for Oracle

1. From the command prompt, navigate to the BDSSAInstallationDirectory/bsa/dwh/sql/oracle/schema directory.
2. Log on to SQL Plus as BDSSA_DW (or the name you choose for this user).

3. Run the following commands:

   sqlplus bdssa_dw/<password>@<TNS_ENTRY>update system_property set value = 'true' where NAME='LoadPropertyClass';
   commit;

To enable data loading of the Property class type property for Microsoft SQL Server

1. From the command prompt, navigate to the BDSSAInstallationDirectory/bsa/dwh/sql/sqlserver/schema directory.

2. Log on to the SQL Server database as BDSSA_DW (or the name you choose for this user) by using the SQLServer Management Studio.

3. Run the following command:

   update system_property set value = 'true' where NAME='LoadPropertyClass';

Where to go from here

Performing the initial ETL run