Procedure documentationConnecting Non-SAP Systems to Visual Composer with the BI JDBC template Locate this document in the navigation structure

 

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/drivers

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

  3. Choose   Configuration Management   Infrastructure   Application Resources  .

  4. Choose   Create New Resource   Deploy New JDBC Driver  .

  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   Configuration Management   Infrastructure   Application Resources  .

  3. Choose   Show   All Resource Adapters   .

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

  5. Choose   Resource Details   Loader References  .

  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   System Administration   System Configuration   System Landscape  . In the context menu for Portal Content, choose   New   System (from template)  .

  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   User Administration   Identity Management  .

  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   Administration   System Configuration   System Landscape  .

  3. Select the system object and Test Connection.