Allora leverages leading edge XML mapping and database technology to give application developers  bi-directional access to relational databases without the need for complex SQL or XSLT programming.  Allora speeds development and deployment by accurately and transparently transforming data  structures between XML elements and relational database structures. Once Allora mapping  is in place, full bi-directional XML-RDB access is enabled. Allora gives developers a simplified,  consistent XML interface to relational data. Allora brings even more value to application developers or DBAs that need to integrate any relational  database (Oracle, DB2, SQL Server, MySQL, Sybase, MS Access, Gupta, Ingres, Datacom, IDMS,  PostgreSQL, VisualFox Pro, Pointbase, etc…) with complex industry standard schemas.

Allora includes (1) design-time tools for mapping XML to relational data; (2) wizard support for popular application servers and IDE tools; (3) a rich set of application programming interfaces to the Allora run-time engine; (4) a Workflow Manager tool to organize and execute a set of transformation tasks with associated XML file manipulation; and (5) a set of SOAP interfaces to the Allora web service engine for building distributed applications. Allora runs on any platform, including Windows and Linux. With a single high value product, Allora lets you link your applications, take advantage of XML, and increase your business profitability.

Allora Components

• Graphical Mapper for mapping and converting between XML (or text) and relational data

• Workflow Manager to organize, schedule and execute transformation tasks

• Wizard support for popular application servers and IDE tools

• Wizards and a rich set of application programming interfaces to integrate XML-relational data conversions into any application

• Mapper project samples and transformation applications to help you get started

• SOAP interfaces for building distributed applications

• Separate run-time engine for a “building block” approach to creating/managing transformations Use Allora to transform XML and relational data for any database that has a JDBC or ODBC connector. It is certified to work with more than 20 different databases including IBM DB2, Oracle, Microsoft SQL Server, MySQL, Informix, Ingres, Sybase, IDMS, Datacom, Teradata, PostgreSQL and others.

Features are:

• Workflow Manager tool to organize and execute a set of transformation tasks with associated XML file manipulation
• Automatic query and enforcement of table relationships
• Expression editor for mapped transformations
• Advanced relationship mapping for XML data and RDB tables
• Run-time engine to perform transformations independently of the Mapper
• Wizards for generating source code to perform XML-RDB transformations
• Extensive API for customized application development
• SOAP-based web service for remote and distributed applications
• Message queue support for application-to-application (A2A)
• Double byte (Chinese, Japanese and Hangul) character support
• Arabic character support
• 100% Java architecture

Specifications

Design-Time Tools

·       Graphical mapper application

·       Wizards for integration with IBM WebSphere Studio, Eclipse, Embarcadero JBuilder, Oracle JDeveloper, Sun Java Studio and SunForte

·       Wizards for generating Java source code

·       Object interfaces

·       Workflow Manager tool

·       Sample source code and Mapper projects

Application Programming Interfaces

·       Mapping

·       Databinding

·       JMS

·       XPATH

Databases Supported*

·       IBM DB2 (IBM i/AS400, z/OS, Linux, AIX, Windows)

·       Oracle

·       Microsoft SQL Server

·       MySQL

·       Sybase

·       Informix

·       Ingres

·       Teradata

System Requirements

·       JDBC or ODBC SQL Middleware

·       JDK v1.3 or later

·       JAXP v1.1 or later

·       GNU regexp v1.0.8 or later

·       Xerces v1.3.0 or later For web service use:

·       Tomcat v3.2.2 or later

·       SOAP v2.2 or later

·       JavaMail v1.1.3 or later

·       JavaBeans v1.0.1 or later

Integration Modules

·       IBM WebSphere Studio

·       Eclipse

·       Embarcadero JBuilder

·       Oracle JDeveloper

·       Sun Java Studio