Configuring JDBC for SAP Enterprise Portal

Use

To create iViews that are capable of retrieving data from relational database management systems (RDBMS), you must do the following:

  1. To create iViews that are capable of retrieving data from relational database management systems (RDBMS), you must do the following:

  2. Reference the driver in the portal JDBC connector

  3. Define destination parameters per driver

Prerequisites

A JDBC database driver for each database system in use by the portal exists in your file system.

Procedure

Deploying the Driver

  1. Open SAP NetWeaver Administrator (NWA) using the URL //hostname:port .

  2. Navigate to Start of the navigation pathConfiguration Management  Next navigation step Infrastructure Next navigation step Application ResourcesEnd of the navigation path.

  3. In the Resource List page, choose Create New Resource and from the dropdown list, choose Deploy New JDBC Driver .

  4. In the New JDBC Driver Creation page, choose Add New Driver File .

  5. In the File Upload dialog box that appears, browse to the location of the driver (jar) file and choose OK .

    If the driver consists of several jar files, repeat until all the jar files are added.

  6. In the JDBC Driver Name field, enter a new name, for example, mysqldriver .

  7. Choose Save to add the driver to the list of resources.

    To view the Resource List, choose All Resources from the Show dropdown list.

Adding a Reference to the Driver from the JDBC Connector

  1. In the Resource List page, choose Resource Adapters from the Show dropdown list.

  2. In the Resource Name column, select jdbcConnector .

  3. In the Resource Details pane, choose the Loader References tab and then choose Add New Reference .

  4. Place the cursor in the highlighted field and enter the name of the driver you deployed using the format library:driver_name , for example, library:mysqldriver .

  5. Choose Save .

    The JDBC connector can now work with the third party driver.

Defining Destination Parameters

  1. In NWA, in the Configuration tab, choose Destinations .

  2. In the Destination List pane, choose Create .

  3. In the General Data step of the Destination wizard, enter a value for each of the following properties:

    • Hosting System

      Choose the icon at the end of the field to select from available options.

    • Destination Name

    • Destination Type

      Enter JDBC or choose the icon at the end of the field and select JDBC from the available options.

  4. Choose Next .

  5. In the Logon Data step, from the Authentication dropdown list, choose Basic (User ID and Password) , enter the required user name and password for the database, and choose Next .

  6. In the ConnectionGroup step, enter values for the following:

    • Connection URL of the relevant driver

    • Driver class name of the relevant driver

  7. Choose Finish .