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.
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.
Choose
.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
In the Driver Definitions dialog box, select a database and choose Add.
Choose a driver template and specify a driver name.
Choose OK.
In Edit Driver Definition dialog box, perform the following steps:
Modify the driver name
Choose Add Jar /Zip to locate the required driver files
Modify the property values as required
Choose OK
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 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. |
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 |
|
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.
Connection Profiles under
.