HiT Allora

HIT ALLORA Real-time Bi-directional XML-to-Relational Data Transformation Software Allora is designed to generate XML from any database and write XML element and attribute values into any database. Businesses today store and share data in a multitude of file formats including database, flat files, EDI and XML-based applications. Allora provides a graphical, easy-to-use, modular approach to managing conversion, mapping and data transformations among these file formats.

Product components Transform XML and relational data

Mapper & Workflow Manager

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 The Allora engine can be installed and run on any system that supports JDK v1.3 or above, including on IBM i and z/OS systems, HP-UX and others

The design-time graphical Mapper application lets you simultaneously see XML schemas or DTDs and database catalog structures or text file structures.

The Mapper can automatically create XML schemas from relational databases and vice versa. Using a set of point-andclick tools, you can build a mapping project that contains all the information needed to transform relational data to XML, or XML to relational data. The mapping project can be accessed by the Workflow Manager, or by the API to integrate transformations into a larger application.

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.

The Workflow Manager provides a graphical layout environment to set up, schedule and execute a series of tasks and processes. It is designed to manage RDB-XML transformation tasks and process resulting XML input/output. Its Design tab provides a workspace for adding tasks, setting parameters and organizing tasks in execution order.

HIT ALLORA Application and data interfaces Key features Allora offers a rich, flexible set of programming interfaces, enabling you to integrate RDB-XML transformations as part of an application. Source code wizards in the Mapper generate the basic code you need to perform transformations, then you can enhance or extend the functionality using the provided API. For example, you can refer to data by XML element/attribute references, including XPATH, or by RDB catalog structures. Similarly, you can exercise XML element/ subelement methods or specify record/field SQL commands.

For maximum data access flexibility, Allora can also be implemented as a full-function SOAP-based web service for remote applications. Allora web service supports two client access modes: a SOAP interface mode and a higher level remote API mode.

Graphical Mapper for mapping XML schemas (or DTDs) to RDB catalogs/text structure and subsequent transformation of XML elements and attributes to relational data or relational data to an XML document 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 XMLRDB 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

President Building - Franklin Rooseveltplaats 12 2060 Antwerpen Belgium Tel.:+32 (0) 323 97 578 Fax: +32 (0) 323 96 563 Email:info@metastore.be http://www.metastore.eu

METASTORE N.V. – BELGIUM | THE NETHERLANDS | LUXEMBOURG | FRANCE | GERMANY – METASTORE.EU