Runtime Parameters

If you need information from the user when he or she runs the Load Set, Data Mart, or Program, or launches a visualization tool, create a Parameter Set named PARAMETERSET_LOADSETLEVEL_RUN and set its Usage attribute to EXECUTION.

Oracle Life Sciences Data Hub displays Parameters in this Parameter Set as Parameters in the Parameters tab in the Load Set, Data Mart, Program, or Business Area Properties page and in the Load Set, Data Mart, or Program's Execution Setup.

For example, the following shipped adapters have the following runtime attributes:

• SAS Load Sets: Dataset Filename and BLOB ID (Temporary)
• Text Load Sets: Data File Name, Data Format, Delimiter Character, Enclosing Character, Initial Records to Skip, Maximum Allowed Errors, Temp LOB ID, Date Format
• Oracle Tables and Views Load Sets: Remote Location
• SAS Data Marts: Mode and Zip Result
• Oracle Export Data Marts: Compress and Statistics
• Text Data Marts: Zip Results, FirstRow Desc, Operating System, Separating Character, Use Enclosing Character, Enclosing Character

  Note:

  If you are creating an adapter that must upload files, define a Parameter with its Parameter Type set to either BINARY_FILE or TEXT_FILE, as appropriate, and create an instance of it in the runtime Parameter Set. Create a second Parameter called TMP_BLOB_ID, for example, and create an instance of it in the same Parameter Set. Write code to upload the file to a temporary location and store the ID for the file as the value of TMP_BLOB_ID. Use this value in your pre-execution or execution function.