Skip to Content

BW Source System of DB Connect Transport possible?

Hi BW experts,

I've created a source system under DB Connect in BWD, is it possible to transport this source system from BWD to BWQ then BWP? or I have to create these manually in BWQ & BWP?

Also, I've maintained Database Connection detail information in DB02 in BWD, should this information be maintained manually in BWQ and BWP? is that possible to transport these settings? For we use the same Database server for all of BW systems (BWD,BWQ,BWP).

Many thanks,


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    May 17, 2018 at 01:22 AM

    Source Systems in BW have to be created manually in each BW system and cannot be transported, regardless of the Source System Type (DB-Connect, SAP, etc.). Just like your SAP-type Source Systems, best-practice is to have distinct names for your Source Systems in every BW environment (DEV, QAS and PRD). In your case, even though you currently use the same DB connection parameters for all three BW systems, having three distinct Source System names is still recommended.

    As usual you can use the Source System mapping table to re-map the Source System name during transport import for each BW system.

    Example mapping table for BWP:

    NOTE: In this scenario BWD and BWQ are both connected to ECC QAS (TC2CLNT400) system.

    bw-source.png (11.8 kB)
    Add comment
    10|10000 characters needed characters exceeded