Front Page

User FAQ
Developer FAQ
Community Docs
Development
Quality
Dream Team
Popular Projects
Bug DashBoard
Hudson
Sources
Nightly
Wiki Etiquette
Formatting Rules
Terms Of Use
Unlinked Pages
Undefined Pages
Page Index
Recent Changes
Find Page

[RSS]

Database Analysis for Eclipse Data Tools Platform

Quoted from the website: The Data Tools Platform (DTP) project will include extensible frameworks and exemplary tools, enabling a diverse set of plug-in offerings specific to particular data-centric technologies and supported by the DTP ecosystem. In the spirit of Eclipse, the project will be guided by the following values:

  • Vendor neutrality
  • Extensibility
  • Community Involvement
  • Transparency
  • Agile development

Features:

  • location and management of data source drivers
  • configurations for access to particular data source instances.
  • explore the data source
  • create, edit, and test SQL.
  • Assistance in editing SQL through code completion, formatting, and dialect specialization
  • execute or debug commands, both SQL and stored procedures,

To access the Data Tools Platform, open the perspective, Database Development from Windows->Open Perspective.

Overall impression

Database Vendor Support

List of Databases supported OOB

Just database names listed:

Databases listed

List of drivers bundled OOB

None

Task Analysis

{For each task, give a rating based on how well it automated this task. Provide comments and links to screen shots as needed}

TaskRating (1 - excellent, 5 - terrible, 0-not supported)Comments
Database Exploration
Create database connection 4 Start MySQL not supported, but provide Ping to ping the server; Doesn't show which databases are available to connect to
View tables, columns, etc. Schemas, tables, columns, indexes, triggers, stored procedures, synonym
Get detailed information about database objects yes
View data in a table view, is inline edit mode
E/R diagram support, even if read-onlyno
SQL Editing yes
Syntax highlighting yes
Table and column completion yes
Function and keyword completion yes
Procedural SQL support yes
SQL editing (including features above) embedded in another editor data can be edited in an editable table
Other SQL features see below
Schema Management
Create Tables, etc. from Scratchyes
Import SQL DDL yes

Other SQL Features

  • Lucene engine is used for executing queries
  • No support for starting database servers
  • extract DDL
  • edit data
  • execute query on a column "sample results"
SELECT DISTINCT "PERSONID" , COUNT(*) AS OCCURRENCE FROM "TRAVEL"."TRIP" GROUP BY "PERSONID" ORDER BY "PERSONID"
  • creation of data sources (flat file, web services and xml)

SQL History.

  • History can be saved and re-executed by re-opening a history sql file
  • Statements can be re-executed using copy/paste to the editor
  • History window shows SQL execution status, along with the connection profile for each SQL statement executed.

Attachments

eclipse_databases.png Info on eclipse_databases.png 52945 bytes