Wiki source code of Connecteur SAP BEx

Last modified by Aurelie Bertrand on 2022/04/14 19:07
Show last authors
1 {{ddtoc/}}
2
3 ----
4
5 (% class="box warningmessage" %)
6 (((
7 The 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 = Prerequisites =
11
12 * SAP's JCO connector : [[https://support.sap.com/en/product/connectors/jco.html]]
13 * DigDash XXXX or above
14
15 = Activating the data source =
16
17 To deploy the SAP BEx connector, you will need to:
18
19 * Stop the DigDash server
20 * 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.
21 * (((
22 Configure the **shared.loader** property in the **$CATALINA_BASE/conf/catalina.properties** file:
23
24 {{code language="sh" cssClass="notranslate"}}
25 shared.loader="${catalina.base}/shared/lib","${catalina.base}/shared/lib/*.jar","${catalina.home}/shared/lib","${catalina.home}/shared/lib/*.jar"
26 {{/code}}
27 )))
28 * (((
29 Configure **java.library.path** by adding the following option to the **CATALINA_OPTS**:
30
31 {{code language="sh" cssClass="notranslate"}}
32 -Djava.library.path=/path/to/shared/lib
33 {{/code}}
34 )))
35 * (((
36 Activate the data source in DigDash:
37 in the **<webapps>/ddenterpriseapi/WEB-INF/classes/resources/config/tabledsrepository.xml** file:
38
39 {{code language="xml" cssClass="notranslate"}}
40 <!-- <TableDataSource id="SAPBEXDS" name="$ui.SAPBEX.Popup" shortName="$ui.SAPBEX.Short" description="$ui.SAPBEX.DSDesc" iconBaseName="ds-sapbex.png" manufacturer="DigDash"
41 class="com.digdash.tabledatasources.SAPBEXDataSource"
42 uiclass="com.digdash.userinterface.dialogs.SAPBEXPreviewPanel"
43 categ="$ui.DsCategDB">
44 <properties>
45 </properties>
46 </TableDataSource>
47 -->
48 {{/code}}
49
50 should be changed to:
51
52 {{code language="xml" cssClass="notranslate"}}
53 <TableDataSource id="SAPBEXDS" name="$ui.SAPBEX.Popup" shortName="$ui.SAPBEX.Short" description="$ui.SAPBEX.DSDesc" iconBaseName="ds-sapbex.png" manufacturer="DigDash"
54 class="com.digdash.tabledatasources.SAPBEXDataSource"
55 uiclass="com.digdash.userinterface.dialogs.SAPBEXPreviewPanel"
56 categ="$ui.DsCategDB">
57 <properties>
58 </properties>
59 </TableDataSource>
60 {{/code}}
61 )))
62 * Start the DigDash server
63
64 = Creating an SAP BEx data source =
65
66 1. Select the SAP BEx data source among the data source list in the Studio:
67 [[image:SAPBEx_datasources.png]]
68 1. (((
69 Provide the SAP BW connection information :
70
71 * Host: the SAP server's host name
72 * System number: the two digit SAP system number
73 * Client: the three digit SAP client number
74 * User: the SAP user name
75 * Password: the SAP user's password
76 )))[[image:SAPBEx_connection_en.png]]
77 1. 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.
78 [[image:SAPBEx_query_en.png]]
79 1. 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.
80 [[image:SAPBEx_filterdialog_en.png]]
81 1. Click on the **Preview** button and check the data in the **Preview** section.
82 1. 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.