The SQL Server database handler is a part of the
Ekobit.BizDataX.Databases.MSSQL NuGet package which has to be installed before the handler can be used. It is used by the BizDataX Designer.
|Table of contents|
|SQL Server specific settings|
|SQL Server Types|
The installation of the database handlers is described in more detail in the installation guide.
The settings are set in Package.xaml file for each handler, inside the iterator blocks.
Settings are constructed using Fluent Handler API.
SQL Server handler extends those setting with some database specific options.
||Sets ranges defined by SQL Server range-partitioned tables.|
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.
If upon running a sensitive data discovery on BizDataX Portal or upon running a package in Visual Studio or on BizDataX Portal, you encounter the exception like in Figure 1 or a similar error, download and install the SQLSysClrTypes.msi file from the appropriate Microsoft SQL Server Feature Pack.
Figure 1: SQL Server Types exception
BizDataX Documentation © Built by Ekobit. All rights reserved.