Show TOC

Procedure documentationCreating a JDBC Connection Profile Locate this document in the navigation structure

 

You must create a connection profile to define all the information required to connect to a database runtime instance. This information includes reference to a JDBC driver definition.

A Java Database Connectivity (JDBC) is an API for the Java programming language that defines how a client may access a relational database. It provides methods for querying and updating data in a database.

JDBC Drivers are client-side adaptors, which are installed on the client machine, convert requests from Java programs to a protocol that the Database Management System can understand.

Prerequisites

You have opened the Visual Composer perspective in the SAP NetWeaver Developer Studio. You have the JDBC driver files for the database server on your system.

Procedure

  1. Choose   Window   Show View   Other   Connectivity   Data Source Explorer  .

  2. Choose OK.

  3. In the Data Source Explorer, click Databases with the secondary mouse button and choose New.

  4. In the New JDBC Connection Profile wizard, choose Generic JDBC Connection.

  5. Choose Next.

  6. Specify a unique name for the connection profile.

  7. Optional: Enter a description for the connection profile

  8. Choose Next.

  9. Choose the JDBC driver from the drop-down list. To configure a JDBC driver, click the button next to the driver drop-down list

    1. In the Driver Definitions dialog box, select a database and choose Add.

    2. Choose a driver template and specify a driver name.

    3. Choose OK.

    4. In Edit Driver Definition dialog box, perform the following steps:

      1. Modify the driver name

      2. Choose Add Jar /Zip to locate the required driver files

      3. Modify the property values as required

      4. Choose OK

    5. In the Driver Definition dialog box, select the driver definition and click OK.

  10. Specify the authentication details for the connection as explained in the following tables.

    Field Name

    Description

    Value

    Database

    Name of the database instance

    <db_instance>

    URL

    The URL of the database

    The JDBC URL consists of three parts: a protocol identifier (always JDBC), a driver identifier (for example, IDB, Oracle, and so on), and a database identifier (the format is driver-specific)

    Example Example

    jdbc:sapdb://localhost/<db_instance>?timeout=0

    End of the example.

    User name

    The username that you use to log in to the database server

    A username assigned to you

    Password

    The corresponding password to log in to the database server

    A password assigned to you.

  11. To save the authentication details, select Save Password.

  12. Optional: To add properties, enter the properties in the Optional Properties field and choose Add. If you added properties, perform the necessary functions as described in the following table.

    Function

    Steps

    Change the Order of Priority

    • Select the property and click Up

    • Select the property and click Down

    Remove

    Select the property that you want to delete, and then choose Remove

    Delete All Properties

    Click Remove All

  13. To test the connection, choose Test Connection.

    A dialog box appears stating whether the ping succeeded or failed.

  14. Choose OK.

  15. Choose Finish.

More Information

Connection Profiles under   Data Tools Platform User Guide   Setup: Database Development   Creating a Connection Profile  .