The Data Sources preferences panel is opened from menu → → +Data Sources
Here you can configure data sources and connections to relational databases as well as native XML databases. You can check the list of drivers (http://www.oxygenxml.com/database_drivers.html) available for the major database servers.
- New
Opens the Data Sources Drivers dialog, allowing you to configure a new driver.
- Name
Allows you to name the new data source driver.
- Type
Select data source type from the supported driver types.
- Help
Open the User Manual at the list of the sections where the configuration of supported data sources is explained and the URLs for downloading the database drivers are specified.
- Driver Class
Provide the Driver Class for the data source driver
- Add
Adds the driver class library.
- Remove
Removes driver class library from the list.
- Detect
Detects driver candidates.
- Stop
Stops the detection of the driver candidates.
- Edit
Opens the Data Sources Drivers dialog, allowing you to edit the selected driver. See above the specifications for the Data Sources Drivers dialog (in order to edit a data source , there must be no connections using that data source driver).
- Delete
Deletes the selected Data Source Driver (in order to delete a data source , there must be no connections using that data source driver).
![[Note]](img/note.gif) | Note |
|---|---|
Checked connections will be visible in the Database Explorer View. |
For performance issues, you can set the maximum number of cells that will be displayed in the Table Explorer view. Leave the field Limit the number of cells empty if you want the entire content of the table to be displayed. By default this field is set to 2,000. If a table having more cells than the value set here is displayed in the Table Explorer view, a warning dialog will inform you that the table is only partially shown.
In Oracle XML and Tamino databases a container can hold millions of resources. If the node corresponding to such a container in the Database Explorer view would display all the contained resources at the same time the performance of the view would be very slow. To prevent such a situation only a limited number of the contained resources is displayed as child nodes of the container node. Navigation to other contained resources from the same container is enabled by the Up and Down buttons of the Database Explorer view. This limited number is set in the option Maximum number of children for container nodes. The default value is 200 nodes.
- New
Opens the Connection dialog.
- Name
Allows you to name the new connection.
- Data Source
Select data source defined in the Data Source Drivers dialog.
Depending upon the selected Data Source, you can set some of the following parameters in the Connection details area:
- URL:
The URL used to connect.
- User:
Provide the database user .
- Password:
Provide the database password.
- Host:
Provide the host address.
- Port:
Provide a port to connect.
- XML DB URI:
Provide the database URI to connect.
- Database:
Provide the initial database.
- Collection:
Select one of the available collections for the specified data source.
- Environment home directory:
Specify the home directory for a Berkeley database.
- Verbosity:
Set the verbosity level for a Berkeley database.
- Edit
Opens the Connection dialog, allowing you to edit the selected connection. See above the specifications for the Connection dialog.
- Delete
Deletes the selected connection.
