Ask the Expert

How to obtain bulk data from Business Warehouse

What's the best way to get bulk data out of my Business Warehouse environment? We want to use some of the aggregated data in BW in another (non-SAP) application. Should I be using an ETL tool like Informatica - our in-house standard - or is there some other way to go about this?

    Requires Free Membership to View

Is the target a single application or multiple applications? Is this a periodic download or strictly one-off? If you're doing this one time only, or the target is a single application, then SAP's open hub interface is probably the simplest and most straightforward way to proceed. But if you're targeting more than one application and planning to do this on a periodic basis, your Informatica ETL tool would give you much more management and control over the process.

This was first published in February 2005

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: