Database Data DTD and XML Resources


This chapter is composed of :

  1. Introduction
  2. Database Data DTD and XML Resources
    1. Database Data DTD and XML Resources Page
      1. Database Data DTD Name
      2. Database Data XML Name
    2. Finish
      1. Encoding Policy
  3. Templates
  4. Additional Resources

1. Introduction

The purpose of this chapter is to show how to generate a Database Data Resource and its associated Database Data DTD.

This tool will produce two files :

The Data is extracted from your Database.

 

2. Database Data DTD and XML Resources

To start the Database Data DTD and XML Resources wizard, select :

File->New->Other->Database->Database Data DTD and XML Resources

or

Select an object in the Package Explorer View or the Navigator View then right-click and select :

New->Other->Database->Database Data DTD and XML Resources

The selection is contextual.

This means that if you select an existing Database Object :

 

 

The wizard will open the parent Database Connection in update mode.

 

 

Otherwise :

 

 

A new Database Connection wizard will be opened starting with a New Folder selector.



In Database Connection Update mode this wizard has four pages :

In Database Connection Create mode this wizard has five pages :

 

2.1. Database Data DTD and XML Resources Page

 

 

2.1.1. Database Data DTD Name

Database Data DTD Name is the name of your new Data DTD.

Each resource should have a unique name in the targeted selected workspace folder or project root.

This data is not related to any Meta Data informations.

This name will be the file name of the generated Data DTD file.

A Database Data DTD is a DTD file, its file extension is :

This file is referenced in your current Database Data file.

 

2.1.2. Database Data XML Name

Database Data XML Name is the name of your new Database XML file.

Each resource should have a unique name in the targeted selected workspace folder or project root.

This data is not related to any Meta Data informations.

This name will be the file name of the generated Database Data XML file.

A Database Data XML is an XML file, its file extension could be :

This file extension is managed by the Save Policy Preference.

This file is referenced in your current Database Connection.

 

2.2. Finish

Two files will be generated.

A DTD file will be generated, this file describes your XML Data.

 

 

A XML file will be generated, this file contains your extracted data.

 

 

Detailed information is available in the DatabaseConsole window.

 

 

2.2.1. Encoding Policy

When extracted, data can be encoded as characters, Base64 or Hexadecimal values.

This behaviour is inherited from the Database SQL Global Preferences Encoding Policy.

 

 

3. Templates

This wizard is Template based.

Below your Plugin Templates or MyTemplates you should see the following directory:

Torque/sql/data

 

 

Torque/sql/data contains the Database Data DTD Templates.

Torque/sql/data/dump contains the Database Data XML Templates.

These templates are Velocity based and use the Torque Model API.

 

4. Additional Resources

Here are several links provided for further Apache Velocity related information.