SAP Note 512739 - BW external DB Connect for MS SQLServer

Component : BW Microsoft SQL Server - DB Connect

Solution : https://service.sap.com/sap/support/notes/512739 (SAP Service marketplace login required)

Summary :
SAP Note outlines the integration of external MS SQLServer databases into BW version 3.0B or higher as source systems. It details prerequisites such as specific BW/Basis version requirements and essential MS SQLServer database knowledge including tools and database-specific functions. It addresses problem areas like datatype compatibility, including solutions for transforming non-compatible datatypes (e.g., Datetime, smallint) to suit BW system requirements. Additional considerations include respecting case sensitivity requirements and managing code page configurations. Authorization and visibility guidelines are also specified to ensure secure and correct data access and integration.

Key words :
source systemdatabase datasource infosource reason, ms sql server database provided, create view <viewname> asselectvd_1_d =  convert, ms sql server supports, ms sql server functions, semantically relevant data reaches, satisfactory customer-specific solution, ms sql server database, - tools                - db specific functions, - db specific functions required

Related Notes :

1396552Remote connection delivers wrong character data
541954Erweiterung von CL_SQL_METADATA_MSS
178949MSSQL: Database MultiConnect with EXEC SQL