Q
Problem solve Get help with specific problems with your technologies, process and projects.

SAP BW and ETL

I have a client who implemented Siebel 6.3 Consumer Products. The client preferred to extract data from Siebel to their SAP BW (a datawarehouse product from SAP) periodically in daily, weekly and monthly. The data involved are in millions of records in a monthly basis. The data must be aggregated based on complex and configurable rules, and transformed into CSV format accepted by SAP BW. Typically this is an ETL process (extract, transform and load). What is your recommedation of strategy and products in the market that are popular in the similar case?
SAP BW has built-in ETL capabilities. If you exceed the ability of the built-in ETL, which it sounds like you might, you can also add-on an ETL tool into the BW architecture. Other than the fact that many are using DataStage for purpose of integration with BW, I would see this as an otherwise normal ETL tool decision.

Since you would be exceeding the capabilities of BW's ETL, I assume you would be looking at the more robust ETL tools available which would include DataStage and Informatica.

Dig Deeper on Customer analytics

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchContentManagement

SearchUnifiedCommunications

SearchDataManagement

SearchEnterpriseAI

SearchERP

Close