SAP BEx Connector

Last modified by jhurst on 2022/04/28 16:42


The SAP BEx connector requires an SAP account to download their java connector : JCO.

Prerequisites

Activating the data source

To deploy the SAP BEx connector, you will need to:

  • Stop the DigDash server
  • Deploy the libsapjco3.so (linux) or sapjco3.dll (windows) and sapjco3.jar files in the $CATALINA_HOME/shared/lib folder. To find the value of CATALINA_HOME, you can look for CATALINA_HOME in Tomcat's startup logs, or you can execute the catalina.sh or catalina.bat file with the version parameter.
  • Configure the shared.loader property in the $CATALINA_BASE/conf/catalina.properties file:

    shared.loader="${catalina.base}/shared/lib","${catalina.base}/shared/lib/*.jar","${catalina.home}/shared/lib","${catalina.home}/shared/lib/*.jar"
  • Configure java.library.path by adding the following option to the CATALINA_OPTS:

    -Djava.library.path=/path/to/shared/lib
  • Activate the data source in DigDash:
    in the <webapps>/ddenterpriseapi/WEB-INF/classes/resources/config/tabledsrepository.xml file:

    <!-- <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 be changed to:

    <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>
  • Start the DigDash server

Creating an SAP BEx data source

  1. Select the SAP BEx data source among the data source list in the Studio:
    SAPBEx_datasources.png
  2. Provide the SAP BW connection information :

    • Host: the SAP server's host name
    • System number: the two digit SAP system number
    • Client: the three digit SAP client number
    • User: the SAP user name
    • Password: the SAP user's password
    SAPBEx_connection_en.png
  3. Click on the List queries button, then choose the desired query in the tree. Select the desired columns in the list on the right by using the checkboxes.
    SAPBEx_query_en.png
  4. If you have variables you want to specify, click on the Variables... button and a dialog box will appear in which you can specify values for the query's variables.
    SAPBEx_filterdialog_en.png
  5. Click on the Preview button and check the data in the Preview section.
  6. Click on Next then finish configuring the data source by specifying a name and configuring the various extra options common to all DigDash data sources.