This document serves as a guide for the implementation of the necessary prerequisites in order to operate Datavard Glue, a middleware and development platform for data integration, in combination with Microsoft SQL environments.

...

Some of these prerequisites can be achieved or set up in parallel, others have to be done sequentially as they depend on configuration done in previous steps.

Supported versions

The minimal supported version is 12.00.5207.

MS SQL

Open ports

In a controlled network environment, it is common to have firewall rules in place. In order to enable communication of SAP systems with MS SQL, TPC port 1433 needs to be reachable in MS SQL from the SAP system.

...

If errors occur, some details can usually be found in ST11 workprocess log.

Storage setup

To create an MSSQL storage:

1. Open transaction /dvd/sm_setup
2. Go to Edit Mode & Click New Storage
3. Enter Storage ID
4. Select Storage Type SM_TRS_MSS
5. Enter Description for the storage
6. Ented previously created DBCO connection as DB Connection Name
7. Select COLUMN ORIENTED if target database is columnar
8. Enter MSSQL collation, if non-default value is required
9. Check Enable update, if delta loads should update previously loaded data

Image Modified

• Storage ID: name of the storage
• Storage Type: type of the storage. Use the storage type "SM_TRS_MSS" for MS SQL transparent storage.
• Description:  short text description
• DB Connection Name: existing SAP DBCO connection.
• Column Oriented: switch between the columnar and row-oriented database management system
• MSSQL Collation: collation rules
  
• Enable update: support of direct update statements

Limitations

While altering a table, only new fields (characteristics or key figures) can be added. It isn't possible to modify the existing field’s datatype or length.