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

...

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

...

To operate the database, a technical user with full access to the database needs to be configured.

...

Linux x86_64 operating environment

SAP Note 1644499 describes the requirements necessary to establish the connection and links to the relevant resources.

...

Windows operating environment

SAP Note 1774329 describes the necessary steps on how to establish the connection along with links to the relevant resources.

...

SAP: Connection of a remote database

...

• DB connection: Name of the database connection (e.g. MSSQL)
• DBMS: MSS can be chosen via F4 help
• Username: MS SQL technical username
• DB password: MS SQL technical user password
• Info: Enter connection string:
  • MSSQL_SERVER=skbtsmss01 <mssql_server> MSSQL_DBNAME=datavard OBJECT<database> MSSQL_SOURCESCHEMA=dbo<schema>
• Permanent: Can be left unchecked
• Connection Limit and Optimum Conns: Can be left empty if not instructed elseotherwise

Image RemovedImage Added

New database connection item

SAP Note 1265134 describes and SAP Note 178949 describe in detail how to establish a connection to a remote database.

...

If errors occur, some details can usually be found in the ST11 work process log.

Storage setup

To create an MSSQL storage:

1. Open transaction /DVD/SM_SETUP
2. Click Create
3. Enter Storage ID
4. Select Storage Type SM_TRS_MSS
5. Enter the Description for the storage
6. Enter previously created DBCO connection as DB Connection Name
7. Select COLUMN ORIENTED if the target database is columnar
8. Enter MSSQL collation, if a non-default value is required.
   1. To differentiate between uppercase and lowercase letters, it is necessary to fill the MSSQL collation field with Latin1_General_CS_AS.
   2. SAP Note 2767546
   3. https://www.sqlines.com/oracle/case_sensitivity_primary_key
9. Check Enable update, if delta loads should update previously loaded data
10. Check Map boolean to bit type, if you want to map SAP fields with domains FLAG and XFELD to MSSQL data type bit

• Storage ID: Name of the storage.
• Storage Type: Type of storage. Use the storage type SM_TRS_MSS for MS SQL transparent storage.
• Description: Short text description.
• Connection mode: O for Open SQL, N for Native SQL.
• DB Connection Name: Existing SAP DBCO connection.
• Column Oriented: Switches between the columnar and row-oriented database management system.
• MSSQL Collation: Collation rules.
  
• Enable update: Support of the direct update statements.
• Map boolean to bit type: Maps the SAP fields with domains FLAG and XFELD to MSSQL data type bit.
• Read all clients: Reads the data from all clients.

Limitations

While altering a table, only new fields (characteristics or key figures) can be added. Modifying the existing field’s data type or length is impossible.