I will be extracting data from SAPR/3 and flat files and loading into my SAP-BW system. How do I go about evaluating ETL tools and which ones would you suggest?
Sid Adelman's Answer: The most important point to consider is the support the ETL tools have for SAP. Most of the major ETL products have an SAP mapping. Ask to review the mappings and try to determine how easy or difficult it will be for you with each one. The next point to consider is the performance, i.e., how long it will take to perform the ETL process. This is critical if you will be loading vast amounts of data. Ask to talk to references with data volumes as large as yours.
Clay Rehm's Answer: I recommend looking at all the data extraction tools - make sure you look at non-ETL tools - some may not define themselves as such. This means evaluate any kind of data movement, migration or extraction tool. I firmly believe that the tool you select is a tool that your organization needs, not what I suggest. Additionally, the tool may already exist in your organization! Do a thorough search of what data movement tools you have in each department.
Chuck Kelley's Answer: I think I would ask this question to SAP. They have done this many times and I believe they have their own way of doing it.
Mike Jennings' Answer: Conducting a proper ETL product evaluation requires substantial time and resources. Business requirements, budgets, timelines and politics are often the key factors in determining which direction a firm takes with its selection.
Some of the initial criteria the ETL method chosen should provide:
You should look at ETL products that have a business relationship with SAP. They may offer prebuilt data maps for SAP (SAPR/3 - SAP-BW) that could save you substantial time and effort depending on the level of customization you applied to your SAPR/3 environment.
Register or login for access to this item and much more
All Information Management content is archived after seven days.
Community members receive:
- All recent and archived articles
- Conference offers and updates
- A full menu of enewsletter options
- Web seminars, white papers, ebooks
Already have an account? Log In
Don't have an account? Register for Free Unlimited Access