6.5 SAP Data Source

To connect to an SAP data source, you must first instal the SAP Java Connector (JCo) drivers on your system. Follow the steps below:

1. Download and extract the JCo software to a new directory, e.g., C:\SAPJCo.

2. Copy the following files to the C:\WINDOWS\SYSTEM32 directory:

librfc32.dll

sapjcorfc.dll

3. (Optional) If your Windows environment does not have the .NET SDK installed, copy the following .NET files to the C:\WINDOWS\SYSTEM32 directory:

msvcp71.dll

msvcr71.dll

4. Add the sapjco.jar file to your Style Studio classpath. (See Configuring the Style Studio Classpath in Getting Started.)

5. Place a copy of the sapjco.jar file into the webapps\sree\WEB-INF\lib directory.

Once you have finished the above configuration, create the SAP data source by following the steps below:

1. Click the 'New' button in the Style Studio toolbar. This opens the 'New Asset' dialog box.

2. In the left panel, select the 'Data Source' node. In the right 'Types' panel, select 'SAP', and click 'OK'.

 

This opens the 'SAP Data Source Wizard'.

3. Select the General tab. Enter a 'Name' and optional 'Description' for the data source.

4. Select the Driver tab, and enter the requested connection information.

The following values are required: 'Application server host', 'Cli­ent', 'User name', 'Password', and 'System number.' See the SAP documentation for further information about the connection param­eters.

 

5. Click 'Finish' to close the Wizard. Style Studio displays the completed SAP data source.

<< 6.4.3 Defining a Java Object Data Source © 1996-2013 InetSoft Technology Corporation (v11.4) 6.6 Querying Non-relational Data Sources >>