Creating a JDBC Connection Profile

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.

Context

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.

Procedure

Choose Window Show View Other Connectivity Data Source Explorer.
Choose OK .
In the Data Source Explorer , click Databases with the secondary mouse button and choose New .
In the New JDBC Connection Profile wizard, choose Generic JDBC Connection .
Choose Next .
Specify a unique name for the connection profile.
Optional: Enter a description for the connection profile
Choose Next .
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 .

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 `jdbc:sapdb://localhost/<db_instance>?timeout=0`
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.

To save the authentication details, select Save Password.

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

To test the connection, choose Test Connection.

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

Next Steps

Connection Profiles under Start of the navigation path Data Tools Platform User Guide Next navigation step Setup: Database Development Creating a Connection Profile End of the navigation path .