To create iViews that are capable of retrieving data from relational database management systems (RDBMS), you must do the following:
To create iViews that are capable of retrieving data from relational database management systems (RDBMS), you must do the following:
Reference the driver in the portal JDBC connector
Define destination parameters per driver
A JDBC database driver for each database system in use by the portal exists in your file system.
Proprietary drivers are available for download from the Web sites of the database system vendors.
Deploying the Driver
Open SAP NetWeaver Administrator (NWA) using the URL //hostname:port .
Navigate to
.In the Resource List page, choose Create New Resource and from the dropdown list, choose Deploy New JDBC Driver .
In the New JDBC Driver Creation page, choose Add New Driver File .
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.
In the JDBC Driver Name field, enter a new name, for example, mysqldriver .
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
In the Resource List page, choose Resource Adapters from the Show dropdown list.
In the Resource Name column, select jdbcConnector .
In the Resource Details pane, choose the Loader References tab and then choose Add New Reference .
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 .
Choose Save .
The JDBC connector can now work with the third party driver.
Defining Destination Parameters
In NWA, in the Configuration tab, choose Destinations .
In the Destination List pane, choose Create .
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.
Choose Next .
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 .
In the ConnectionGroup step, enter values for the following:
Connection URL of the relevant driver
Driver class name of the relevant driver
You can always change the destination parameter values in NWA by going to ConnectionGroup tab, in the Destination Details pane.
and choosing theChoose Finish .