/
(SM-2508) MS SQL BLOB

(SM-2508) MS SQL BLOB

Microsoft SQL BLOB is a binary connector for SAP MSSQL DB as a secondary DB.

Creating MS SQL BLOB Storages in Kyano Storage Management  

Proceed as follows to create an MS SQL BLOB storage: 

  1. Start transaction /DVD/SM_SETUP. 

  1. Click Create to create a new storage. 

  1. Enter a Storage ID. 

  1. In the Storage type field, enter BLOB_MSSQL. 

  1. Click Confirm. 

  1. Specify the required parameters: 

    • DB Connection Name: Specifies the name of the existing SAP database connection. 

    • Blob size (in Kbytes): Specifies the BLOB size. During the data transfer, data is split into portions according to the BLOB size. Every portion with binary data is transferred to the storage and stored as a separate entry in the cluster table. 

    • Database Prefix: Specifies the database prefix. The name of the cluster table that is generated on the storage contains a database prefix and number with 10 digits. 

    • Compute hash: Calculates the hash of the data before and after the transfer. 

    • Generate DB indexes: Creates a default index on the cluster table. This improves the performance of reading data but can worsen the performance of writing data. 

    • Enable update: If selected, delta loads will be merged into existing data.

    • image-20240320-141553.png

  2. Click Save. 

The new storage has been created.