Exult Professional for SQL Server 1.4

Exult Professional for SQL Server 1.4 is a software designed for you to shred XML and easily import the data from one or more XML files into an SQL Server database. XML files are shredded to a relational form and tables and columns are automatically created from XML elements & attributes. XML parent-child relationships also automatically created using primary & foreign keys.

This software can process large, complex XML without large memory requirements. Performs automatic mapping of XML Elements and Attributes to tables and columns. Exult brings a new and innovative approach to importing XML data into SQL Server, so after Exult completes processing your XML file(s), you can use simple SQL toquery and manipulate the data. No need for complex XPATH or XQUERY expressions to extract the data. Exult makes handling XML files so easy that you will wonder how you got along without it!

The software includes:

• a command line program for batch processing
• a database cleanup wizard in case you want to undo the changes made by Exult, and
• a customer support application so you can get your questions answered in real time

1. XML relationships mirrored in the database: XML element structure is mirrored in the database using primary and foreign keys.
2. Tables and Columns created: Database tables and columns are automatically created from XML element and attribute information.
3. Import XML Feeds: Importing XML feeds from web or FTP sources is real easy. And synchronizing feeds with the latest updates is trivial too! We have also ensured that using the command line to automatically refresh the XML feeds is quite simple.
4. Optimized for large files: Large and complex XML files are easily imported without running into large memory requirements.
5. 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.
6. Quick & Easy: No need to struggle with XSL stylesheets.
7. Batch Processing: Need to import data regularly on a schedule? No problem. Use the included command-line interface to automate your XML data processing jobs.

Enhancements:

• Bug fix in handling multi-threading.
• Connection issue on Windows Server 2003 fixed.
• Querying a non-existent table on Windows Server 2003 causes a crash. Fixed to check for existence of the table before querying it.

Requirements:

• Hardware: Pentinum III and later.
• Operating System:
• • Windows 2000
  • Windows XP
  • Windows Server 2003
  • Windows Vista
• Software:
• Access to an SQL Server Database
• The SQL Server database can be located on the local machine or on a remote server.