Ask the Expert

What's the difference between ODS and DSO in SAP BI?

In SAP BI, what is the difference between ODS and DSO?

    Requires Free Membership to View

In BI 7.0, ODS was renamed as DSO (DataStore objects). With this new object, three types are available. "Standard", which is similar to the ODS, has three tables for activation queue, table for active data and change log table, direct update which consists of active data table only, and write optimized which also has only active data table. Sid doesn't get generated in the second and third type of DSOs.


More resources on SAP BI and DSO:


This was first published in December 2007

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: