Scenario:-
we are supposed to extract the data from SAP enviroment i.e.SAP BW/BI, SAP R/3, SAP ERP, SAP MDM using BusinessObjects DataServices 3.0
My Understanding:-
what i have understood is that we can easily extract data from SAP BI/BW, SAP R/3 sources by simply creating a datstore for that.
Doubts:-
Is it necessary to have basic understanding about SAP sources?
Is it necessary to understand these different SAPs ?
Is it necessary to install SAP GUI on the machine which has jobserver?
But how we need to proceed with SAP MDM is again a issue?
is it required to get the separate license for MDM?
is it required to install SAP MDM an jobserver machine?
Is it necessary to have basic understanding about SAP sources?
—Yes and No. DI shields you a lot but on the other hand, if you don’t know where the data comes from, picking the right table is a challange. So I would say, you do not need to know SAP but have an ABAP programmer from your company at hand.
Is it necessary to understand these different SAPs ?
---- SAP ERP and SAP R/3 is the same, everything else is different. SAP BI/BW shares at least the foundation with SAP ERP.
Is it necessary to install SAP GUI on the machine which has jobserver?
---- Technically the librfc32.dll is required only but…
But how we need to proceed with SAP MDM is again a issue?
----MDM is completely different product. You can interface with it via Data Services but that’s it.
is it required to get the separate license for MDM?
---- Yes.
is it required to install SAP MDM an jobserver machine?
---- No.
We are supposed to extract the data from Oracle, MSSQL Server and SAP
What we did:-
Since, Oracle and MSSQL are relational databases. So we easily created a datastore and extracted the data by simply giving the appropriate credentials like servername, username and password.(provided we have to install oracle and MS SQL client to connect to the datasourcces)
As we did with oracle and MS SQL, so thought, same would be applicable for the SAP too (installation of client).
Then we have installed SAP GUI.
What we are trying to connect a server that is in different domain and we are working in secured domain. so opened the following ports to connect to SAP server 3303,3603,3203,3903,50300
Process we chosse to connect to SAP BW:-
Insatll SAP GUI
2.Create a datastore
Note:-
we tried with librfc32.dll file too. but it ask for GUI inteface.so we did.
Problem :-
When we create a datastore and provide following credentials
Datastorename:- SAP_BW_SRC_DS
Datastoretype: SAP BW Source
R/3 Application server name:- IP.IP.IP.IP
Username: XYZ
password:-xyz
ERROR:-
please make sure the SAP R/3 server is running and the login information is correct.!
and When we try to login via SAP GUI it works.
Doubt:-
so what does that mean?
Process we chosen to connect to SAP BW is not correct?
Do we need to install INTEGRATION KIT?
What is the information behind the SAPLogon? Please provide the list including router strings etc. The client you specify when you actually login to SAPGUI.
And what are the settings for the datastore?
No you don’t need anything else, no integration kit nothing.
btw, the SAP user, what permissions does he have? Make him a developer (S_A_UTIL & S_DEVELOP) for ABAP in SAP.
Just want to mention that BO DS XI 3.0 provides three type of datastore for connecting to SAP
R/3
SAP BW Source
SAP BW Target
I have tried with all the three. but one doubt still is in my back of mind
When i configure the datasore for SAP BW Source, it ask for the working directory on SAP server .
Error comes when you are leaving the filed empty. but if provide anything… any thong means directory which lie on your local computer… it works…
I am not able to understand when does that working directory on SAP server comes into picture ?
Case 1
Datastore type : -SAP BW SOurce
I am able to import only tables not the iDOCS, if i try to import iDocs then it prompts me an error
BO DI -1112368:Error:cannot import Infoarea .please verify the name of the info area.
Case 2
Datastore type: -R/3
here iam not able to open the Hierarchies again it prompts me an error says
BODI- 1112346:Error:Cannot load meta data tree <name=Hierarchies>
ABAP program < %link_dir%\admin\abap\treenavgt40.abp> syntax error: < Field"SETHEADER-FILENAME" is unknown. It is neit.>.
The transport file is the file the ABAP program creates with the data in case you use an R/3 dataflow. Unfortunately it is a mandatory parameter even if it is not used at all.
In short, before an R/3 dataflow will work, this transport file parameters have to be set correctly.
R/3 hierarchies are R/3 Set-Table based hierarchies, not BW hierarchies. If you use an R/3 datastore against a SAP BW system, there are no Set-Hierarchies, hence the error.
(BOB member since 2009-04-17)
(BOB member since 2004-12-17)