There are two ways to download events from Oracle using the integrator. More information about downloading can be found here.
Download via Form
When you select "Download via Form," a download form will appear, where you can enter your download criteria. It's important to note that each field operates independently, meaning there is no interdependence between them. This design allows for flexibility in defining your search parameters.
Once you've entered the desired values into the respective fields, click the 'Download' button to initiate the download process. The integrator uses the AND operator, which ensures that only records meeting all the specified criteria are included in the downloaded data.
This approach ensures precise data retrieval by matching the combined conditions set in the form.
Download via Sheet
When the option to ‘Download via Sheet’ is selected, the Integrator will use the data entered in the columns that allow sheet values to be used as the download criteria to download data to the sheet. These columns are indicated by a white triangle above the column name.
Note that query conditions on the sheet and in the Download form are treated as AND clauses rather than OR in the download query.
