About the BI SAP Query Connector

This document is called howto.html and is delivered in the resource adapter archive (RAR file) bi_sdk_sapq.rar. You may extract howto.html to a separate location for your reference before deploying the resource adapter archive. Refer to this document for properties configuration information.

This document contains the following information:


Overview

SAP Query is a component of SAP's Web Application Server that allows you to create custom reports without any ABAP programming knowledge. The BI SAP Query Connector uses SAP Query to allow applications created with the BI Java SDK to access data from these SAP operational applications. This connector is fully compliant with the J2EE Connector Architecture (JCA).

You can also use the BI SAP Query Connector to make these data sources available in SAP BI systems via UD Connect, or to create systems in the portal.

The BI SAP Query Connector implements the BI Java SDK's IBIRelational interface.

 

System Requirements

Requirement Detail
Software prerequisites SAP JCo
Supported data sources SAP systems (R/3) 4.6C or greater
Supported systems Systems supported by SAP JCo
Supported application server SAP NetWeaver

 

Connection Properties

Connection Constant * Property Name Description Examples
SapqConnectionConstants.
USERNAME
UserName Data source username. (your username)
SapqConnectionConstants.
PASSWORD
Password Data source password. (your password)
SapqConnectionConstants.
LANGUAGE
Language Two-letter abbreviation of language. Sets the logon language for your system, and also specifies the language of exceptions evoked on the BI Java SDK layer. EN = English
DE = German
SapqConnectionConstants.
QUERYAREA
QueryArea Single-character value (char) specifying whether the SAP Query area is global (client-independent) or local (client-dependent). Default value is local. X = global
[blank] = local
SapqConnectionConstants.
CLIENT
Client Client specified as three-digit integer. 000
SapqConnectionConstants.
MESSAGESERVER
MessageServer Hostname for message server. server1.mydomain.com
SapqConnectionConstants.
APPLICATIONSERVER
ApplicationServer Hostname for application server. server1.mydomain.com
SapqConnectionConstants.
SYSTEMNUMBER
SystemNumber Two-digit integer identifying the R/3 instance. 00
SapqConnectionConstants.
SERVERGROUP
ServerGroup Logon group for load balancing. a string, such as PUBLIC or SPACE
SapqConnectionConstants.
R3NAME
R3Name R/3 name. OSS

* Note: For the set of connection properties relevant for your system, refer to the JCo documentation in your JCo download.

If you have trouble establishing a connection to a server that does not have a PUBLIC logon group, try removing the properties for R3Name and ServerGroup. See the JCo documentation on the SAP Service Marketplace (http://service.sap.com/connectors/) for more connection troubleshooting information.

 

JNDI Name

Refer to this connector in your application by its JNDI name: SDK_SAPQ. For code samples, refer to the Connection Interfaces Javadocs package in the documentation set delivered with the BI Java SDK.

You may clone an existing connection using the Web Application Server's Visual Administrator. If you are using this connector with UD Connect, when entering the resource adapter name during the cloning process, you must prefix the JNDI name with "SDK_" and use only all capital letters in order for UD Connect to properly recognize the connector.

 

Additional Information

For more information about Sun's J2EE Connector Architecture, see:

For more information about the connection architecture in the BI Java SDK, refer to the following documentation in the SDK distribution package:

  • Connection Interfaces Javadocs package
  • Developer's Guide (PDF)

For more information about SAP Query, see: