Exult is a powerful Windows application which helps you shred XML and
import the data into an SQL Server database.
Exult works primarily with data-centric XML files to extract data to
SQL Server. The XML structure information is reflected in the database
using primary and foreign key constraints.
Automatically figures out Table Data: The XML is shredded in
an intuitive way to extract table data simplifying the task of sorting
through the data.
Tables and Columns created: Database tables and columns are
automatically created from XML element and attribute information.
Maintains Table Relationships: Table relationships (which are
dictated by the XML structure) are maintained by the use of
auto-generated primary and foreign keys. Makes it easy to see how the
data in separate tables relate to each other.
Merge and import data from multiple XML files: Smart parsing
ensures that the data will be merged according to the XML file
Imports Attribute information too when loading XML: Attribute
information within the XML is treated similar to element information
and is extracted to appropriate tables.
Optimized for large files: Large and complex XML files are
easily imported without running into large memory requirements.
Process many files at once: Import data from a single file or
hundreds of files at once. Exult for SQL Server is built for handling
heavy-duty processing jobs with a minimum of fuss.
Automate Imports: Automate XML import into SQL Server using
the included command line interface. Use the Windows Scheduler to
schedule jobs to run as frequently as you want.