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 :
1396552 | Remote connection delivers wrong character data |
541954 | Erweiterung von CL_SQL_METADATA_MSS |
178949 | MSSQL: Database MultiConnect with EXEC SQL |