Setting Up Incremental Extracts from Oracle CRMOD

Incremental extracts pick up only the data that has changed since the last extraction. Use incremental extracts when you do not want to extract all the data each time.

To set up incremental extracts from Oracle CRMOD:

1.

In the Admin module, select the Define Sources tab.

2.

Click Manage Sources.

3.

Confirm that the Oracle CRMOD source contains a Date Modified column in the Columns tab and that its Analyze by Date box is checked.

4.

Select the Oracle CRMOD source in the data sources panel.

5.

Click the Properties tab.

6.

Check the Rows in Data Source are Transactions box (as shown below) then click Save. Note: If a grain has been defined for this source, the Rows in Data Source are Transactions setting will treat rows as transactions, meaning that Birst will not apply a Load_ID prefix when a measure from this grain is selected. See Setting Transaction and Snapshot Policies for a Data Source for more information about this setting. After changing this setting, the next time you perform an Oracle CRMOD extraction, a full extraction will be performed. After that, all future extracts will be incremental, meaning only the data that has changed since the previous extract will be extracted.

Next Steps:

Process the data in the Process Data, Process New Data page. See Processing Data.

Set up scheduling in the Process Data, Schedule Data Processing page. See Scheduling Extraction and Data Processing for Cloud Applications.