Data Applications in Eclipse: The Eclipse Data Tools Platform

John Graham (Sybase), Loïc JULIEN (IBM), Sheila Sholars (IBM Corporation)

Data Tooling · Tutorial
Presentation
Monday, 08:00, 2 hours | Room 202 |

John Graham

Loïc JULIEN

Sheila Sholars

The Eclipse Data Tools Platform (DTP) project provides a number of key exemplary end-user tools for working with data sources. Whether your task is working primarily on a database or to build an application using a database, DTP can help. We'll start with an overview of DTP:

Understanding DTP components
Installing DTP
Setting up a database connection in DTP using Apache Derby
Viewing the structure and contents of a database
Viewing and executing stored procedures
Creating and modifying a database table
Viewing and modifying data
Creating SQL statements using the SQL editor
Understanding and using the SQL Results view for iterative development

Next, we'll investigate data tooling:

Creating SQL queries using the SQL Query Builder
Using GMF for graphical display of database tables
How to extend DTP diagrams for specific SQL dialects

Finally, we'll discuss heterogeneous data access with DTP and how DTP is leveraged in other Eclipse projects, such as BIRT and WTP. After completing this tutorial, you’ll be poised to make DTP a valuable part of your everyday work with Eclipse!

John has been developing enterprise software for twelve years, and has been with Sybase for the past seven. His academic background includes a Masters degree from the University of Hawai’i concentrating on computational properties of formal and natural languages, and post-graduate training in business. He has worked on enterprise application integration technologies, web services tooling, distributed systems, machine learning, and service-oriented platforms. A developer on Eclipse since version 1, John served on the Eclipse Consortium Executive Committee.

Loïc Julien is an senior software engineer at IBM and is currently working on the development of IBM Rational Data Architect, IBM Data Studio and the Eclipse Data Tools Platform project. Loïc is a committer for the Eclipse DTP project in the Eclipse platform. Loïc has historically contributed to the development of Rational XDE and Rational Rose, and contributed features to Rational Rose Java and the Rational XDE J2EE plug-in. Loïc has an M.S. from San Jose State University in client/server computing.

Sheila Sholars is a Software Engineer with IBM Information Management at the IBM Silicon Valley Lab in San Jose, California She has worked on data related software development for almost 20 years, holds several patents and a B.S. from UCLA in Computer Science and Engineering. Sheila currently serves on the DTP Project Management Committee.