Email based data replication, remote data loading for MySQL, SQL Server, Oracle, DB2, Informix databases. Email any data into your database from anywhere.

Overview

XMLdb is a pluggable server component (portal), for the Extensible Messaging Platform (EMP) Meta-server.

XMLdb extracts XML-formatted data from the body of incoming email messages and inserts the data into designated tables of any JDBC compliant SQL database.

This offers an excellent and affordable method to perform distributed data migration, replication, by using the traditional email message as the asyncronous transport.

Because XMLdb is a pluggable destination portal (server) component for EMP, all the flexibility of the EMP Meta-server data router is available. This includes advanced functionality including contextual data routing, which permits you to route messages based on content, not simply recipient addresses.

• XMLdb supports insertion into multiple related tables.
• Supports database transactions.
• Supports Microsoft SQL Server, Oracle, MySQL, DB2, Informix

For instance a typical order transaction which includes data for both the order and orderDetail tables is shown below.

<?xml version="1.0"?>

<!DOCTYPE YOURCHOICE>

<orders>
<orderNum>4051</orderNum>
<orderDate>12-DEC-1999</orderDate>

<order_det>
<orderNum>4051</orderNum>
<lineItem>1</lineItem>
<product>Can of Soup</product>
</order_det>

<order_det> <orderNum>4051</orderNum>
<lineItem>2</lineItem>
<product>Can of Worms</product>
</order_det>
</orders>