Sybase database handler

The Sybase database handler is is used in BizDataX Designer for handling (masking) Sybase databases.

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

Installation

To install the Sybase database handler add the BizDataX.Databases.Sybase NuGet package to the solution.

Settings

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

Sybase specific settings

Extends Setting Description Data type
.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 IntermediateTablesControlFunc Intermdiate tables control function. Func<TableType, ITableHandlingInfo, string, TableSpecification>

Example

Customer.Handle.WithBulk().CreateIndexOnTempTables(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.