Manage Job Data Stores
Click a job in the Jobs list open the Job Details: Job Name page, where you can view and specify data stores from which to extract data. Modify the job data store details as required.
Job Details: Job name
Field Name or Option | How to Use |
---|---|
Edit | Edit job name, job description, and job data stores. |
Edit Group | Edit the order of execution within the job. Select the group number and specify group item priority for each data store. |
Done | Close the dialog box and return to Manage Jobs. |
Actions > Compare Shipped Metadata | Compare shipped data store metadata with modified metadata side-by-side. Available for data stores that are part of a job profile. |
Actions > Reset to Full Extract | Reset the last extract date so that a full data load is performed at the next load for the data store/VO, instead of an incremental load. |
Actions > Reset to Shipped Content | Reset all the data stores in the job to shipped content. |
Actions > Export Metadata Definition (MDCSV) | Export metadata definition for the data store in the MDCSV format. The selected data
store content is exported into a zip file that you can download. Here's some additional
information about this format:
|
Actions > Export Metadata Definition (CSV) | Export metadata definition for the data store in the CSV format. The selected data
store content is exported into a zip file that you can download. Here's some additional
information about this format:
|
Actions > Export UI Label | Export user interface labels for the VO. A zip file is generated with files for each configured language. |
Actions > Download Sample CSV File | Verify the sample extract from the selected data store. |
Actions > Advanced Extract Configuration | For full extracts, use Advanced Configuration to apply a filter or chunk. Select the Cast to String checkbox in the Extract as String tab to extract numeric or CLOB data types. This setting supports CLOB data up to the character string limits supported by the VARCHAR datatype. If data is larger than the string limit, the extract fails. Data transformations, including data format customizations, aren't supported by BICC. |
Actions > Manage Extract Mode | Specify the extract mode. When BI Broker extract mode is enabled, extract jobs don't use the BI Server. They interact directly with data stores and the Cloud Applications source database. To enable it, select BI Broker extract mode in the Manage Extract Mode dialog and click OK. A check is then performed to verify that BI Broker mode is supported for the data store, and if not an error is displayed. |