X-SQLT is a free-form, declarative, and 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. X-SQLT is based on a serialization of basic data exchange operations where each operation consists of the following elements: source, SQL processing, transformation, and destination. Features include 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, and scriptable processing.
Comments not found