(SM-2302) MS SQL BLOB

Owned by SNP
Feb 16, 2023
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.

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: 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.