Skip to Content
avatar image
Arun Sasi

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

Feb 02, 2018 at 12:54 PM | 93 Views

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

SAP Information Steward
dirk venken | brandon jacobson | matthias kammerer
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Dirk Venken
    Feb 03, 2018 at 08:53 AM

    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

    Add comment
    10|10000 characters needed characters exceeded