This chapter is composed of :
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.
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
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.
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.
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.
When extracted, data can be encoded as characters, Base64 or Hexadecimal values.
This behaviour is inherited from the Database SQL Global Preferences Encoding Policy.
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.
Here are several links provided for further Apache Velocity related information.