Enabling support for a new database or data source in Eclipse
Philippe Ombredanne (Eclipse ATF committer,
Eclipse VE committer,
Eclipse SOC committer,
Mozilla contributor.), Pierre Lapointe (nexB)
The Data tools platform
(DTP) project provides an extensible framework to manage, query and integrate database support in Eclipse, with implementation provided for some of the most popular databases: those implementations are provided by the DTP enablement project.
In this tutorial, you will learn how to extend and enable DTP to support a new database or data source.
Enabling a new data source in DTP opens it to many Eclipse-based usage such as Web tooling, BIRT and more.
- DTP overview
- Creating a Database Definition
- Creating a connection profile UI
- Creating a DDL generator
- Creating a catalog loader
- Creating JDBC drivers templates
- Bundling JDBC drivers as OSGi bundles
- Creating a database recognizer
- Adding support for new SQL dialects (model, editors, formatter, etc)
- overview of advanced DTP extension opportunities: Data Source explorer/navigator, SQL debugging, Query Execution plan, Visual query builder
- code samples and tutorial materials
This tutorial is for Eclipse plugins developers that want to learn how to add support for a new database or data source in DTP.
This is NOT a tutorial on using Eclipse Data Tools or using Eclipse with databases.
Philippe is a passionate open source software developer, Eclipse committer, activist and enthusiast plug-in developer. He is a maintainer for EasyEclipse, an open source distribution of useful Eclipse plug-ins, and active contributor to several open source Eclipse projects, including PHPEclipse, the Visual Editor, the Ajax Tooling Framework, the Drools IDE and more. As a volunteer, he led the Google Summer of Code program for Eclipse for the last two years.
He is the CTO and co-founder of nexB, a software company dedicated to open source and application life-cycle management tools and services. Prior to nexB, he has worked at McDonnell Douglas, Accenture, and BearingPoint in various software development and consulting positions. He has worked on assignments with Apple, BEA, Checkpoint, Cisco, HP, Mercury, Microsoft, NetApp, Oracle, Salesforce.com, SAP and Wind River.
Philippe can be found on Eclipse IRC channels as pombreda.