Skip to main content

Notice: this Wiki will be going read only early in 2024 and edits will no longer be possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.

Jump to: navigation, search

Difference between revisions of "Connectivity:Usability"

(Driver Instances)
(Connection Profiles)
 
(7 intermediate revisions by 3 users not shown)
Line 4: Line 4:
  
 
Areas of focus are:
 
Areas of focus are:
*[[#Driver Instances | Driver Instances]] - preference page, new wizard, edit dialog, selection controls, etc.
+
*[[#Driver Definitions | Driver Definitions]] - preference page, new wizard, edit dialog, selection controls, etc.
 
*[[#Connection Profiles | Connection Profiles]] - new wizards, property pages, etc.
 
*[[#Connection Profiles | Connection Profiles]] - new wizards, property pages, etc.
 
*[[#Data Source Explorer (DSE) | Data Source Explorer (DSE)]] - menus, display, etc.
 
*[[#Data Source Explorer (DSE) | Data Source Explorer (DSE)]] - menus, display, etc.
  
 
Please be as honest as possible, and brutal as necessary (we've got thick skin).  Also, keep in mind that providing specific examples will help us better understand your comments and suggestions.
 
Please be as honest as possible, and brutal as necessary (we've got thick skin).  Also, keep in mind that providing specific examples will help us better understand your comments and suggestions.
 +
 +
A bugzilla entry has also been created to mirror this discussion.  Feel free to add comments to the BZ entry if you feel more comfortable using that means of communication.  Here's a link to the [https://bugs.eclipse.org/bugs/show_bug.cgi?id=163624 entry].
  
 
Our goal is to use this page to improve the usability and user experience of the connectivity related features within DTP.
 
Our goal is to use this page to improve the usability and user experience of the connectivity related features within DTP.
Line 33: Line 35:
 
==Driver Definitions==
 
==Driver Definitions==
 
===Too Many Drivers===
 
===Too Many Drivers===
This list of available drivers can be a bit long and hard to navigate.
+
This list of available drivers can be a bit long and hard to navigate. [[Image:Driver_definition_preference_page.jpg|Screenshot]].
  
 
====Suggestions====
 
====Suggestions====
Add filtering to the list.
+
*Add filtering to the list.
Flatten the list (so it's displayed as a list instead of a tree).
+
*Flatten the list (so it's displayed as a list instead of a tree).
 +
 
 +
===Version Groups===
 +
The list of drivers contains many templates with the same name, but are contained within a version numbered category.  This extra layer of navigation makes it difficult to find driver templates. See [[proposed solution|proposed solution]].
 +
 
 +
====Suggestions====
 +
*Remove version categories and add version number to driver template name (e.g from "10.0/Informix JDBC Driver" and "9.2/Informix JDBC Driver" to "Informix 10.0 JDBC Driver" and "Informix 9.2 JDBC Driver").
 +
*Find a better way to specify dbdefinition version information.  The current problem is caused by the way dbdefinition's are resolved.  If a mechanism were in place to discover which dbdefinition to use simply by the type of connection created or the server version, as retrieved by the DB metadata, that could help significantly.  I don't know the feasibility of this and it may require changes to both the connection factories and the dbdefinition extension points.
  
 
==Connection Profiles==
 
==Connection Profiles==
 +
 +
Simple connection wizard, which contains just one page whould make configuration much easier!
 +
 +
====Suggestions====
 +
 +
* Connection profile wizard consists of three pages. There should be one multitab page, where first tab contains connection name, description, driver and database credentials (and, may be, the "test connection" button). Another tab allows to specify optional parameters.
 +
 +
* Check whether it's possible to generate connection URL automatically (show it in disabled text field), when user provides hostname, schema, username and password, and allow him to customize it (when un-checking "generate automatically").
 +
 +
* Is there a reason for having separate page for reviewing summary? My suggestion is to remove it.
  
 
==Data Source Explorer (DSE)==
 
==Data Source Explorer (DSE)==

Latest revision as of 03:57, 5 June 2007

Back to Connectivity Page

Connectivity Usability Page

It has been voiced that the connectivity framework is a bit awkward to use and that it could be simpler. These are rather vague comments which don't provide much insight into what is wrong with the framework or how it could/should be corrected. This page has been created to try to understand the awkwardness and complexity of the framework.

Areas of focus are:

Please be as honest as possible, and brutal as necessary (we've got thick skin). Also, keep in mind that providing specific examples will help us better understand your comments and suggestions.

A bugzilla entry has also been created to mirror this discussion. Feel free to add comments to the BZ entry if you feel more comfortable using that means of communication. Here's a link to the entry.

Our goal is to use this page to improve the usability and user experience of the connectivity related features within DTP.

General Issues

Complexity

There are too many steps required to create a connection:

  1. Create a driver instance
    Available through a preference page or a shortcut from most connection profile new wizards.
    1. Specify a driver type
    2. Specify driver jars
    3. Specify driver class
    4. Specify default connection URL
    5. etc.
  2. Create a connection profile
    1. Specify a driver instance
    2. Specify connection specific properties
  3. Connect to the server
    1. Locate newly created connection profile in DSE
    2. Right-click-->Connect...

Suggestions

  • Create default driver instances. These would be available at startup, but the user might have to fix the paths to the JAR files.
  • Create custom connection profile wizard/property pages for each vendor DB. This would greatly reduce the number of drivers displayed when browsing for a driver. It also allows connection information to be specified in a vendor specific format. (We'll be updating the Derby connection profile wizard to do this, 163614.)

Driver Definitions

Too Many Drivers

This list of available drivers can be a bit long and hard to navigate. Screenshot.

Suggestions

  • Add filtering to the list.
  • Flatten the list (so it's displayed as a list instead of a tree).

Version Groups

The list of drivers contains many templates with the same name, but are contained within a version numbered category. This extra layer of navigation makes it difficult to find driver templates. See proposed solution.

Suggestions

  • Remove version categories and add version number to driver template name (e.g from "10.0/Informix JDBC Driver" and "9.2/Informix JDBC Driver" to "Informix 10.0 JDBC Driver" and "Informix 9.2 JDBC Driver").
  • Find a better way to specify dbdefinition version information. The current problem is caused by the way dbdefinition's are resolved. If a mechanism were in place to discover which dbdefinition to use simply by the type of connection created or the server version, as retrieved by the DB metadata, that could help significantly. I don't know the feasibility of this and it may require changes to both the connection factories and the dbdefinition extension points.

Connection Profiles

Simple connection wizard, which contains just one page whould make configuration much easier!

Suggestions

  • Connection profile wizard consists of three pages. There should be one multitab page, where first tab contains connection name, description, driver and database credentials (and, may be, the "test connection" button). Another tab allows to specify optional parameters.
  • Check whether it's possible to generate connection URL automatically (show it in disabled text field), when user provides hostname, schema, username and password, and allow him to customize it (when un-checking "generate automatically").
  • Is there a reason for having separate page for reviewing summary? My suggestion is to remove it.

Data Source Explorer (DSE)

Back to the top