EclipseDataToolsPlatformAnalysis
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:
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}
| Task | Rating (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-only | no | |
| 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 Scratch | yes | |
| 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.
