on 09-15-2010 10:03 AM
Hi,
I have data in SAP R/3 system . i need to design a universe based on that R/3 system data. But we can't create a universe using R/3 data. what i need to do ?
What i know is, Either we need to covert R/3 system data to SAP BI system or we need to migrate that to SQL server using any ETL tool. Is it true ? If so which one is better?
Please help me on this issue as soon as possible.
Thanks in advance..
currently (you have the following options:
1. You load your R/3 data into an SAP BW and use universes based on BEx queries to create WebI reports
2. You can use SAP rapid marts. They contain Data integrator mappings (you need an installation of the DI for this) to extract and load your SAP R/3 data into a relational database. Additionally they provide universes (based on a relational schema) hich ill allo you to build WebI reports.
3. You can use the R/3 connector for the Data Federator (You need a DF installation for this). Please note that the R/3 connector is not yet a product rather just a PROTOTYPE. Take a look here: [original link is broken]
4. You can try to access the underlying database directly using the appropriate DB drivers. Please note that this is NOT RECOMMENDED. This way you cannot leverage security defined on the R/3 side in your WebI reports and you will not be able to access all data as available in R/3 since some of them are stored encoded/compressed in the underlying tables.
5. Instead of WebI you can use Crystal Reports and the R/3 drivers (eg. SAP Tables, Functions, Cluster) provided when installing the integration kit for SAP.
Since your data come from an SAP R/3 system the best option in my opinion is to load them into an SAP BW installation.
Regards,
Stratos
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You have to build your on data model on the SQL server and then fill it up using the ETL tool. I do believe that it can be faster to design the load processes that get your data into SAP BW than to build your own data model in a relational database from the scratch and then design the appropriate ETL processes to load the data. But this depends also from the exact requirements of your customer.
Regards,
Stratos
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.