Hi all
I am trying to use BO XI 3.0 data integrator as an ETL tool.
I have SAP/R3 and SAP BI 7.0 as datawarehouse. Reading data from R3 is ok but I couldnt manage to write data to BI system. I followed guide xi3_ds_sap_supplement_en.pdf which came with installation, but terms and some follow steps are obsolete. I really need some detailed information about defining SAP BI as target.
As an additional info I checked ‘The Data Services RFC server’ and ‘The Data Services Job Server’. They are running no problem here.
Also SAP BI and BO DI can see each other. I managed to define SAP BI as source in BO DI and I can get data from SAP BI .
So you are saying the RFCSVR registered itself inside SAP as a connection test from SAPGUI is working.
Did you export a bat file via the webadmin and define itslocation inside SAP? What are the error messages?
One thing I found is that the query, unlike with regular tables, has to have all columns of BW, probably even in the same order. So I mapped the additional ones to NULL in the query.
Hi wdaehn
First of all thx for answer. I know my question was a general one. Because I dont get any error message. So I thought I messed up everything. I dont have any knowledge about using BO DI with SAP BI (BW) system. The only document I have is the original XI 3.0 document. I searched SAP sites and some BO sites but couldnt find any other document. I am in contact with local SAP and BO office but they couldnt help me either.
Let me give you some details about project. I have one SAP R/3, 3 SQL servers and one flat file as source system. Target system is SAP BI (BW) datawarehouse.
Normally we were planning to get data with SAP BI. As you know SAP BI datawarehouse has its own ETL tool. But data volume of flat file is 20 million records per month. And we thought that if we use BO DI as ETL we may get better performance.
I manage to read all sources with BO DI but I couldnt write this data to SAP BI cubes. Document: xi3_ds_sap_supplement_en.pdf Chapter 10 page 176 “To create the job schedule (Info Package)” step. When I run the data package nothing happens.
What I am trying to do is, test both ETL tools compare them with all aspects. The question is, is it really worth to replace SAP BI ETL with BO DI? I mean the advantages and disadvantages, SAP BI ETL vs BO DI.
We would need to go through the details to figure out.
MY first statement would be, why would you use yet another tool to load BW if Netweaver can do it by itself? You can read a flat file, you can use Universal DB Connect to read plain tables.
Once you figured you need more than just table reads, e.g. joins, lookup, or more complex transformations, then you have the choice between creating views in the source database to hide the complexity, or ABAP programming, or using Data Integrator.
Performance wise I would not expect too much of a difference as DI calls the staging BAPIs to load BW. And if, BW will be a bit faster by today.
(BOB member since 2004-12-17)