Jedox to SAP Connectivity Part 2 – Setting up the Jedox SAP Connector

Continuing on from my prior post on SAP Connectivity Part 1, the next step is configuring the SAP Connector in Jedox ETL.

After you have successfully installed SAP JCo Connector, you need to select the SAP Connector component during the Jedox all-in-one install process. This will install the Jedox ETL SAP Connector where it establishes the connection to SAP and supports several extract types.

At the time of the Jedox installation, you need to tick the check box for SAP Connectivity:

sap_part2_1
The following screen comes up where you would need to specify the directory path where the SAP JCO connector files are stored. Select the location:

sap_part2_2

During the installation of the SAP Java Connector, the files sapjco3.jar and sapjco3.dll are installed on the server. When you install Jedox with the SAP Connector, the installer copies these files to the folder {Jedox-Suite-install-path}\tomcat\webapps\etlserver\WEB-INF\lib_external.

For Jedox to be able to connect to SAP, you need to confirm that your Jedox Suite licence key has SAP Connectivity enabled. Go to System Manager , then click on Licences:

sap_part2_4

If you do not see SAP Connector listed, you cannot connect to SAP via the Jedox SAP Connector. If it is not listed, please contact your Jedox representative for further information.

Ok, we are nearly there! In Part 3, I will step you through how to establish connectivity directly to the SAP system and confirm your connection in Jedox ETL. At ths point, We will need assistance from the SAP team (the BASIS Administrator) to import transport requests.

2 thoughts on “Jedox to SAP Connectivity Part 2 – Setting up the Jedox SAP Connector

  1. Pingback: Jedox to SAP Connectivity Part 1 – The SAP Java Connector | the naked leaf

  2. Pingback: Jedox to SAP Connectivity Part 3 – Importing Transport Requests | the naked leaf

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s