Devart Oracle Destination is designed for loading data into Oracle tables.
With OCI connections, Devart Oracle Destination uses direct path load interface to speed up loading. With Direct mode it uses array binding feature.
The Oracle table you want to migrate data to can be selected in the Table Name combo box on the Component Properties tab of the Devart Oracle Destination data flow object.
The action that should be performed with data during migration is defined by the Action parameter of Devart Oracle Destination object, that provides the following options: Insert, Update, Delete, and BulkInsert. As all of the actions have certain peculiarities:
- Insert - as this case is the most common, we decided to cover it in a detailed tutorial. It uses simple INSERT statements to load data to Oracle.
- BulkInsert - uses Oracle-specific technique to quickly load data to Oracle. With OCI connections, Devart Oracle Destination uses direct path load interface to speed up loading. With Direct mode it uses array binding feature.
- Update - Devart Oracle Destination component in the Update mode enables updating
data in a Oracle table.
Note:Peculiarity of this action consists in the fact, that performing it requires using primary key values of the Oracle table. Thus, when performing an update, you must know and specify the primary key values of the Oracle table to update a record.
- Delete - Devart Oracle Destination component enables deleting data from a
Oracle table.
Note:
As is the case with the Update action, the ID column from the local data source corresponding to the Primary key values column in the Oracle table, must be used.
The amount of data that can be migrated at a time is limited by the BufferSize property.
BufferSize defines the maximum size of the local buffer, its default value is 262144.
Devart Oracle Data Flow components support error outputs, which allow you to manage how the component treats row-level errors in both incoming and outgoing data.
The error output includes the column set taking part in the data flow and additional columns, they are ErrorCode that identifies the error, ErrorColumn that contains the lineage identifier of the error column and ErrorDescription that provides a detailed description of the error.
The ErrorCode column can accept the following values:
| ErrorCode | Description |
|---|---|
| -1 | Means that the record is valid. |
| >0 | Means that the record causes an error. |
Additionally, when the primary key values are automatically generated for the target table, Devart Oracle Destination retrieves the generated values and adds them to its output columns.