SysOnyx.com - xmlDig, the XML-SQL Extractor

xmlDig, the XML-SQL Extractor, is another simple tool from SysOnyx, Inc. With xmlDig, you use common SQL statements to get your data in XML. No need to mess with hard to decipher languages, or 3rd party proprietary devices.

Leveraging Microsoft's flexible ADO techonology, any supporting OLE/DB database can be connected to, any valid SQL statement can be executed, and the results will be returned in a simple XML document. Queries can be nested and parameterized, so Master/Child relationships are easy with xmlDig. And SELECT statements are not all, any valid SQL statement can be executed. Stored Procedures can be fired off, INSERT and UPDATEs can be executed, etc.

xmlDig is truly the simple XML-SQL integration tool...

Getting Started: As easy as 1, 2, 3...

xmlDig is very easy to use. Three steps is all it takes:

Step 1: Database Connection

The first thing to do is determine which database to connect to. All of this is handled in the Document properties. After clicking File|New, double-click on the "NewDocument" in the SQL Tree, and set the DocumentName, as well as the ADO Connection String (clicking on the elipsis button in the Connection String edit box will bring up the OLE/DB Data Link wizard).

Step 1: Set the connection properties for your XML-SQL project

Step 2: Enter your SQL queries

Now the meat of your xmlDig file, your queries. Double-click on the Query node in the SQL Tree to bring open the SQL Editor. Here, enter in any valid SQL statement. In the SQL Tree, you can add child and sister queries as desired, rename the Query name to a valid XML name (as that will be used in the resulting XML document), and don't forget you can parametarize your queries by entering the parameter name inside of braces, i.e. {parameter_name}. xmlDig will search the parent results for XML fields that match this name and use it's value when executing the child query.

SQL Queries parameterized for dynamic XML results

Step 3: Execute for your XML results

Executing is a simple click away. The results come in Text and Tree lists, and can be saved to a file with the click of a button.

Click the button to get your XML results from the SQL query

Download Now!

xmlDig is current in a beta testing phase, freely available to the public for a limited time only. Click Here to download xmlDig now!