Setting up a SAP connection

This section describes how to set up a SAP connection, if you plan to develop mobile applications using the SAP framework. This enables you to create a SAP element

To set up the SAP connection you must:

Configure the SAP connection using the SAP Java Connector (SAP JCo). SAP JCo is a toolkit that allows a Java application to communicate with any SAP system. The SAP Java Connector can be downloaded from the SAP Service Marketplace Web site by a registered SAP customer.
Modify the global.properties.xml file to enable SAP and identify ConnectionPools.
Create a property file for each ConnectionPool, and configure connection properties.

Details for each of these steps are provided in the procedures that follow. Once this is done, a SAP element can be created in Mobile Web Studio’s Application Builder. See the Mobile Application Development Tutorial and the Unwired Accelerator Developer’s Guide for information about using the SAP element.

Configuring the SAP Java connector

Open a Web browser window and enter the SAP Marketplace URL, currently:
```
https://websmp204.sap-ag.de/swdc
```
The Client Authentication window displays.
Select the certificate to use when connecting, and click OK. The Enter Network Password window displays.
Enter your registered SAP customer user name and password in the User Name and Password fields, and click OK. The SAP Service Marketplace window displays.
Select the SAP Java Connector link, and follow the installation instructions provided by SAP. When prompted, copy the .jar and .dll files to these locations:
- Copy sapjco.jar to SYBASE\UA80\tomcat\webapps\onepage \WEB-INF\lib.
- Copy librfc32.dll and sapjcorfc.dll to SYBASE\UA80\jdk1.5.x\jre\bin.
Close the Web browser.
Change to the SYBASE\UA80\tomcat\webapps\onepage \WEB-INF\classes directory.
As a backup, save a copy of the sapjco.properties file to a different name, such as template.sapjco.properties.
Using a text editor, open the sapjco.properties file and edit it for your environment. The SAP wizard uses information in the sapjco.properties file to connect to your SAP system.

Check the documentation that comes with the JCO package for information about the 30-40 properties you can set to define a SAP connection. Specifically see the Javadocs for the JCO.createClient (java.util.Properties) method. The six most commonly used properties are included in the file as a sample (for example, jco.client.client=400).
Save and close the file.

Modifying the global.properties.xml file for SAP

Modify the SAP-related properties in global.properties.xml.

ConnectionPools – a comma-separated list of connection pool names. Each connection pool must have a poolname.properties file defined as described in “Creating ConnectionPool property files.”

DefaultConnectionPoolName – identifies the connection pool to use for the default SAP connection. The default connection pool user must have sufficient SAP permission to access SAP metadata.

In a text editor, open global.properties.xml, located in SYBASE\UA80\tomcat\webapps\onepage\config.
Search the file for SAPGroup.
Look for: <Property name="ConnectionPools". By default, ConnectionPools is set to “sapjco.” The default ConnectionPool “sapjco” has a corresponding property file sapjco.properties in which SAP connection properties are defined. Each ConnectionPool name in the list must have its own property file, as described in “Creating ConnectionPool property files.”

Identify the ConnectionPools you need for SAP connection, using SAP documentation, and change the value as necessary.
Look for: <Property name="DefaultConnection PoolName".

By default, DefaultConnectionPoolName is set to “sapjco.”

Determine which ConnectionPool to use as the default SAP connection from the list, and change the value as necessary. The default connection pool user must have certain SAP permissions in order to access SAP metadata. See “SAP property group” for information about the permissions needed.
Save and close the file.

Creating ConnectionPool property files

For each ConnectionPool listed in the global.properties.xml file, there should be a poolname.properties file in SYBASE\UA80\tomcat\onepage\WEB-INF\classes. Use the sapjco.properties file (or template.sapjco.properties file) as a base, and modify the ConnectionPool connection properties, using information in the JCO package Javadocs as a guide.

In a text editor, open sapjco.properties (located in SYBASE\UA80\tomcat\webapps\onepage\WEB-INF\classes).
Save the file in the same directory, using the following naming format:
```
poolname.properties
```
Substitute one of the ConnectionPool names you established in the global.properties.xml file for poolname.
Modify the file by setting up the connection properties for the SAP connection. The following properties are included in the file as an example. Check the Javadocs for information about these properties, and many more.
```
jco.client.client=400
jco.client.user=sap
jco.client.passwd=1sap
jco.client.lang=EN
jco.client.ashost=sap.try.sybase.com
jco.client.sysnr=00
```
Save and close the file.