Continuing on from my prior post on SAP Connectivity Part 2, the next step is to import the transport requests into SAP. This is where you need the assistance of the SAP Basis Administrator, so make sure you have one on hand to assist through this process!

The SAP Add on consists of three transport packages. These are delivered during the Jedox installation with SAP connectivity which can be found in the following directory: \Jedox\Jedox Suite\tomcat\webapps\etlserver\config\sap\sap-trreq of your Jedox installation path. The below screenshot shows these transport requests:

Since these transport packages contain RFC function modules etc, these need to be copied into the SAP Application server. What you need to copy to the SAP Application server is largely dependent on what you need to extract from SAP into Jedox.

If you need to extract ERP data from SAP ERP (R/3) such as Cost Centres, Profit Centres etc. you will need to have eltsap_erp_trreq.zip and etlsap_rfc_trreq.zip copied to the SAP Application server.

If  you need to extract SAP BW components such as Infoobjects, Infocubes, then you will need to have eltsap_bw_trreq.zip and etlsap_rfc_trreq.zip copied to SAP Application server.

In either case, you will need to unzip the relevant files, and copy the files to the SAP Application Server. Typically this would be done by the SAP Basis Administrator.

After you unzip the zip files, you will see prefixed with K9 and R9. You will need to do the following:

– Files starting with K9*,  copy to directory <drive>:\usr\sap\trans\cofiles

– Files starting with R9*, to directory  <drive>:\usr\sap\trans\data

The transport files need to be imported into SAP system using Transport Manager (transaction code: STMS) , this is something SAP Basis Administrator typically performs.

Once the transport requests have been imported into SAP, you can then establish connectivity in Jedox through to the SAP system. In Jedox ETL, create a Connection step using “SAP” Connection type, and enter the relevant details as shown in the screen shot below:

Click the ‘test’ icon to test connection. The following screen should come up if connection is successful.

If you get to this point, you are now connected to SAP from Jedox . Congratulations!!

In my next post, we will cover off some of the SAP extract types that you can use in Jedox ETL.