Automate XML Feed Updates in SQL Server with Exult command line

Exult for SQL Server includes a command line interface which makes updating data from XML feeds in SQL Server very easy. Check out the example usages below, schedule the updates using Windows Scheduler, and the data from the XML feeds will be automatically updated!

Updating the default database on the current host

To update data from XML feeds in an SQL Server database running on the same machine as Exult, use the command shown below. Note the following points:

  • SQL Server is running on the same machine as Exult
  • Uses SQL Server Authentication to log into the database.
  • The database used is the default database for the user under whose account Exult is running.
  • The command Exultcmd.exe should be located under C:\Program Files\Novixys Software\Exult SQL Server 1.1 or wherever Exult has been installed on your machine.
Exultcmd.exe -U -a

Updating a specified SQL Server database on another host

Use the following command to update all XML files loaded into SQL Server when you need to specify the hostname and/or the database name.

To update the a specified database on a specified SQL Server host:

Exultcmd.exe -U -a sql.server.com@databaseName

The following command shows how to specify the SQL Server instance along with the server name and the database name.

Exultcmd.exe -U -a sql.server.com\instanceName@databaseName

The databaseName can be skipped if it is the default database for the user running the command:

Exultcmd.exe -U -a sql.server.com@

Or the server can be skipped if SQL Server is running on the same host as Exult

Exultcmd.exe -U -a @databaseName

Updating SQL Server using a username and password

Use the following command to update XML files loaded into SQL Server when using SQL Server Authentication.

Exultcmd.exe -u username -p password -U -a sql.server.com@databaseName

Selecting the XML files to be updated

To update a specified XML file (or URL), just skip the -a option and list out the XML file location as shown below:

Exultcmd.exe -U sql.server.com@databaseName http://www.example.com/path/to/File.xml

You can update multiple XML file locations in one go:

Exultcmd.exe -U sql.server.com@databaseName http://www.example.com/fileA.xml http://www.example.com/fileB.xml

Update from a remote XML file or a local XML file:

Exultcmd.exe -U sql.server.com@databaseName c:\Path\to\FileA.xml http://www.example.com/fileA.xml

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.