The below content explains step by step procedure of establishing connection between SAP ECC and SAP Data Services.
followed by creating datastore from SAP Dataservices which connects SAP ECC.
Steps to Connect BODS and SAP:
Go to the below directory in the Dataservices Application Server.
D:\Program Files (x86)\Business Objects\BusinessObjects Data Services\Admin\R3_Functions\transport
(We require the below files to get connected to SAP ECC and view the metadata of SAP ECC from SAP Dataservices)
Go to transaction STMS.
Press F5 or click on Truck icon under Transport management system.
Go to Extras in the toolbar—>other requests—>Add.
You will see a popup window as Add Transport Request to Import Queue.
You will see popup window with a single tab Restrictions, under this tab you should notice our co-file R63K900086.
Click on Tick mark
Select Queue tab then select Start Import at upper left corner or simply press Ctrl+F9.
Observe tick mark under St(status)
Click on Test/Execute or press F8.
there, fill the following details:
Data Store Name: SAP_DS (some meaning full name)
Data Store Type: SAP Applications
Application Server: XXXXX (ECC app server details, we should get from basis/customer)
User name: XXXXX (we should get from basis/customer)
Password: XXXX (we should get from basis/customer)