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: File extension: .mdcsv Delimiter: ||| (three vertical pipes) Includes Primary Key columns: Yes Includes Incremental columns: No Includes Select List columns: No You can extract the metadata definition in this format when you run the data extracts.
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: File extension: .csv Delimiter: , (comma) Includes Primary Key columns: Yes Includes Incremental columns: Yes Includes Select List columns: Yes You can't extract the metadata definition in this format when you run the data extracts.
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.