4.2.1.1. Schemas connection with the database
With this window you can define and then select the schema for the database connection.
4.2.1.2. Connection list
Schemas of database connections are on the list, whose properties are described below.
| Property | Description |
|---|---|
| Schema name | Public name of connection schema |
| User name | The name of the user who has access to the database |
| Selected | Time and date when you last selected connection schema |
| Driver | Database driver name |
| Version | ersion of the database that were established last connection |
| Connection url | String (URL) to establish a database connection |
4.2.1.3. Filtering
To better manage the list of schemes, it is possible to filter:
- Driver - limit the schema list to the selected driver
- Server (host) - allows you to limit the list to the server (host)
- User name - allows you to limit the list to users of the database
4.2.1.4. Window functions
From this window you can, using the buttons, go to the following functions
- [New] - create new connection schema
- [Edit] - edit connection schema
- [Delete] - deletes the selected connection schema, and with it the set of perspectives and views and plug-in settings for this connection
- [Functions] | Copy - Choosing this option opens a dialog to create a new connection schema on the selected list
- [Functions] | Schema export - allows you to save on disk in a special XML file, the definition of the connection schema
- [Functions] | Schema import - allows you to open XML file with definition of the connection schema and import it
- [Drivers] - lets go into the selection and editing of JDBC drivers.
- [Connect] - will establish a connection to the database defined in the selected schema from the list of connections
- [Close] - close the window
4.2.1.5. Username and password
Enter your user name, password and connection string
On the right side of the window, it is possible to enter a user name, password and connection string for the selected scheme. The introduction of these data is temporary - these data are not stored in the definition of the connection.