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?
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.
Dig Deeper on SAP implementation and upgrades
Related Q&A from Joshua Greenbaum
I plan to get trained in SCM planning with APO (DP/SNP) and eventually get certified. After reading some articles on SearchSAP.com I got the feeling ... Continue Reading
With an MBA in international business, I have come to know that there are opportunities in SAP. I do not have any domain experience, but people are ... Continue Reading
What is SAP's UI strategy? In an attempt to appease customers who are unhappy with the ageing SAPGUI interface, SAP appears to have branched out in ... Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.