User Manual for Exult for SQL Server

jpg

Exult is a powerful Windows application which helps you shred XML and import the data into an SQL Server database.

Exult works primarily with data-centric XML files to extract data to SQL Server. The XML structure information is reflected in the database using primary and foreign key constraints.

1. Import XML into SQL Server  
2. Using Exult for SQL Server  
3. Using the command line to import XML into SQL Server  
4. Database Cleanup Wizard  
5. Uninstalling Exult for SQL Server   
 — The Detailed Node Listing —

Import XML into SQL Server
1.1 Import a single XML file into SQL Server  
1.2 Import multiple XML files into SQL Server  
1.3 Import XML from an HTTP URL into SQL Server  
1.4 Update (synchronize) XML feed in SQL Server   
Using Exult for SQL Server
2.1 The Welcome Screen  
2.2 The Trial Information Screen  
2.3 The Registration Screen  
2.4 The Database Connection Screen  
2.5 XML File Selection Screen  
2.6 XML Import Progress Screen  
2.7 The Data Preview Screen  
2.8 The Finish Screen   
XML File Selection Screen
2.5.1 Adding XML File URLs  
2.5.2 Updating XML Feeds   
Adding XML File URLs
2.5.1.1 Selecting URL type  
2.5.1.2 Adding a HTTP URL  
2.5.1.3 Adding an FTP URL  
2.5.1.4 URL Download Progress Screen   
XML Import Progress Screen
2.6.1 XML Import Completed Dialog   
Using the command line to import XML into SQL Server
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   
Using the Windows Scheduler to schedule XML Import into SQL Server
3.2.1 Adding a task to the Windows Scheduler  
3.2.2 The Scheduled Tasks Wizard  
3.2.3 Select Exultcmd.exe for scheduling  
3.2.4 Specify time and frequency of execution  
3.2.5 Specify user name and password  
3.2.6 Scheduled Task Created  
3.2.7 Advanced Task Settings  
3.2.8 Advanced Scheduling  
3.2.9 Advanced Settings   
Command line reference
3.3.1 Specify the Database Connection String for importing XML into SQL  
3.3.2 Specify the user name and password for connecting to SQL Server  
3.3.3 Specify input XML files (or URLs) on the command line  
3.3.4 Perform a dry-run (no execution) for sanity check  
3.3.5 Turn on quiet mode to speed up execution in command line mode  
3.3.6 Update data for one or more imported XML files (or URLs)  
3.3.7 Update data for all import XML files (or URLs)  
3.3.8 Perform database cleanup   
Specify input XML files (or URLs) on the command line
3.3.3.1 Specifying URLs   




	


	


	  

	  

	    
Argon DataViz

	    
Create Pivot Tables and Pivot Charts from Large Datasets.

	    
	  


	  

	    
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.