Easily shred and import XML data into an SQL Server database.
This article shows you how you can easily shred and import XML data into an SQL Server database using Exult SQL Server. To begin with, we assume you have downloaded and installed Exult SQL Server. We also assume you have the connectivity information required to connect to SQL Server. Supported versions of SQL Server include:
The Connection page. Here is where we enter and configure the connection to the SQL Server database. Please check this page for complete help and instructions on connecting to SQL Server from Exult.
After successfully connecting to SQL Server, select the correct database from the list of databases shown and click Next.
The processing page shows the progress of shredding the XML to SQL Server tables. Depending on the structure of the XML, database tables and columns are created automatically and the XML data is imported. Depending on the size of the XML the processing could take some time.
Exult SQL Server does not load the contents of the entire XML into memory all at once. This enables Exult to process large XML files and import the data into SQL Server where other software might fail due to the large size.
Once the processing is completed, click Next to preview the data.
And that is how easy and effortless it is to shred and import XML data into SQL Server. You can also download a free trial and give it a try.
Create Pivot Tables and Pivot Charts from Large Datasets.
Query & extract XML data into Microsoft Excel (XLS), Microsoft Access (MDB or ACCDB), or CSV.
Convert XML into Microsoft Excel (XLS), Microsoft Access (MDB or ACCDB), or CSV.
Import XML data into automatically created MySQL tables.