TnTsoft

1
TnTsoft

• DynamIT
• Dynamic User Interface
• for relational Databases
• General purpose database browser and editor

2
Dynamic GUI

• Dynamic GUI for Relational Databases
• !!!! Fully dynamic GUI !!!!
• 100 pure Java - runs on all platforms
• Based on JDBC (potentially all databases)
• User configurable (lots of parameters)
• User extendable by Plugin Tools
• Fully internationalizeable
• Centrally served by Applicationserver
• Fast (uses intelligent Java caching techniques)
• Extremely compact (only 1.4MB)
• Needs no OS environment settings at all

3
Features

• General Features
• View and Edit any Database Table
• Support for Views, Query-Masks, Dictionary-Tables
• Configurable Table Tree
• Built-in Text-Editor
• Built-in SQL-Editor
• Table search-by-name feature
• Support for Record-Freezing
• Chooseable LookFeel

4
Application Tables

• Dynamit creates its own Application-Tables
• For storing configuration info like
• System/User startup defaults
• User/Group authentification info
• Table/Column configuration info
• Plugin hookup info
• User online helps
• A few standard demo tables
• Load/Save in UNL and XML
• Automatic consistency check and cleanup
• Automatic registration of translation keywords
• Can be dropped all by Mouseclick.

5
Main-Window
Customized Plugin Tools
Customized Table Tree
Table List
Table Finder
Integrated SQL Editor
Integrated Text Editor
6
Localization

• Translation and Localization
• Localization is specific to the logged-in user
• Translated table- and column-labels
• Translated GUI strings
• Translated messages (even parameterized)
• Translated user data
• Translated online help
• Support for translation during data extractions
• Locale dependent formatting of Date and Numbers

7
Browsing

• Database browsing
• Follow forward references
• Follow (multiple) backward references
• Data filtering on references
• Support for complex, composed Pk-Fk relationships
• Support for dependencies between key-columns
• INSERT-default-values based on references
• Matching record count on back-references

8
Table Editing

• Table Editing capabilities (Form-View)
• Special Input Fields for all Datatypes
• Customizeable Layout of Input Fields
• Support for Record group-editing
• Support for fast multiple INSERTs and UPDATEs
• Efficient record searching (Filter-Editor)
• Configurable confirmation for database changes
• Table Overview (Table-View)
• Fast scroll through all loaded records
• Maintain one common Current Record
• Table-View to Form-View alignement
• User defined Sorting by multiple columns

9
Form-View
Primary Key
Backward Reference
RadioSwitch Field
Forward Reference
Image Field
Customized Background
TextArea Field
Record Stepper
10
Table-View
Sort by mouse-click
Current Record
Primary Key Columns
11
Datatypes

• Supported Datatypes
• Support for all standard datatypes including
  Blobs
• Partial support for Informix 9.xx Complex
  Datatypes
• About 30 configurable special datatypes which
  change the appearance and functionality of
  standard datatypes
• Field-EditorsIMAGE, TEXT, COLOR etc...
• Document datatypes for blobsAUDIO, VIDEO, WORD,
  EXEL etc...
• Easyly extendable to any custom datatype

12
Properties

• Customizeable Table/Column properties
• Table propertieshidden, locked, cached,
  readonly, insertonly, load-filtered etc...
• Column propertieshidden, locked, readonly,
  labeled, autosized, chained, separated etc...
• Customization parametersbgcolor255,100,22
  menuwidth200 textPush iconduke etc...
• User can override columtype by one of 30 special
  typesIMAGE, HTML, VIDEO, AUDIO, TEXTAREA,
  VOLUME,RADIO_SWITCH, COLOR, EMAIL, PASSWORD,
  PERCENT,PLUGIN, QUERY, etc...

13
Plugin Tools

• Plugin Tool Types
• Generic Plugin ToolsPlugin of user-written
  classes hooked up on many places in the
  application.
• Docu Plugin ToolsFor auto-creation of a full
  database docu in HTML format.
• Filter Tools Simple filter conditions to complex
  filter algorithms
• Extraction ToolsComplex data extractions based
  on auto-generated Java Objects (DBObjects)
• Calculator ToolsFor complex auto-caclulations of
  field values
• Table-WatchersDirect Field-to-Field
  Interactions, Complex INSERT Defaults
• User-defineable Online Help

14
Customer Extensions

• How are Customer-Extensions integrated?
• Customers can extend DynamIT with his own classes
• DynamIT consists of only two filesdynamit.jar
  DynamIT classesplugin.jar Customer classes
• Plugin classes are dynamically loaded as needed
• Plugin classes have access to everything in
  memory
• Plugin classes usually extend from a set of
  availableabstract classes which provide default
  functionalityAbstractPluginFrame,
  AbstractPluginDialog, AbstractPluginTool, etc...

15
DBObjects

• DBObjects model Table-Records as Java Objects
• DynamIT generates the DBObject Java-code.
• Data-Extraction on Java Object Level instead of
  SQL
• Used for complex and fast data-extractions and
  manipulation
• DBObjects are auto-generated from database tables
• Support for prepared SELECT, INSERT, UPDATE,
  DELETE
• Support for Connection Pooling

16
Output

• DynamIT Standard Outputs
• Write table data to UNL/XML files
• Load/Append/Update table data from UNL/XML file
• Write current record as formatted ASCII Text
• Write current table data as formatted ASCII Text
• Load/Save all tables in Batch Jobs

17
Summary

• DynamIT...
• ...is a fully dynamic GUI
• ...is a universal, robust database application
• ...runs on any platform (just Java)
• ...runs on any (IBM/Informix) database (just
  JDBC)
• ...has huge customization capabilities
• ...is extendable to any customer need (plugin
  tools)
• ...is a base application for a comprehensive
  solution