Here you can find a list of all available data exchange operations, that can be performed by combining various script elements and their kinds. Please, take a look at examples, that show you some of the combinations in practice.
| source | xsql | transform | destination | description |
|---|---|---|---|---|
| oledb | sql | xml | csv | json | file | stream | Data extraction from database into specified file or named temporary stream. Transformation element declares the resulting format. |
| oledb | sql | xslt | xpath | file | stream | Data extraction from database with subsequent transformation via XSLT or XPath. Results are saved into specified file or into named temporary stream. Intermediate data format is XML (see (X)SQL description). |
| oledb | sql | SQL script execution on the source database | ||
| file | stream | sql | oledb | Data import from file (or stream) into the database. Transform element declares an imported file (or stream) format options. | |
| file | stream | csv/xml | xml/csv xml/json | json/xml json/csv | file | stream | Basic conversion between file formats, performed on source and destination files (or streams). | |
| file | stream | file | stream | XSL transformation or XPath selection performed on source XML file (or stream), with results saved into destination file (or stream). | ||
| file | stream | file | stream | Data extraction from JSON source (based on JavaScript native access paths), or data creation (based on specified JSON structure), or combination of both. | ||
| file | stream | file | stream | Data copy between files and/or named temporary streams. | ||
| oledb | sql | Data extraction from database with subsequent transformation by scripting language. Results are saved into specified file or into named temporary stream or sent to the destination database. Intermediate data format is XML (see (X)SQL description). | ||
| oledb | sql | Data extraction from database with subsequent transformation by scripting language. No results are expected in this context. | ||
| Any operation coded in scripting language performed on source file, stream, or database, where results are stored into destination file, stream or database. | ||||
| Any operation coded in scripting language performed on source file, stream, or database. |
See also: