Filtering Source Data Using Runtime Inputs

Sun Data Integrator allows you to pass values, known as runtime inputs, to ETL collaborations at runtime. You can use these values in extraction conditions. However, the use of such dynamic values are not limited to extraction; you can also pass values from BPEL business processes.

The following procedure describes how to add input runtime arguments to a Collaboration.

To Filter Source Data Using Runtime Inputs

1. Open the collaboration you want to edit.

2. Right-click the ETL Collaboration Editor window and select Runtime Inputs.

   The Add Input Runtime Arguments dialog box appears.

   

3. Click Add.

   An empty row appears.

4. Double-click the empty row under Argument Name and enter the name for source record to be filtered.

5. Press Tab and enter the content that the record must contain to be selected.

6. Press Tab and select the SQL type for the record.

7. Press Tab and enter a number indicating the maximum length of the record.

8. Press Tab and enter a number indicating the scale for the record.

9. Click OK.