Oracle database handler

The Oracle database handler is a part of the Ekobit.BizDataX.Databases.Oracle NuGet package which has to be installed before the handler can be used. It is used by the BizDataX Designer.

Table of contents
Installation
Settings
Oracle specific settings
Example
Client-side parallelism

Installation

The installation of the database handlers is described in more detail in the installation guide.

Once installed, it provides a way to configure repeating persistence and restartability store settings in App.config file.

Settings

The settings are set in Package.xaml file for each handler, inside the iterator blocks.
Settings are constructed using Fluent Handler API.
Oracle extends those setting with some database specific options:

Oracle specific settings

Extends	Setting	Description	Data type
`.WithBulk`	`ParallelFactor`	Sets the server-side (database-side) level of parallelism. Optimal value is around the number of logical CPU cores.	Number (threads)
`.WithBulk`	`OptimizationUpdateOnly`	If `true`, only `UPDATE` will be performed in `MERGE`. Otherwise, `INSERT` and `DELETE` conditions are generated. Default is `true`.	Boolean
`.WithBulk`	`CreateIndexOnTempTables`	If `true`, after creating temporary tables when preparing for masking, an index will be created on those tables. This can affect performance both positively and negatively. Default is `true`.	Boolean
`.WithBulk`	`OnlineIndex`	If `true`, indexes on temporary tables will be created online. Default is `true`.	Boolean
`.WithBulk`	`IntermediateTablesControlFunc`	Intermdiate tables control function.	`Func<tabletype, itablehandlinginfo,="" string,="" tablespecification="">`
`.WithSegments`	`ByPartitions`	Sets ranges defined by Oracle range-partitioned and list-partitioned tables.

Note: Supported partition types are Range and List. Hash and Reference types are not supported.

Example

Customer.Handle.WithSegments().ByPartitions().WithBulk().ParallelFactor(4).CreateIndexOnTempTables(true).OnlineIndex(true)

Client-side parallelism

By default, BizDataX only uses server-side parallelism.

To set the level of client-side parallelism, in the Package.xaml file click on a Masking engine, in the Properties pane find MaxParallelIterators and set it to the desired number.

The optimal number of iterators should be close to the physical CPU core count.</tabletype,>