About OC Data Extract View Load Sets
Oracle Clinical Data Extract (DX) Views Load Sets allow you to make Oracle Clinical patient data available in Oracle LSH using the Oracle DX Views your company has already defined in Oracle Clinical. There is no need to redefine the views in Oracle LSH.
You can load views, including union views, from one Access Account at a time.
You can either physically load patient records into Oracle LSH or use the Load Set as a pass-through view to Oracle Clinical; see Oracle Tables and Views.
You can load views of any type—stable, snapshot, or current—that are maintained in the specified access account. However, you can see data in current Oracle Clinical DX Views in Oracle LSH only if you do not physically load the data into Oracle LSH.
There are two types of Oracle Clinical data extract view adapters: regular and incremental. The regular one uses full-mode reload processing. The incremental adapter uses incremental transactional processing, in either full or incremental load. For fastest performance, create the Load Set using the Incremental type and select incremental processing when you run the Load Set.
Table 7-3 OC Data Extract View Load Set Types
Load Set Type | OC DX View Types Allowed | Processing Type Used | Processing Options Available at Runtime | Deletion Behavior |
---|---|---|---|---|
Regular |
Stable, Snapshot, or Current |
Reload |
Full |
Soft-deletes records that are not reloaded. See Reload Processing. |
Incremental |
Stable |
Transactional, with or without audit (set in a profile, can be overwritten for a target table instance) |
Full or incremental |
In Full mode, the adapter first deletes all data and then loads all current data:
In Incremental mode, uses DML statements to insert, update, or soft-delete changed records. In addition, data that has been hard-deleted in Oracle Clinical is hard-deleted in Oracle LSH. |
Parent topic: Oracle Clinical Data Extract Views