<fuego : warehouse>

Description

This is tasks provides the ability to configure and manage the Datawarehouse.

It can create/drop the database and run the updater.

Examples:

1. Configure Data Store properties.

 <fuego:warehouse action="configure"
                logDefaultSeverities="Fatal"
                configuration="configuration"
                bamConfiguration="bamConfiguration"
                bamRuntimeConfiguration="bamRuntimeConfiguration"
                logDir="/tmp"
                snapshotTime="12:00"
                updateFrequency="daily"
                updateTime="13:45"
                o3ServerHost="v8"
                o3ServerPort="1234"
                caducityTime="36"
                updateFrequencyMinutes="25"
                cubesUpdateTime="00:00"
                enableO3Service="true"
                disableDatawarehouse="false"
                disableUpdate="false"
                disableBAMUpdate="false"
                runWorkload="false"
                runPerformance="false"
                generateO3Cubes="true"
                language="es">

2. Create BAM and OLAP databases.

 <fuego:warehouse action="create-database" bam="false">
       <fuego:admin user="${dba_user}" password="${dba_password}"/>
 </fuego:warehouse>

 <fuego:warehouse action="create-database" bam="true">
       <fuego:admin user="${dba_user}" password="${dba_password}"/>
 </fuego:warehouse>

3. Create BAM and OLAP DDL's.

 <fuego:warehouse action="create-database" bam="false" showSqlStatements="true" sqlStatementsOutputFile="create-olap.sql"/>

 <fuego:warehouse action="create-database" bam="true" showSqlStatements="true" sqlStatementsOutputFile="create-bam.sql"/>

Parameters

Attribute Description Type Required?
o3serverhost Sets the host where the O3 Server is running. String No Defaults to localhost.
enableo3service Sets whether the O3 Service is executed or not. The O3 Service connects to a O3 Server and starts the cube building process. boolean No Defaults to false.
haltonerror Stop the Ant build process if an error occurs. boolean No Defaults to true.
bamruntimeconfiguration Sets the name of the BAM database resource configuration that will be used in runtime. String No If omitted, the value of bamConfiguration is used.
sqlstatementsoutputfile File No Only needed if showSqlStatements is true.
updatetime Sets time at which the updater process will run. The string must have the following format (using lex-like syntax): h{1,2}:m{1,2}(:s{1,2}(.ms{1,})?)?)? String Yes If the action is set to configure.
caducitytime Sets the Instance Caducity time for BAM database rows. int No Defaults to 24 hours.
showsqlstatements This attribute is used as a modifier of create-database action when you wish to generate the DDL scripts for database structure instead of actually creating it. boolean No Defaults to false.
logdefaultseverities Sets the severity level that are logged in the updater log file. String ["Fatal", "Severe", "Warning", "Info", "Debug"] ?
updatefrequencyminutes Sets the update frequency time for the BAM updater process. int No Defaults to 60 minutes.
configuration Sets the name of the Data Store database resource configuration. This is the configuration to use for the Data Store back-end database. String Yes
disabledatawarehouse Sets whether the Data Store service is enabled or not. boolean No Defaults to true.
cubesupdatetime String ?
updatefrequency Sets the update frequency to daily or hourly. String ["daily", "hourly"] Yes If the action is set to configure.
snapshottime Sets the snaphost time. The string must have the following format (using lex-like syntax): h{1,2}:m{1,2}(:s{1,2}(.ms{1,})?)?)? String Yes If the action is set to configure.
importfile Sets the xml file's path used to import the Data Store properties. File ?
logdir Sets the log directory where the Updater creates the log files. File Yes
language Sets the language that is used to run the updater process. String No Defaults to the JVM default language.
action Defines the operation to execute:
  • configure: configure the Data Store properties.
  • import: import Data Store properties from a file.
  • run-updater: run the updater process.
  • create-database: create a new schema.
  • drop-database: drop an existing schema.
  • recreate-database: drop an existing schema and create it.
  • clean-database: create a new schema if it does not exist, or remove all the existing objects otherwise.
 String ["configure", "import", "run-updater", "create-database", "recreate-database", "drop-database", "clean-database"] Yes
bamconfiguration Sets the name of the BAM database resource configuration. This is the configuration to use for the BAM back-end database. String Yes If the action is set to configure.
runworkload Sets whether workload metrics are generated or not. boolean No Defaults to true.
generateo3cubes Sets whether the updater generates O3 cubes after filling the Data Store database. boolean No Defauls to false.
runperformance Sets whether performance metrics are generated or not. boolean No Defaults to true.
o3serverport Sets the port number where the O3 Server is listening for incoming requests. int No Defaults to localhost.
disableupdate Sets whether the updater is enabled or not. boolean No Defaults to false.
bam Sets wether the database operations are performed using the BAM database or the Data Store database. The database operations include: run-updater, create-database, drop-database, recreate-database, clean-database boolean No Defaults to true.
disablebamupdate Sets whether the BAM service is enabled or not. boolean No Defaults to true.

Parameters accepted as nested elements

<admin>

Represents the credentials for an "Administrator" user.

If it's used to represent a Fuego Directory administrator, then participant should be used for the participant id. For connections to other systems (like DBMSs) the user attribute will be used.

This element is required when action equals enable-location, create-database, clean-database or drop-database.

Attribute Description Type Required
participant ID of the Fuego Administrator participant. String Yes When used to connect to a Fuego Directory
user ID of the Administrator user. String Yes When used for connections not to the Fuego Directory
password User or participant's password. String Yes

© 2007, BEA Systems