Download XML Editor 11.2 User Manual for Eclipse

Chapter 15. Working with Databases
XML is a storage and interchange format for structured data and it is supported by all major database systems. <oXygen/>
offers the means of managing the interaction with some of the widely used databases, both relational ones and Native
XML Databases. By interaction, one should understand browsing, querying, SQL execution support, content editing,
importing from databases, generating XML Schema from database structure.
Relational Database Support
Relational databases use a relational model and are based on tables linked by a common key. <oXygen/> offers support
for the following relational databases: IBM DB2, JDBC-ODBC Bridge, MySQL, Microsoft SQL Server, Oracle 11g
like browsing the tables of these types of database in the Data Source Explorer view, executing SQL queries against
them, calling stored procedures with input and output parameters.
In the following sections one can find the tools that <oXygen/> offers for working with relational databases and a description on how to configure a relational data source, a connection to a data source and also the views where connections
can be browsed and results are displayed.
Configuring Database Data Sources
How to configure an IBM DB2 Data Source
1.
Go to Preferences -> Data Sources. In the Data Sources panel click the New button.
2.
Enter a unique name for this data source and select DB2 from the driver type combo box.
Figure 15.1. Data Source Drivers Configuration Dialog
446