Enabling support for a new database or data source in Eclipse

Philippe Ombredanne (Eclipse ATF committer, Eclipse VE committer, Eclipse SOC committer, EasyEclipse maintainer, PHPEclipse committer, Drools committer, Mozilla contributor.), Pierre Lapointe (nexB)

Data Tooling · Tutorial

Monday, 10:30, 2 hours | Room 202 |

Philippe Ombredanne

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.

Tutorial outline

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)

Additional take-aways

overview of advanced DTP extension opportunities: Data Source explorer/navigator, SQL debugging, Query Execution plan, Visual query builder
code samples and tutorial materials

Intended Audience

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.