Run the data extract job

1. Click the Study Configuration icon from the navigation bar after selecting a study from either Home or Study Manager. Then click the Clinical Data Models tab.

2. Select a model.

3. In the Data Extraction tab, select a data mart to run.

4. Click the Execute icon.

5. Enter values:

   • For a text data mart:

     • Separator: Select the character to use to separate column values in the output file.

     • Enclosing Character: Select the character to use to separate records in the output file. You can select None.

   • For an Oracle data mart:

     • Compress: Specifies how Export and Import manage the initial extent for table data.

       If set to Y, data is flagged for consolidation into one initial extent upon import. If extent sizes are large (for example, because of the PCTINCREASE parameter), then the allocated space will be larger than the space required to hold the data. This is the default value.

       If set to N, the export utility uses the current storage parameters, including the values of initial extent size and next extent size. The values of the parameters may be the values specified in the CREATE TABLE or ALTER TABLE statements or the values modified by the database system. For example, the NEXT extent size value may be modified if the table grows and if the PCTINCREASE parameter is nonzero.

     • Statistics: Select the type of database optimizer statistics to generate when the exported data is imported. Options are Estimate, Compute, and None. The default value is None.

6. Select the appropriate Blind Break option.

   • Not Applicable: None of the tables are blinded. All data will be included.

   • Real (Blind Break): If selected, the real, blinded data will be included and the action will be audited. This option is available only if you have special privileges.

     Note:

     In this release it is not possible to extract masking values. If any data is blinded in the model, you can only extract it if you perform an audited blind break, extracting the real, sensitive data.

   • Real (Unblinded): If available, the real data has been unblinded. If selected, the real, unblinded data will be included. This option is available only if you have special privileges.

7. Select an execution type:

   • Immediate to submit the job immediately.

   • Deferred to schedule a single execution. Click the Start Date icon and select a date and time.

   • Scheduled to create a regular execution schedule. Select a start and end date and time and a frequency number and unit (hours, days, weeks, or months).

     For example, with a frequency unit of months and a frequency of 1, the job will run once a month from the specified start date and time to the specified end date and time.

Back to Set up clinical data models