cancel
Showing results for 
Search instead for 
Did you mean: 

SAP BW connect to legacy datasource

Former Member
0 Kudos

Hi,

our BW system is currently connect to SAP ECC 5. (our BW is 3.5).   We  have been asked by the user to connect to legacy system (Oracle database & SQL database) apart from ECC datasource.  My concern is system performance & database sizing.   What factor/information should I seek from the legacy owner inorder to evaluate the impact from this request.

Regards,

Rujira

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

You can start with following pointers:

  • As you mentioned volume and DB size
  • How many full and delta loads
  • Business rules to be incorporated on BW side as more often than not you will have format and data profiling issues from legacy database
  • You are on 3.5 so delta can only be achieved via UD connect not by DB connect so make sure you design accordingly

Answers (2)

Answers (2)

Former Member
0 Kudos

Hello Rujira,

DB performace and data volume will definitely play major role in this case.

Please analyze the requirement and understand the data flow and also the amount of data that you will be receiving everyday.  Also as Suyash mentioned, make sure whether data is pulled on delta or full basis. Make your configurations accordingly in BW system.

Thanks.

esjewett
Active Contributor
0 Kudos

Moved this to the BW forum. Please post BW questions in this forum, not the Data Warehousing forum.

Thanks,

Ethan

(moderator)