1.3 Import XML from an HTTP URL into SQL Server

This section explains how to import XML from a HTTP (Web) URL into SQL Server using Exult.

  1. Start up Exult SQL Server. Click next on the The Welcome Screen.
  2. The Trial Information Screen provides information about the limitations of the trial version. Appears only in the trial version of Exult for SQL Server.
  3. Enter the database connection parameters on The Database Connection Screen. It requests the information needed to connect to an SQL Server database. This includes the location of the database server, the type of the authentication used (Windows Authentication or SQL Server Authentication), user name and password to connect (for SQL Server Authentication), and optionally, the database to connect to. Connecting to SQL Server
  4. Click Add URL on the XML File Selection Screen. Add HTTP URLs for importing into SQL
Server
  5. Select the URL type in the Add URL screen. Selecting URL type for importing into SQL Server
  6. Enter the parameters for a HTTP URL. HTTP URL parameters
  7. Or, if you selected FTP, enter the parameters for an FTP URL. Add FTP URLs for importing into SQL Server
  8. Clicking Next downloads the file from the URL.
  9. The XML Import Progress Screen shows the progress of the XML import process. Importing XML into an SQL Server database
  10. The Data Preview Screen shows the tables and the data imported by the XML import. Previewing Data after importing XML into SQL
Server
  11. And that is how easy it is to import XML into SQL Server using Exult. The Finish Screen completes the process.

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 SQL Server

Shred and import XML into SQL Server.

Exult MySQL

Import XML data into automatically created MySQL tables.

Exult Oracle

Import XML into Oracle.