Connecting to Relational Databases

A database is a repository object containing basic settings for connecting to the current database created on a DBMS server. Various repository objects use database connection to access DBMS objects and information stored in these objects.

To create a database connection, click the

Create button in the main menu of the object navigator and select the object type on the New Object side panel.

After a database is created, it is checked if there is a default database. If there is no default database, the user is prompted to use the created database as a default one.

Working with Database

To edit a database, select the corresponding object in the object navigator and execute one of the operations:

Select the Edit item in the table's context menu.
Select the Edit in a New Tab item in the table's context menu.
Select the Edit in a New Window item in the table's context menu.
Press F4.

The database wizard opens after executing one of the operations. Determine settings on corresponding pages of the wizard.

The users who have only object read permissions can open a database for edit without being able to save changes. For details see the Working in Object Navigator section.

To save settings in the database wizard:

Click the Save button.
Select the Save and Close item in the drop-down menu of the Save button. After this the specified settings are saved, the wizard closes, and the object navigator.

NOTE. The Save and Close item is available only when editing the settings.