What is the difference between Data Intagrator & Rapid marts?
How do we implement he rapid marts in our projects/
BONEW (BOB member since 2004-09-03)
What is the difference between Data Intagrator & Rapid marts?
How do we implement he rapid marts in our projects/
BONEW (BOB member since 2004-09-03)
Data Integrator is an ETL tool, used to extract transform and load your data.
Rapid Marts looks to be a set of pre-built extraction processes for a few specific applications (SAP, Peoplesoft, Oracle, Siebel). I know very little about Rapid Marts so could be entirely wrong here.
If the data you are looking to analyse is from one of those applications then I’d advise looking in to the Rapid Marts in more detail. DI is a general ETL tool and has plug-ins to many datasources, yuo have the flexibility to do what you want with it…but then you have the overhead of designing what you want to do and building it too.
HuwD (BOB member since 2007-04-19)
Are any documents posted for Rapit Marts in the web?
Billy_qing (BOB member since 2007-11-16)
Just to be clear: Rapid Marts are pre-built marts (data mart table structures, and ETL jobs), and they use DI as the ETL tool.
dnewton (BOB member since 2004-01-30)
Also to be even clearer
When you buy a RapidMart what you actually get is:
The DI ETL Code to populate a Datamart
DDL Code to generate the mart tables
A pre-defined Universe to site on top of the mart
and a set of pre-built Webi reports for the mart.
I’ve implented a few of them and they certainly make life much easier when dealing with complex packages such as Oracle Apps.
ScoobyDoo (BOB member since 2007-05-10)
Having done both, IMHO the benefit is even more with SAP extraction, because the structure of SAP DF’s and R/3 transforms is so different than what you run into with Oracle to Oracle.
The reports tend to be of little value, the UNV’s are not frequently updated, either - the main value is the initial DDL/Schema and the DI Objects, that proved to be a huge jump start for SAP-based Oracle DW at my current client.
Sales and Distribution, Inventory were deployed. Both required additional work over time, but were a pretty solid basis for getting up and running quickly with basic reporting.
Reliability of the DI generated ABAP has been excellent, too. Very few issues in the DI objects other than some efficiency problems, easily corrected.
HTH
Stracy (BOB member since 2006-07-14)