Examples: Importing XML Data into SQL Server using Exult SQL Server
How to shred & import XML data into SQL Server
Exult SQL Server makes it very easy to shred and import XML data into SQL Server. You could use the simple Wizard interface to do so, or the included command line for batch imports. Once the data is imported into SQL Server, you can have downstream applications consume the data or perform further queries and updates using normal relational SQL.
Here we present some examples of using Exult SQL Server to import XML data into SQL Server and the database schema created by Exult when the XML data is translated into relational form. Some of these XML data sources are updated frequently so it makes sense to refresh the data in the SQL Server database also when necessary. Exult SQL Server provides facilities to update the data from the original XML source seamlessly.
| Source of XML | Example |
|---|---|
| Sec.Gov U.S. Securities and Exchange Commission. |
Closed-End Fund Information |
| 2010 Litigation Releases | |
| NTSB | Aviation Accident Database and Synopses |
| DOL Department of Labor |
OSHA Accidents |
| EBSA Enforcement Data | |
| ClickBank | ClickBank Marketplace XML Feed |
| XML Data Repository | Course XML from: Reed College |
| Course XML from: University of Wisconsin-Milwaukee |
Argon DataViz
Create Pivot Tables and Pivot Charts from Large Datasets.
Swift XML Converter
Query & extract XML data into Microsoft Excel (XLS), Microsoft Access (MDB or ACCDB), or CSV.
Exult Standard
Convert XML into Microsoft Excel (XLS), Microsoft Access (MDB or ACCDB), or CSV.
Exult MySQL
Import XML data into automatically created MySQL tables.