Transcript Example - idellys

Product Description
XML file generation
Fluidity in data transfer.
Just-in-time integration and transformation
Based on JAVA technology.
Output formats : XML, PDF, HTML, XSD
Functionning
XSD
Relationnal database
3 XML setting files
DB1
PDF
HTML
DB2
Connection
Queries
Structure
XML
SpeedXML
Operation
Recovers data from all relationnal database
through JDBC (SQL Server, Oracle, Sybase,
DB2…).
Offers a real flexibility of use thanks to the XML
setting files.
Connection file
is based on two setting files to
connect to source and target databases.
Queries file
is based on standard SQL queries to
generate XML files dynamically.
Structure file
This file coresponds to the skeleton of the XML
file to generate.
transforms the result of a linear
query into a hierarchical structure.
Example
Take for example a query giving following fields :
id_address, street, city (city and postal code), name,
first name
Structure the result into an XML format allows to
make it more understandable :
by grouping contacts (name, first name, street) by city
by sorting into alphabetical order on the city and the
contact name.
Example
The structure file is the following :
<?xml version="1.0" encoding="ISO-8859-1" ?>
<Example>
<Cities query="contact_per_city" rupture="city" return="false"
param="order=city,name">
<Vi>
<City field="city" />
</Vi>
<Person rupture="name">
<Name field="name" />
<Address field=« street" />
</Personn>
</Cities>
</Example>
Example
The generated XML file is then the following :
<Example>
<Cities>
<Vi>
<City>Bourg en Bresse (01100)</City>
</Vi>
<Personn>
<Name>BERNARD</Name>
<Address>153, rue du Luxembourg</Address>
</Personn>
</Cities>
<Cities>
<Vi>
<City>Lyon (69003)</City>
</Vi>
<Personn>
<Name>SMITH</Name>
<Address>267, rue Garibaldi</Address>
</Personn>
</Cities>
</Example>
PDF transforming
Transformation of the XML output file into a PDF
file automatically.
Conditionnal display :
Plurial
Separation caracters
Head and foot page
…
HTML transforming
Generation of HTML pages
transformation style sheets.
by
using
XSL
Inserting data into a
database
Inserting data into a relationnal database by
using a connection file to connect to the target
database.
XML file exploiting rules
First tag level
 Database
Second level
 Table
Third and other levels  Columns
XSD schema / DTD
Generation of the XSD schema or the DTD from
and XML file or other DTD file.
Dominating Points
SpeedXML is not dependant from a database system and
allows to connect to all relationnal databases.
Results of SQL queries use is unlimite.
Thanks to key words, intagrating dynamical parts (files,
URL…) is done without conceptual contraints.
Based on SQL technology, SpeedXML can use all the the
power of databases systems.
Simple installation, doesn’t use a lot of memory, can deal
with bulk data…
Fast and easy to operate,doesn’t need programming.
Prices
Two ways:
- worksation
- server
Workstation :
- 1 user license : 3.000 euros / station
- 2 to 4 licenses : 2.000 euros/ additional station.
- From 5 licenses : 1.000 euros/ additional station.
Server License (access to 10 users) : 12.000 euros
Renting:
-
1 user license : 432 euros
2 user licenses : 720 euros
3 user licenses : 1.008 euros
4 user licenses : 1.296 euros
From 5 user licenses : + 144 euros
To have more details and check up for updates, see on the web
site, to the solution page and see the prices document..