Show TOC

Configuring BI Java ConnectorLocate this document in the navigation structure

Use

To prepare a data source for use with the BI Java SDK or with UD Connect, you first need to configure the properties in BI Java Connector used to connect to the data source. You use the SAP NetWeaver Administrator to do this.

To create and configure systems in the portal for use in Visual Composer scenarios, seeRunning the System Landscape Wizardand Editing Systemsin the SAP Enterprise Portal System Landscape documentation.

Prerequisites
  • In order to configure the properties for a data source based on a BI Java Connector, the connector's resource adapter archive (RAR file) (delivered as part of Universal Data Integration, or UDI) and the Metamodel Repository (MMR) that the connectors rely on must first be deployed to the server. UDI and MMR are part of usage type AS-Java (Application Server - Java) in SAP NetWeaver 7.1.
  • Further prerequisites can be found in the documentation on the Connector.

    More information:BI JDBC Connector

Procedure
  1. Use the SAP NetWeaver Administrator to configure the relevant connector properties. Locate the connector on the Resources List as follows:
    • BI JDBC Connector: com.sap.ip.bi.sdk.dac.connector.jdbc

    SeeManaging Resource Adaptersfor instructions on configuring connector properties.

  2. Configure a reference to your data source's JDBC driver on the Loader References tab in the SAP NetWeaver Administrator.

    SeeManaging Resource Adaptersfor details.

Result

Your BI Java Connector properties are configured and your data source is ready to use.

Testing the Connections

After you have configured the BI Java Connector, you can perform a rough installation check by displaying the page for the connector in your server. Perform the tests for the connector by calling the URL(s) in the table below:

Connector Test Servlets

Connector

URL

Successful Result

BI JDBC Connector

http://<host>:<port>/TestJDBC_Web/TestJDBCPage.jsp

A list of tables is displayed

These tests are designed to work with the default installation of the BI Java Connector. Cloned connectors with new JNDI names are not tested by these servlets.

JNDI Names

When creating applications with the BI Java SDK, refer to a connector by its JNDI name: The BI JDBC Connector has the name SDK_JDBC.

Cloning the Connections

You can clone an existing connection by using the Clone button in the toolbar.

For Universal Data Connect (UD Connect) only:

If you enter the name of the resource adapter in the duplication process, you have to add the prefix SDK_ to the JNDI name. Only use uppercase letters in the name. This ensures that UD Connect can recognize the connector.