FEATURES:

• One common User Interface to your SQL databases (ORACLE / IBM UDB / MYSQL / MS SQL SERVER, etc.)
• One common view to database Tables, Views, Stored Procedures with the catalog viewer tree
• ORM Query Builder canvas with visual drag & drop of tables/view objects, select columns, generates SQL
• Fully functional split pane SQL Editor with:
  • Visual Content Assist and Syntax Coloring
  • Run DDL scripts with feedback display
  • Automatically reverse engineers Objects to SQL DDL(s)
• Graphical viewer displays SQL results, tables and views, click to change sort orders  
• Point and click Java code generation of DVO/POJOS from any table, view or stored procedure
• ECLIPSE Plug-in, JDBC Compliant, More….
• Visual interface to ItcWork’s ORM framework (eliminates the need of xml input specification for ORM functions)
• Build and test object graphs with ItcPro’s bean object viewer
• Build complex custom queries with the graphical query builder
• Visual Object Model with user selectable columns

ORM FEATURES:

• Powerful Object Relational Mapping (ORM) Framework with simple XML input specification.
• Generate object mappings in a fraction of the time it takes to do in Hibernate
• Leverages referential integrity table definitions to:
  • Discover all table relationships from a parent table through the simple xml orm tag. E.g. <orm parentTable=”account_holder”/> (see the itcjunit banking demo, this tag generates object graph with six DVO/POJO’s)
  • Generates complete Java object graphs with DVO(Data Value Object)/POJO’s
  • Generates complete SQL (all CRUD) for each table in external XML document
  • Logs all SQL statement execution with runtime data binding values
  • Easily customize or add your own SQL to generated output document
  • Auto generation of primary keys with sequences
  • Supports user defined sequence objects for databases that don’t support built in sequences
  • Complete support for stored procedures
  • Complete support for connection pooling

XML BEAN SUPPORT providing classes that:

• Generate XML schema documents from XML instance documents
• Generate DVO/POJO object graphs from XML Schema or XML DTD documents
• Easy XML marshaling of XML instance documents using Java object graphs with the ItcXmlToBean and ItcBeanToXml utilities. (These tools use SAX for rapid parsing)
• Parsing supports Attribute normal form, Element normal form and the combination of the two.
• Complete framework for XML Schemas
• Complete framework for XML DTD’s
• Complete framework for WSDL Documents
• SOAP Framework that does XML Bean marshaling

POWERFUL UTILITIES including:

• Extensive parsing & string handling
• Extensive date manipulation beyond the JDK classes
• Resource Bundle Management (supporting internationalization)
• Extensive JSP TAG Library Functions
• High level “If /  Else If / Else” logic processing
• Execute JAVA methods with parameters
• Iterators with break conditions
• Automatic representation of Object Graphs on a JSP Page
• Extensive MAIL support classes
• Document change monitoring with cache reloading mechanisms

XML Based Security Package:

• Includes API to manage:
• Role Groups, Privilege Groups, Users
• Integrates to LDAP