The Eclipse Data Tools Platform (DTP) project provides a number of key exemplary end-user tools for working with data sources (databases or other sources). Whether your task is working primarily on a data source or to build data-centric applications with Eclipse, DTP can help. We'll start with an overview of DTP and the tools available from an user perspective:
<br />
- Understanding DTP components<br />
- Setting up a database connection in DTP<br />
- Viewing the structure and contents of a database<br />
- Building SQL queries using the SQL Query Builder<br />
- Viewing and executing stored procedures<br />
- Creating and modifying a database table and its data content<br />
<br />
Next, we will focus on how adopters can extend and enable DTP to support a new type of data source.
<br />
- Extending DTP for a specific database, using SQLite as an example<br />
- Extending DTP for a non-database data source with Open Data Access<br />
- Expanding the SQL Query Model for a specific database<br />
<br />
Finally, we'll discuss how DTP is leveraged in other Eclipse projects, such as BIRT and WTP. We will also go over some examples on how to integrate DTP functionalities in a data-centric application.<br />
After completing this tutorial, you’ll be poised to make DTP a valuable part of your data tooling platform!