Precision software & consulting Precision software & consulting products
Home pagespacer ProductsspacerDownloadspacerBuyspacerSupport & servicesspacerContact
Customer section

X-SQLT  (Extended SQL Transformation)

X-SQLT is a free-form, declarative, XML-based language used to describe a series of commands for data exchange and transformations, that can be performed on databases, data files or structured documents.

It is designed to allow easy selection, conversion and transformation of data using SQL, XML, XSLT, XPath and scripting languages (VBScript, JavaScript, etc).

X-SQLT is based on a simple, but generic idea of serialization of basic data exchange operations, where each operation consists of the following elements: source, SQL processing, transformation and destination.

By combining these elements and their kinds (at least two elements must be specified), you can define various types of data exchange tasks.


Brief overview of what you can do with X-SQLT:

  • Extract data from database (into XML, JSON or CSV file)
  • Import data into database (from XML or CSV file)
  • Execute SQL script on database
  • Transfer data between databases
  • Transform XML file by XSL template
  • Extract document fragments from XML file (by XPath expression)
  • Extract specified data records from XML file into CSV format
  • Convert between XML, CSV and JSON file formats
  • Parameterized data exchange and transformations
  • Scriptable processing
  • and many more ...

Introductory example of X-SQLT project


  <?xml version="1.0" ?>
  <xsqlt name="Introductory example">
    <script>
      <source kind="oledb">
        <connection-string>
          Provider=Microsoft.Jet.OLEDB.4.0;Data Source=dbdemos.mdb
        </connection-string>
      </source>
      <xsql kind="inline">
        <Customers>
          SELECT * FROM CUSTOMER
          <Orders record-tag="Order">
            SELECT * FROM ORDER WHERE CustNo=:Customers$CustNo
          </Orders>
        </Customers>
      </xsql>
      <transform kind="xml" record-tag="Root/Customer" />
      <destination>customers.xml</destination>
    </script>
  </xsqlt>
    

The above example extracts customers data (and their orders) from demonstration database and stores results into XML-formatted file. See more examples in X-SQLT Online Manual.

After downloading and installing X-SQLT setup package, you can read full language manual, and you can also try out a set of provided examples that will show you the language possibilities in practice (please, see description of X-SQLT Command-line Processor below, because this tool is used to execute X-SQLT examples).


X-SQLT Command-line Processor

A first fully functional tool, that implements all X-SQLT language specifications is X-SQLT Command-line Processor.

It is an easy to use, fast and resource friendly utility, that allows you to perform specified tasks by using generally available technologies, like ADO DB, MSXML and WSH, and by supporting common data formats (XML, CSV and JSON) and transformations (XSLT, XPath, VBScript, JScript, etc).

Moreover, this utility does not require you to create an X-SQLT project file to perform your tasks. It has implemented intelligent parser of command-line arguments, that allows you to pass (as parameters) essential options only. For example, to transform XML file with XSL template, you can execute this utility with three arguments - xml file, xsl file and output file.

So, this utility can be incorporated into any automation process, or used as a standalone tool for daily operational tasks, no matter if you are using X-SQLT language purposely, or on the background of some simpler task.

X-SQLT Command-line Processor is distributed under FREEWARE license, as a part of X-SQLT setup package.


X-SQLT Schema of Components



Current release

Version: 1.2
Released: 2013-01-06

License: Freeware

System requirements:
MS Windows 2000/XP/Vista/7
Windows Server 2000/2003/2008

» Useful links / affiliate partners «












Brothersoft.com





Copyright © 2008-2017  Precision software & consulting. All rights reserved.
Send your comments to www pages.
Contact   |   RSS
Precision software & consulting
Narodnich mucedniku 447
738 01  Frydek-Mistek
Czech Republic