SAP BEx connector

Last modified by Aurelie Bertrand on 2026/01/12 15:14

DigDash's SAP BEx connector requires an SAP account to download their java connector: JCO.

Requirements

Enabling the data source

The SAP BEx data source is deactivated by default in DigDash Enterprise.
To deploy the SAP BEx connector, you must :

  1. Stop the DigDash server.
  2. Deploy the following files in the $CATALINA_HOME/shared/lib folder :
    (To find the CATALINA_HOME value, you can search for CATALINA_HOME in the Tomcat logs, or run the catalina.sh or catalina.bat file with the version argument).
    • libsapjco3.so (linux) or sapjco3.dll (windows) and sapjco3.jar
    • ddsapbex-1.0.0.jar retrieved from the directory <digdash_install>add-ons/sapbex
  3. Configure the shared.loader property in the $CATALINA_BASE/conf/catalina.properties file as follows:
shared.loader="${catalina.base}/shared/lib","${catalina.base}/shared/lib/*.jar","${catalina.home}/shared/lib","${catalina.home}/shared/lib/*.jar"
  1. Configure the java.library.path by adding the following option to the CATALINA_OPTS:
-Djava.library.path=/chemin/vers/shared/lib
  1. Activate the data source :

In the file <webapps>/ddenterpriseapi/WEB-INF/classes/resources/config/tabledsrepository.xml

<!-- <TableDataSource id="SAPBEXDS" name="$ui.SAPBEX.Popup" shortName="$ui.SAPBEX.Short" description="$ui.SAPBEX.DSDesc" iconBaseName="ds-sapbex.png" manufacturer="DigDash"
     class="com.digdash.tabledatasources.SAPBEXDataSource"
     uiclass="com.digdash.userinterface.dialogs.SAPBEXPreviewPanel"
     categ="$ui.DsCategDB">
 <properties>
 </properties>
</TableDataSource>
 -->

should become :

<TableDataSource id="SAPBEXDS" name="$ui.SAPBEX.Popup" shortName="$ui.SAPBEX.Short" description="$ui.SAPBEX.DSDesc" iconBaseName="ds-sapbex.png" manufacturer="DigDash"
    class="com.digdash.tabledatasources.SAPBEXDataSource"
    uiclass="com.digdash.userinterface.dialogs.SAPBEXPreviewPanel"
    categ="$ui.DsCategDB">
<properties>
</properties>
</TableDataSource>
  1. Start the DigDash server

Creating an SAP BEx data source

  1. Select the SAP BEx data source when creating the new Studio data model.

  2. Enter the connection information for your SAP BW server:

    • Host : the host name of the SAP server
    • System Number: the two-digit number representing the SAP system number
    • Customer Number: the three-digit number representing the SAP customer number
    • User: the SAP user name
    • Password: the SAP user's password
  3. Click on the List queries button, then choose the query you want from the tree. Select the columns you want from the list on the right using the checkboxes.
  4. If you have variables to fill in, click on the Variables. .. button and a dialog box will open in which you can fill in values.
  5. Click on the Preview button, then check your data in the Preview section.
  6. Click Next, then complete the source configuration by specifying a name and configuring the additional options common to all DigDash data sources.