8.3.1 Connecting to the Database

If you want to connect to the database, create a connection profile. The method for creating a connection profile and connecting to the database is described below.

Opening the Database Development Perspective

Open the [Database Development] perspective in order to display the [Data Source Explorer] view.

Creating the Connection Profile

Select [Databases] in the [Data Source Explorer] view, then select [New] menu from the context menu. The [New Connection Profile] wizard is displayed. In this wizard, enter the settings for connecting to the database. Refer below for the settings to be specified in the wizard:

Note

When connecting with Symfoware Server(Open interface) V12, specify the "Symfoware Server(Open interface ) 12 JDBC Driver" in the [Name/Type] tab of the [New Driver Definition] dialog box. The "9(Open interface)" shown in the version is the JDBC driver version.

Connection profile type
Select a Connection profile type to match the database you want to connect to.
Driver
Select a driver from the drop-down menu. If this has not been defined, click (new Driver Definitions) to the right, and add definitions as shown below. For details on the JDBC drivers for various databases, refer to "8.3.7.1 JDBC Drivers".
1. In the [New Driver Definition] dialog box, on the [Name/Type] tab, select the driver template to be used in connection.
2. In the [Jar List] tab, at driver file, specify where the JDBC driver file is stored. (If there is a driver file that was added provisionally, specify the correct path.)
3. If necessary, in the [Properties] tab, modify the property used as the default.
4. When [OK] is clicked, the [New Driver Definition] dialog box closes.
Connection profile properties
Set the connection profile properties according to the selected driver type. For the connection properties profile information of each database, refer to "8.3.7.2 Connection Profile Properties".
Connection test
After the driver and properties are set, click [Test Connection] to test the connection to the database.

Connecting to the Database

Select the connection profile under [Databases] in the [Data Source Explorer] view, then select [Connect] from the context menu.
This connects to the database and the database contents are displayed.