Skip to Content
0

Can we profile on Backend tables of SAP ECC in Information Steward

Feb 02 at 12:54 PM

72

avatar image

Hi All,

Can we profile on the backend tables of SAP ECC. In our case the backend database for SAP ECC is Oracle.

What is the best practice suggested by SAP?

Profiling directly on SAP tables(using Views in IS)

or

Dumping the SAP tables in to a staging layer using BODS and then profiling on the staging tables

Regards

Arun Sasi

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Dirk Venken
Feb 03 at 08:53 AM
0

My recommendation to all my customers: never profile on your operational systems!

Because that’s bad for performance, both source and IS.

With ECC as a source, there are 2 options:

1/. Stage everything in a relational database, as you proposed

2/. Profile on a copy of PRD; they often run a QA system that’s a more or less accurate copy of PRD anyway

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thanks Dirk!! Here you go 10 Karma points :)

0