Oracle^® Business Intelligence Data Warehouse Administration Console Guide > Customizing, Designing, Executing and Monitoring ETL Processes >

Setting Source System Parameters

Source system parameters are specific to source system containers. You can set static or runtime parameters in the Source System Parameters tab of the Design view.

To set a source system parameter

1. In the DAC, select the appropriate source system container from the drop-down list in the toolbar.
2. In the Menu bar, click Views > Design > Source System Parameters.
3. Click New in the top pane toolbar.
4. In the Edit child tab, enter a name for the parameter.
5. Select one of the following data types:
   • Text
   • Timestamp
   • SQL
6. Click in the Value field to open the Enter Parameter Value dialog box.
7. If you selected the Text data type:
   1. Select Static or Runtime.
   2. For a static parameter, enter the parameter information in the text box, and click OK.
   3. For a runtime parameter, select a variable, and click OK.
8. If you selected the Timestamp data type:
   1. Select Static or Runtime.
   2. Choose a function from the Function drop-down list.
      • If you select Custom Format, enter a format in the Format field.
      • If you select SQL Syntax, select a database connection in the Connection drop-down list.
   3. If you selected Static, click in the Date field, and enter a date and time.
   4. If you selected Runtime, select a variable from the Variable drop-down list.
9. If you selected the SQL data type:
   1. Select a logical data source.
   2. Enter the SQL statement in the text box, and click OK.
10. Click Save in the top pane toolbar or in the Edit child tab.