<fuego : warehouse>

Description

This is task configures and manages the BAM and Data Mart databases.

This task can create and drop the databases and run the updater.

Examples:

1. Configure Data Mart 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 Data Mart 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 Data Mart 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 where to save the SQL statements when showsqlstatements is set to true. 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 Set this option to true if you want the create action to save the DDL SQL statements to a file, instead of actually connecting to the database and executing them. See sqlstatementsoutputfile. boolean No Defaults to false.
logdefaultseverities Sets the severity level that are logged in the updater log file. String ["Fatal", "Severe", "Warning", "Info", "Debug"] Yes If the action is set to configure.
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 Yes If the action is set to import.
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

© 2008 Oracle Corporation