Wiki source code of Connecteur SAP BEx

Last modified by Aurelie Bertrand on 2026/01/12 15:14
Show last authors
1 {{ddtoc/}}
2
3 ----
4
5 (% class="box warningmessage" %)
6 (((
7 DigDash's SAP BEx connector requires an SAP account to download their java connector: [[JCO>>https://support.sap.com/en/product/connectors/jco.html]].
8 )))
9
10 = Requirements =
11
12 * The SAP JCO connector: [[https://support.sap.com/en/product/connectors/jco.html]]
13
14 = Enabling the data source =
15
16 The SAP BEx data source is deactivated by default in DigDash Enterprise.
17 To deploy the SAP BEx connector, you must :
18
19 1. Stop the DigDash server.
20 1. Deploy the following files in the **$CATALINA_HOME/shared/lib** folder **:**
21 (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).
22 1*. **libsapjco3.so** (linux) or **sapjco3.dll** (windows) and **sapjco3.jar**
23 1*. **ddsapbex-1.0.0.jar **retrieved from the directory <digdash_install>add-ons/sapbex
24 1. Configure the **shared.loader** property in the **$CATALINA_BASE/conf/catalina.properties** file as follows:
25
26 (((
27 {{code language="sh" cssClass="notranslate"}}
28 shared.loader="${catalina.base}/shared/lib","${catalina.base}/shared/lib/*.jar","${catalina.home}/shared/lib","${catalina.home}/shared/lib/*.jar"
29 {{/code}}
30 )))
31
32 (((
33 (% start="4" %)
34 1. Configure the **java.library.path** by adding the following option to the **CATALINA_OPTS**:
35
36 {{code language="sh" cssClass="notranslate"}}
37 -Djava.library.path=/chemin/vers/shared/lib
38 {{/code}}
39 )))
40
41 (((
42 (% start="5" %)
43 1. Activate the data source :
44
45 In the file **<webapps>/ddenterpriseapi/WEB-INF/classes/resources/config/tabledsrepository.xml**
46
47 {{code language="xml" cssClass="notranslate"}}
48 <!-- <TableDataSource id="SAPBEXDS" name="$ui.SAPBEX.Popup" shortName="$ui.SAPBEX.Short" description="$ui.SAPBEX.DSDesc" iconBaseName="ds-sapbex.png" manufacturer="DigDash"
49 class="com.digdash.tabledatasources.SAPBEXDataSource"
50 uiclass="com.digdash.userinterface.dialogs.SAPBEXPreviewPanel"
51 categ="$ui.DsCategDB">
52 <properties>
53 </properties>
54 </TableDataSource>
55 -->
56 {{/code}}
57
58 should become :
59
60 {{code language="xml" cssClass="notranslate"}}
61 <TableDataSource id="SAPBEXDS" name="$ui.SAPBEX.Popup" shortName="$ui.SAPBEX.Short" description="$ui.SAPBEX.DSDesc" iconBaseName="ds-sapbex.png" manufacturer="DigDash"
62 class="com.digdash.tabledatasources.SAPBEXDataSource"
63 uiclass="com.digdash.userinterface.dialogs.SAPBEXPreviewPanel"
64 categ="$ui.DsCategDB">
65 <properties>
66 </properties>
67 </TableDataSource>
68 {{/code}}
69 )))
70
71 (% start="6" %)
72 1. Start the DigDash server
73
74 = Creating an SAP BEx data source =
75
76 1. Select the SAP BEx data source when creating the new Studio data model.
77 1. (((
78 Enter the connection information for your SAP BW server:
79
80 * **Host **: the host name of the SAP server
81 * **System Number**: the two-digit number representing the SAP system number
82 * **Customer** Number: the three-digit number representing the SAP customer number
83 * **User**: the SAP user name
84 * **Password**: the SAP user's password
85 )))
86 1. 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.
87 1. 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.
88 1. Click on the **Preview** button, then check your data in the **Preview** section.
89 1. Click **Next**, then complete the source configuration by specifying a name and configuring the additional options common to all DigDash data sources.