Work with: Text, XML, Excel, Access, DBF, Foxpro, Paradox, ODBC, BDE, OLE DB, MS Sql Server, Oracle, MySql, PostgreSQL, Firebird, Interbase, SQLite, POP3, SMTP, File System, FTP, SSL, Unicode, RSS, Windows Event Log, Google Spreadsheets, SalesForce, BrightPearl and QlikView.

Advanced ETL Processor generates GUID's

New version of Adnvaced ETL Processor introduces support for GUID generation, Random number generation, and base 64 Encoding/Decoding.

	A globally unique identifier (GUID) is a unique reference number used as an identifier in computer software. The term GUID also is used for Microsoft's implementation of the Universally Unique Identifier (UUID) standard. The value of a GUID is represented as a 32-character hexadecimal string, such as {21EC2020-3AEA-1069-A2DD-08002B30309D}, and is usually stored as a 128-bit integer. The total number of unique keys is 2128 or 3.4×1038. This number is so large that the probability of the same number being generated randomly twice is negligible.
	Random returns a random number within the range 0 <= X < Range
	Base64 is a group of similar encoding schemes that represent binary data in an ASCII string format by translating it into a radix-64 representation. The Base64 term originates from a specific MIME content transfer encoding. Base64 encoding schemes are commonly used when there is a need to encode binary data that needs be stored and transferred over media that are designed to deal with textual data. This is to ensure that the data remains intact without modification during transport. Base64 is commonly used in a number of applications including email via MIME, and storing complex data in XML.

Clone row

New data transformation function creates copies (clones) of a row and outputs them directly after the original row to the next steps.

Clone row properties Dialog

Sorting Data

In new release of Advanced ETL Processor data sorting functionality is improoved by allowing the user to define directory to store temorary files and specify memory buffer dedicated to sorting

Sorting is the process of arranging data into meaningful order so that you can analyze it more effectively. For example, you might want to order sales data by calendar month so that you can produce shop performance report.