(SM-2405) SAP ASE BLOB

Owned by SNP
May 21, 2024
1 min read

SAP ASE BLOB is a binary connector for SAP ASE DB as a secondary DB.

More information about BLOB can be found here: https://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc00172.1510/html/iqlob/CHDICDDA.htm.

Storage setup - SAP ASE

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

image-20240320-140607.png

  • Storage ID: Name of the storage.

  • Storage Type: Type of storage. Use storage type BLOB_ASE for the SAP ASE storage.

  • Description: Short text description.

  • Blob Size (Kbytes): Data will be split into portions according to Blob size during the transfer. 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.

  • DB Connection Name: Existing SAP database connection (DBCO).

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

Example configuration of DBCO (NSD system) :

SYBASE_SERVER=vsks055

SYBASE_PORT=4901

SYBASE_DBNAME=DVD

SYBASE_DBOWNER=SAPSR3