(SM-2408) MS SQL BLOB

Owned by SNP
Aug 20, 2024
1 min read

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

Storage Management

In the Storage Management Setup (/DVD/SM_SETUP), create new storage with BLOB_MSSQL storage type.

image-20240320-141553.png

Storage Parameters:

  • DB Connection Name: Existing SAP database connection.

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

  • Database Prefix: The name of the cluster table generated on the storage will contain a database prefix and number with 10 digits.

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

  • Generate DB indexes: A default index on the cluster table will be created, improving the performance of reading data, but the performance of writing data could be degraded.

  • Enable update: Support of the direct update statements.