Show TOC

Connecting Non-SAP Systems to Visual Composer with the BI JDBC templateLocate this document in the navigation structure

Use

The Java Database Connectivity (JDBC) API is the industry standard for database-independent connectivity between the Java programming language and a wide range of databases - SQL databases and other relational data sources, like spreadsheets or flat files. The JDBC API provides a call-level API for SQL-based database access.

The BI JDBC system template provides business intelligence functionality to systems you create based on JDBC-compliant data sources. The template for a BI JDBC system defines the specific parameters needed to connect to these data sources, contains a reference to the BI JDBC Connector, and a reference to the JDBC driver for your data source. The BI JDBC system inherits these properties. Some have default values, while others need to have their values set. You edit the system by inserting the required property values and modifying default values if necessary.

The BI JDBC Connector allows you to connect Visual Composer applications to over 220 JDBC drivers, supporting data sources such as Teradata, Oracle, Microsoft SQL Server, Micorsoft Access, Microsoft Excel, DB2 and text files like CSV. The JDBC Connector is fully compliant with the J2EE Connector Architecture (JCA).

Procedure

Deploying a JDBC Driver

  1. Download a JDBC driver, for example. from http://developers.sun.com/product/jdbc/driversInformation published on non-SAP site

  2. Log on to the SAP NetWeaver Administrator with an administrator user: http://<host>:<port>/nwa

  3. Choose Start of the navigation path Configuration Management Next navigation step Infrastructure Next navigation step Application Resources End of the navigation path.

  4. Choose Start of the navigation path Create New Resource Next navigation step Deploy New JDBC Driver End of the navigation path.

  5. Select a name and choose Add New Driver File to import the JDBC driver file.

  6. Save the new JDBC Driver.

Maintaining Resource Adapter

  1. Log on to the SAP NetWeaver Administrator with an administrator user: http://<host>:<port>/nwa

  2. Choose Start of the navigation path Configuration Management Next navigation step Infrastructure Next navigation step Application Resources End of the navigation path.

  3. Choose Start of the navigation path Show Next navigation step All Resource Adapters End of the navigation path .

  4. Select the resource adapter com.sap.ip.bi.sdk.dac.connector.jdbc .

  5. Choose Start of the navigation path Resource Details Next navigation step Loader References End of the navigation path.

  6. Select Add New Reference . The name of the reference must be made up of the string library: and the driver name.

  7. Save the new reference.

Creating a System Object based on Template BI JDBC System

  1. Log on to the portal with an administrator user: http://<host>:<port>/irj

  2. Choose Start of the navigation path System Administration Next navigation step System Configuration Next navigation step System Landscape End of the navigation path. In the context menu for Portal Content , choose Start of the navigation path New Next navigation step System (from template) End of the navigation path.

  3. In tab New System select template BI JDBC System .

  4. Enter the system name, system ID, system ID prefix and description and click Next .

  5. Maintain System Object Properties .

  6. Maintain the properties in the following categories to create a system alias:

    • Category BI/Business Intelligence : BI Directory Provider: Yes

    • Category Connection Properties :

      • Connection URL: URL string specifying the location of a database (e.g. jdbc:sqlserver://<servername>:<port>;databaseName=AdventureWorks)

      • Driver class name: class name of the JDBC driver (e.g. com.microsoft.sqlserver.jdbc.SQLServeDriver)

    • Category User Management : User Mapping Type: admin, user

Maintaining the User Mapping for the Logon to the Source System

  1. Log on to the portal with an administrator user: http://<host>:<port>/irj .

  2. Choose Start of the navigation path User Administration Next navigation step Identity Management End of the navigation path.

  3. Search for the user and maintain the User Mapping for System Access .

  4. Select the system object created in step 3 and enter the user ID and password used to log on to the source system.

Testing the Connection

  1. Log on to the Portal with an administrator user: http://<host>:<port>/irj .

  2. Choose Start of the navigation path Administration Next navigation step System Configuration Next navigation step System Landscape End of the navigation path.

  3. Select the system object and Test Connection .