Exult for SQL Server includes a command line which allows you to perform the following tasks in a batch mode environment:
The command line interface to Exult is called Exultcmd.exe and should be installed in the same location as Exult.exe itself, typically:
‘C:\Program Files\Novixys Software\Exult SQL Server 1.2\Exultcmd.exe’
Check out the following sections for more details on how to accomplish each task from the command line.
|3.1 How to import XML into SQL Server from the command line|
|3.2 Using the Windows Scheduler to schedule XML Import into SQL Server|
|3.3 Command line reference|
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.