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!
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:
Exultcmd.exe -U -a
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
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
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
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.