Softpedia >Windows >Internet >Servers >Database Utils >Advanced ETL Processor Enterprise >  Changelog

Advanced ETL Processor Enterprise Changelog

What's new in Advanced ETL Processor Enterprise 6.4.2.34

Apr 29, 2024
  • Added: "Lookup RegEx" and "Lookup Contains" transformation functions

New in Advanced ETL Processor Enterprise 6.4.2.33 (Apr 24, 2024)

  • Improved: "Check Date" Functionality
  • Added: Ability to select mask or RegEx Directory Monitor dialogue
  • (BREAKING CHANGE, PLEASE UPDATE DIRECTORY MONITOR SETTINGS)

New in Advanced ETL Processor Enterprise 6.4.2.32 (Apr 24, 2024)

  • Improved: "Check Date" Functionality

New in Advanced ETL Processor Enterprise 6.4.2.31 (Apr 23, 2024)

  • Added: "Custom icon" support to External Application package action

New in Advanced ETL Processor Enterprise 6.4.2.30 (Apr 23, 2024)

  • Improved: "Fields Order" Error Handndling

New in Advanced ETL Processor Enterprise 6.4.2.29 (Apr 20, 2024)

  • Added: "Headers" option to send email package object
  • Added: "" variable to send email package object

New in Advanced ETL Processor Enterprise 6.4.2.28 (Apr 19, 2024)

  • Added: "Headers" option to send email package object
  • Added: "" variable to send email package object

New in Advanced ETL Processor Enterprise 6.4.2.27 (Apr 18, 2024)

  • Added: "ReplyTo" option to send email package object
  • Added: "" variable to send email package object

New in Advanced ETL Processor Enterprise 6.4.2.26 (Apr 15, 2024)

  • Improved: "Fields Order" transformation object interface

New in Advanced ETL Processor Enterprise 6.4.2.25 (Apr 12, 2024)

  • Improved: License server error handling

New in Advanced ETL Processor Enterprise 6.4.2.24 (Apr 11, 2024)

  • Added deeper scan of FAT32 file entries
  • Added DBF (dBASE Database File) in RAW Recovery Engine
  • Added deleted DBF file detection in FAT/EXFAT volumes
  • Optimzation changes if FAT32/EXFAT scan entries

New in Advanced ETL Processor Enterprise 6.4.2.23 (Apr 5, 2024)

  • Added: Support for mutiple variables to Package Loop Action
  • Added: Execution was stopped by the user to Package designer

New in Advanced ETL Processor Enterprise 6.4.2.22 (Apr 5, 2024)

  • Added: Support for mutiple variables to Package Loop Action.

New in Advanced ETL Processor Enterprise 6.4.2.20 (Mar 31, 2024)

  • Improved: Setup logging
  • Fixed: Set Variables Package action delimited file handlinng bug

New in Advanced ETL Processor Enterprise 6.4.2.19 (Mar 31, 2024)

  • Improved: Set Variables Package action delimited file handlinng

New in Advanced ETL Processor Enterprise 6.4.2.18 (Mar 27, 2024)

  • Improved: String delimiter handling.

New in Advanced ETL Processor Enterprise 6.4.2.17 (Mar 22, 2024)

  • Added: Delimiter, Text Qualifier, Skip Empty Values and Ignore Duplicates options to Accumulate Strings transformation function

New in Advanced ETL Processor Enterprise 6.4.2.15 (Mar 18, 2024)

  • Added: Support for Regular expressions to Directory monitor

New in Advanced ETL Processor Enterprise 6.4.2.14 (Mar 17, 2024)

  • Fixed: Issues with viewing/editing very large numbers (MySQL, Postgress, Interbase/Firebird and SQLite)
  • Fixed: Print preview issues
  • Fixed: Multitab search issues
  • Improved: Print preview dialogue is closed on ESC

New in Advanced ETL Processor Enterprise 6.4.2.12 (Mar 14, 2024)

  • Updated: SSH components
  • Added: "Search In Subdirectories" option to Directory Monitor

New in Advanced ETL Processor Enterprise 6.4.2.11 (Mar 12, 2024)

  • Improved: Case transformation function functionality

New in Advanced ETL Processor Enterprise 6.4.2.10 (Mar 11, 2024)

  • Fixed: Issues with reading Excel files

New in Advanced ETL Processor Enterprise 6.4.2.9 (Mar 11, 2024)

  • Added: "Proper Name" option to Format Fields dialogue
  • Improved: Groups handling of UnPivot dialogue

New in Advanced ETL Processor Enterprise 6.4.2.8 (Mar 5, 2024)

  • Updated: Excel components

New in Advanced ETL Processor Enterprise 6.4.2.7 (Mar 1, 2024)

  • Fixed: Automap feature of Union all dialogue
  • -Fixed: Backup/Restore bugs (MySql only)

New in Advanced ETL Processor Enterprise 6.4.2.6 (Feb 29, 2024)

  • Added: Fixed Automap feature of Union all dialogue

New in Advanced ETL Processor Enterprise 6.4.2.5 (Feb 29, 2024)

  • Added: Automap button to Union all dialogue
  • Updated: Repository creation scripts

New in Advanced ETL Processor Enterprise 6.4.2.4 (Feb 28, 2024)

  • Added: Automap button to Union all dialogue.

New in Advanced ETL Processor Enterprise 6.4.2.3 (Feb 25, 2024)

  • Fixed: Minor transformation interface bugs
  • Fixed: Minor block transformation interface bugs

New in Advanced ETL Processor Enterprise 6.4.2.2 (Feb 22, 2024)

  • Added: variable to Check File Package Action

New in Advanced ETL Processor Enterprise 6.4.2.1 (Feb 22, 2024)

  • Added: Processing Web hook data example
  • Fixed: Split Dialogue AV

New in Advanced ETL Processor Enterprise 6.4.2.0 (Feb 18, 2024)

  • Added: XSD Validator package action

New in Advanced ETL Processor Enterprise 6.4.1.17 (Feb 16, 2024)

  • Fixed: SQLite data reader bug
  • Fixed: HTTP Post package action bug
  • Improved: Workinng with JSON Pairs

New in Advanced ETL Processor Enterprise 6.4.1.16 (Feb 1, 2024)

  • Added: File operation Open File option works with mask now

New in Advanced ETL Processor Enterprise 6.4.1.15 (Jan 27, 2024)

  • Added: Open File option to File operation package action.

New in Advanced ETL Processor Enterprise 6.4.1.14 (Jan 16, 2024)

  • Removed: TelAPI SMS Support (The company no longer exists).

New in Advanced ETL Processor Enterprise 6.4.1.12 (Jan 3, 2024)

  • Updated: Third party components

New in Advanced ETL Processor Enterprise 6.4.1.11 (Dec 30, 2023)

  • Added: Set Cell Color option to Excel File operation package action

New in Advanced ETL Processor Enterprise 6.4.1.9 (Dec 10, 2023)

  • Updated: Excel components

New in Advanced ETL Processor Enterprise 6.4.1.8 (Dec 9, 2023)

  • Added: Search String option to File check package action

New in Advanced ETL Processor Enterprise 6.4.1.7 (Dec 5, 2023)

  • Added: Refresh Tables list menu item to Table Browser dialogue

New in Advanced ETL Processor Enterprise 6.4.1.6 (Nov 29, 2023)

  • Added: Write Variables option to all Package Actions
  • Updated: Documentation
  • Fixed: Package Action dialogue bug

New in Advanced ETL Processor Enterprise 6.4.1.5 (Nov 28, 2023)

  • Added: Keep sheet and List sheets option to Excel Package action

New in Advanced ETL Processor Enterprise 6.4.1.3 (Nov 26, 2023)

  • Fixed: Minour Object Tree Bug

New in Advanced ETL Processor Enterprise 6.4.1.2 (Nov 20, 2023)

  • Fixed: Bug with detaching tabs

New in Advanced ETL Processor Enterprise 6.4.1.1 (Nov 16, 2023)

  • Added: Support for python 3.11 and 3.12

New in Advanced ETL Processor Enterprise 6.4.1.0 (Nov 14, 2023)

  • Added: Pivot block transformation
  • Added: UnPivot block transformation
  • Added: Copy/Paste to block transformations
  • Added: MoveUp/MoveDown butttons to some block transformations
  • Improved: wiki documetation

New in Advanced ETL Processor Enterprise 6.4.0.3 (Nov 12, 2023)

  • Fixed: Rotate transformation bug.

New in Advanced ETL Processor Enterprise 6.4.0.2 (Nov 9, 2023)

  • Fixed: Block transformation AV
  • Fixed: Block transformation double writing of Excel files

New in Advanced ETL Processor Enterprise 6.4.0.1 (Nov 7, 2023)

  • Improved: Block transformation progress bar position

New in Advanced ETL Processor Enterprise 6.4.0.0 (Nov 6, 2023)

  • Added: Block transformation
  • Added: Block transformation package action
  • Added: Added Enabled/Disabled flag to objects tree
  • Added: Added 4 new examples
  • Improved: Office 365 email reader no longer fails when no emails are found
  • Improved: Package editor popup menu
  • Improved: Setup procedure
  • Updated: Third-party Excel libraries

New in Advanced ETL Processor Enterprise 6.3.12.17 (Nov 1, 2023)

  • Added: Ignore nulls and keep original values option to Excel Writer

New in Advanced ETL Processor Enterprise 6.3.12.16 (Oct 25, 2023)

  • Improved: Calculation engine update

New in Advanced ETL Processor Enterprise 6.3.12.14 (Oct 24, 2023)

  • Added: "Abort when no data found" checkbox to Export Package Action

New in Advanced ETL Processor Enterprise 6.3.12.14 (Oct 16, 2023)

  • Added: "Abort when no data found" checkbox to Export Package Action

New in Advanced ETL Processor Enterprise 6.3.12.13 (Oct 9, 2023)

  • Improved: Openning objects from Schedule tab
  • Improved: Openning objects from search dialogue

New in Advanced ETL Processor Enterprise 6.3.12.12 (Oct 8, 2023)

  • Improved:
  • Components update: SSL, SSH, SFTP, MySQL, Postgre, SQLite, Interbase/Firebird.

New in Advanced ETL Processor Enterprise 6.3.12.11 (Oct 4, 2023)

  • Improved: Renamed HTTP Form package action to HTTP Post
  • Improved: Renamed HTTP Download package action to HTTP Get
  • Added: 0090 Convert PDF to Excel example

New in Advanced ETL Processor Enterprise 6.3.12.10 (Oct 1, 2023)

  • Added: , , , variables to File metadata package action

New in Advanced ETL Processor Enterprise 6.3.12.9 (Sep 26, 2023)

  • Added: 0089 Convert all XML files in a directory example
  • Fixed: MS Access Repository structure

New in Advanced ETL Processor Enterprise 6.3.12.8 (Sep 25, 2023)

  • Added: Incremental search to Expression editor dialogue

New in Advanced ETL Processor Enterprise 6.3.12.7 (Sep 13, 2023)

  • Fixed: Issues with inserting default values within the data grid. (MySQL, Postgress, Interbase/Firebird and SQLite)

New in Advanced ETL Processor Enterprise 6.3.12.6 (Sep 11, 2023)

  • Fixed: Issues with inserting default values within the data grid. (MySQL, Postgress, Interbase/Firebird and SQLite)

New in Advanced ETL Processor Enterprise 6.3.12.5 (Aug 31, 2023)

  • Improved: Logging fro send email package action

New in Advanced ETL Processor Enterprise 6.3.12.4 (Aug 8, 2023)

  • Improved: Copy and clone functionality

New in Advanced ETL Processor Enterprise 6.3.12.3 (Aug 4, 2023)

  • Improved: SFTP working with private keys

New in Advanced ETL Processor Enterprise 6.3.12.2 (Jul 25, 2023)

  • Disabled: ODATA Connection as no longer necessary
  • Improved: Ofiice365 Email monitor check for new emails only

New in Advanced ETL Processor Enterprise 6.3.12.1 (Jul 12, 2023)

  • Added: Dynamic pivot example

New in Advanced ETL Processor Enterprise 6.3.12.0 (Jul 3, 2023)

  • Added: User defined fields to properties dialogs

New in Advanced ETL Processor Enterprise 6.3.11.28 (Jun 22, 2023)

  • Added: Ability to detach tabs
  • Added: Added XML/XSLT editor to XSLT Transformation package action
  • Improved: Object Library Grid
  • Improved: Adding Objects from Library
  • Improved: Seach dailogue is sorted by type and description by default
  • Fixed: Invalid Variant Type bug in Object Library Grid

New in Advanced ETL Processor Enterprise 6.3.11.27 (Jun 14, 2023)

  • Fixed: File is locked bug.

New in Advanced ETL Processor Enterprise 6.3.11.26 (Jun 13, 2023)

  • Added: Ability to save packages and transformations as bmp files.
  • Added: Office 365 connection cache.

New in Advanced ETL Processor Enterprise 6.3.11.25 (Jun 7, 2023)

  • Fixed: Office 365 email memory leak

New in Advanced ETL Processor Enterprise 6.3.11.24 (Jun 5, 2023)

  • Added: User Input Package Action

New in Advanced ETL Processor Enterprise 6.3.11.23 (Jun 2, 2023)

  • Added: Default Application Platform to options dialogue

New in Advanced ETL Processor Enterprise 6.3.11.22 (May 26, 2023)

  • Improved: Repository Synchronization Wizard error handling
  • Improved: Variables Logging handling
  • Improved: aetlcl.exe error handling

New in Advanced ETL Processor Enterprise 6.3.11.21 (May 25, 2023)

  • Improved: The total number of demos is 87 now

New in Advanced ETL Processor Enterprise 6.3.11.20 (May 22, 2023)

  • Improved: Excel operation action
  • Added: Added ability to merge two Excel files without losing formating
  • Added: Added ability to set Excel file active sheet

New in Advanced ETL Processor Enterprise 6.3.11.19 (May 15, 2023)

  • Added: New demo: how to embed pictures into an email
  • Fixed: Removed insert image button from Send email action dialogue

New in Advanced ETL Processor Enterprise 6.3.11.18 (May 10, 2023)

  • Improved: The total number of demos is 84 now
  • Improved: Error handling of HTTP download package action
  • Improved: Error handling of SOAP package action
  • Improved: Installation process

New in Advanced ETL Processor Enterprise 6.3.11.17 (Apr 10, 2023)

  • Improved: Excel Operation Action working with mask

New in Advanced ETL Processor Enterprise 6.3.11.16 (Mar 31, 2023)

  • Improved: Ping package action error handling and logging

New in Advanced ETL Processor Enterprise 6.3.11.15 (Mar 30, 2023)

  • Improved: Reduced SQL server connection timeout to 20 seconds for check connection package action
  • Added: Timeout to Ping package action

New in Advanced ETL Processor Enterprise 6.3.11.14 (Mar 17, 2023)

  • Fixed: Issues with showing lookup data

New in Advanced ETL Processor Enterprise 6.3.11.13 (Mar 12, 2023)

  • Fixed: Issues with package execution default result

New in Advanced ETL Processor Enterprise 6.3.11.12 (Mar 5, 2023)

  • Improved: Increased Data writer fields' dedifintions widths

New in Advanced ETL Processor Enterprise 6.3.11.10 (Jan 15, 2023)

  • Added: Write Variables Check Box to options dialogue

New in Advanced ETL Processor Enterprise 6.3.11.9 (Jan 4, 2023)

  • Added: Support for SSH Connections to MySQL,Postgres and MongoDDB
  • Added: Start at option to Execute external application package action
  • Improved: Data writer working with variables
  • Improved: Data writer error handling

New in Advanced ETL Processor Enterprise 6.3.11.8 (Jan 4, 2023)

  • Added: Support for SSH Connections to MySQL,Postgres and MongoDDB
  • Improved: Data writer working with variables

New in Advanced ETL Processor Enterprise 6.3.11.7 (Dec 9, 2022)

  • Added: Rest Writer.

New in Advanced ETL Processor Enterprise 6.3.11.6 (Nov 27, 2022)

  • Fixed: ExecuteObject Failure - Index Out of Bounds

New in Advanced ETL Processor Enterprise 6.3.11.5 (Nov 24, 2022)

  • Fixed: Office 35 Email Writer AV.

New in Advanced ETL Processor Enterprise 6.3.11.4 (Nov 21, 2022)

  • Fixed: UID was missing from Office 35 Email Reader

New in Advanced ETL Processor Enterprise 6.3.11.3 (Nov 20, 2022)

  • Added: Office 35 Email Writer

New in Advanced ETL Processor Enterprise 6.3.11.2 (Nov 10, 2022)

  • Added: Office 35 Email Reader

New in Advanced ETL Processor Enterprise 6.3.11.1 (Oct 26, 2022)

  • Fixed: Incorrect variable date format

New in Advanced ETL Processor Enterprise 6.3.11.0 (Sep 28, 2022)

  • Added: Support for Office 365 Email monitor
  • Improved: Office 365 connection dialogue error handling
  • Fixed: Issue with deleting nodes on maintain tab

New in Advanced ETL Processor Enterprise 6.3.10.11 (Sep 26, 2022)

  • Added: variable

New in Advanced ETL Processor Enterprise 6.3.10.11 (Sep 26, 2022)

  • Added: variable

New in Advanced ETL Processor Enterprise 6.3.10.10 (Aug 26, 2022)

  • Renamed: "Split RegX" to Split RegX Static
  • Added: Split RegX Dynamic transformation function
  • Improved: Office 365 email logging

New in Advanced ETL Processor Enterprise 6.3.10.8 (Aug 10, 2022)

  • Improved: Schedule sorting

New in Advanced ETL Processor Enterprise 6.3.10.7 (Jul 12, 2022)

  • Fixed: Issue with Replace RegX transformation function.

New in Advanced ETL Processor Enterprise 6.3.10.6 (Jul 9, 2022)

  • Added: Do not create empty files option to Export Package Action

New in Advanced ETL Processor Enterprise 6.3.10.5 (Jul 9, 2022)

  • Fixed: Viewing Views Issues while browsing the data
  • Improved: Loading data into smalldatetime fields

New in Advanced ETL Processor Enterprise 6.3.10.4 (Jun 11, 2022)

  • Fixed: Missing DLL's.

New in Advanced ETL Processor Enterprise 6.3.10.3 (May 24, 2022)

  • Fixed: AV when adding new field to Joiner properties dialogue

New in Advanced ETL Processor Enterprise 6.3.10.2 (May 18, 2022)

  • Fixed: Databuffer double procession bug

New in Advanced ETL Processor Enterprise 6.3.10.0 (Mar 22, 2022)

  • Added: Appache Kafka connection
  • Added: Receive Appache Kafka message action
  • Added: Send Appache Kafka message action

New in Advanced ETL Processor Enterprise 6.3.9.5 (Mar 10, 2022)

  • Added: User name to log file name
  • Improved: Report Package Action generator embeds fonts by default now

New in Advanced ETL Processor Enterprise 6.3.9.4 (Mar 3, 2022)

  • Added: Ignore null option to Date format, Date part, Reformat date, Date diff, Local Date to UTC,UTC to Local Date,Date to Epoch transformation functions
  • Fixed: Issue with sending emails in UTF-8 fromat

New in Advanced ETL Processor Enterprise 6.3.9.3 (Feb 15, 2022)

  • Added: Support for dynamic field names (delimited files only)
  • Added: Support for RabbitMQ to data writer and reader

New in Advanced ETL Processor Enterprise 6.3.9.2 (Feb 8, 2022)

  • Added: Out parameters to reports
  • Fixed: Issue with running Oracle SQL scripts from sql script screen

New in Advanced ETL Processor Enterprise 6.3.9.1 (Feb 3, 2022)

  • Fixed: Is value In Database transformation function bug

New in Advanced ETL Processor Enterprise 6.3.9.0 (Jan 15, 2022)

  • Added: RabbitMQ connection
  • Added: Receive RabbitMQ message action
  • Added: Send RabbitMQ message action
  • Improved: Look and feel while working with High Dpi monitors
  • Improved: Default theme is set to Office 2016 White
  • Fixed: Issues with running import scripts from the package

New in Advanced ETL Processor Enterprise 6.3.8.3 (Dec 17, 2021)

  • Improved: Note's custom colours are persisted across user sessions
  • Improved: Package Note's can be added to the object library now

New in Advanced ETL Processor Enterprise 6.3.8.2 (Dec 15, 2021)

  • Added: GUIDNB Transformation language function, it returns clean GUID value without brackets and underscores
  • Added: variable
  • Added: Fail On Zero Writes option to Transformation Package Action

New in Advanced ETL Processor Enterprise 6.3.8.1 (Dec 6, 2021)

  • Fixed: IMAP4 and POP3 AV

New in Advanced ETL Processor Enterprise 6.3.8.0 (Nov 30, 2021)

  • Added: Office 365 connection
  • Added: receive Office 365 email action
  • Added: ability to save emails as EML files
  • Added: option to mark emails as read
  • Added: option to download unread/read emails only
  • Added: Send email action support office 365 connections
  • Fixed: Issues with downloading large files via HTTP/HTTPS
  • Fixed: Issues with file metadata package actions
  • Added: Automatic retry for STP downloads/uploads
  • Added: Ability to run transformations without a writer

New in Advanced ETL Processor Enterprise 6.3.7.32 (Nov 4, 2021)

  • Added: variable

New in Advanced ETL Processor Enterprise 6.3.7.31 (Oct 18, 2021)

  • Added: Search string dialogue to the objects tree

New in Advanced ETL Processor Enterprise 6.3.7.30 (Oct 2, 2021)

  • Added: Ability to ignore missing files to file operation

New in Advanced ETL Processor Enterprise 6.3.7.29 (Sep 27, 2021)

  • Added: Search properties dialogue to package designer
  • Improved: Replace dialogue functionality
  • Improved: Excel components update
  • Fixed: Issues with long month names

New in Advanced ETL Processor Enterprise 6.3.7.28 (Sep 19, 2021)

  • Improved: FTP Error handling

New in Advanced ETL Processor Enterprise 6.3.7.27 (Jul 23, 2021)

  • Improved: XML Reading performance
  • Fixed: XSLT Transformation Action variable inside file name bugs

New in Advanced ETL Processor Enterprise 6.3.7.26 (Jul 16, 2021)

  • Fixed: Issues with saving email attachments.

New in Advanced ETL Processor Enterprise 6.3.7.25 (Jul 12, 2021)

  • Fixed: Minor Issues with logging

New in Advanced ETL Processor Enterprise 6.3.7.24 (Jun 30, 2021)

  • Fixed: Issues with closing ODBC connection when refreshing target fields list.

New in Advanced ETL Processor Enterprise 6.3.7.23 (Jun 27, 2021)

  • Added: Ability to load variables from CSV file to Set Variable Package Action
  • Added: Ability to add Notes to Transformations, SQL Scripts, Import Scripts, Packages and Email templates

New in Advanced ETL Processor Enterprise 6.3.7.22 (Jun 21, 2021)

  • Fixed: Windows log message format
  • Added: Arrange Objects On Save to optios dialogue
  • Improved: Removed redundant options from options dialogue

New in Advanced ETL Processor Enterprise 6.3.7.21 (Jun 11, 2021)

  • Improved: Split RegX transformation function.

New in Advanced ETL Processor Enterprise 6.3.7.20 (Jun 3, 2021)

  • Fixed: Issues with lookup error handling
  • Improved: All package actions dialogs are resizable now
  • Improved: Email dialogue design

New in Advanced ETL Processor Enterprise 6.3.7.19 (May 20, 2021)

  • Fixed: Issue with multiple semicolons within soap header

New in Advanced ETL Processor Enterprise 6.3.7.18 (Apr 20, 2021)

  • Fixed: SFTP Upload issues when no files are found.

New in Advanced ETL Processor Enterprise 6.3.7.17 (Apr 11, 2021)

  • Improved:
  • Various cosmetic changes
  • Data import wizard object resizing
  • Added New and Edit to all connection dialogue headers
  • Connection dialogue is closed by pressing the ESC button
  • Changed table search from case sensitive to not case sensitive
  • Working with HTML tables
  • Fixed:
  • Twitter drag and drop was not working
  • Search dialogue issues
  • HTTP downloads shows message twice in the status bar
  • Restore Project Dialogue issues
  • Undo/Redo issues while working with source/target grid

New in Advanced ETL Processor Enterprise 6.3.7.16 (Apr 3, 2021)

  • Improved: User can select HTML table file from import script designer
  • Improved: Send email package action uses HTML by default
  • Improved: Send email package action adds the selected file to the list of attachments automatically
  • Added: Support for variables to IMAP4/POP3 regular expressions.
  • Fixed: Licensing issues when running the software on AWS servers.
  • Fixed: Directory monitor issues when working with NAS storage.
  • Fixed: Access violations when reading excel files

New in Advanced ETL Processor Enterprise 6.3.7.15 (Mar 22, 2021)

  • Improved: Tableau hyper error handling
  • Improved: Group dialogue. When user presses enter the dialogue is automatically closed
  • Fixed: Minor mapping designer bugs

New in Advanced ETL Processor Enterprise 6.3.7.14 (Mar 18, 2021)

  • Added: Extract Attachments option to IMAP4 and POP3 reader
  • Added: Email footer message
  • Added: Cache option to "Get Excel Cell Value Dynamic" transformation function
  • Improved: When the application starts it will ask the user "Reopen last objects? (It will only happen if reopen tabs option is checked)
  • Removed: IP Location, URL Location and Url Shortener transformation functions
  • Removed: Transformation type toolbar from the mapping designer
  • Fixed: Issue with empty decryption passphrase
  • Fixed: Licence management issues
  • Fixed: Schedule table backup/restore issues

New in Advanced ETL Processor Enterprise 6.3.7.13 (Feb 27, 2021)

  • Improved: It is now possible to use a single transformation to write data into multiple excel sheets of the same file
  • Fixed: Directory monitor screen bugs

New in Advanced ETL Processor Enterprise 6.3.7.12 (Feb 15, 2021)

  • Fixed: Various tableau related bugs
  • Fixed: Pause package action issues
  • Improved: underscore character can be seen in preview mode now

New in Advanced ETL Processor Enterprise 6.3.7.11 (Feb 7, 2021)

  • Fixed: Fixed issue with package variable.

New in Advanced ETL Processor Enterprise 6.3.7.10 (Feb 4, 2021)

  • Added: HTML Table reader
  • Added: Recalculate Excel File check box to excel writer
  • Added: Do nothing option to Receive Email IMAP4 package action
  • Added: variable to Receive Email IMAP4 package action
  • Added: Extract MIME Data package action
  • Fixed: Invalid pointer error while compressing
  • Fixed: FTP Monitor bugs (SFTP Connection issue)
  • Fixed: Field selector access vialation
  • Improved: Field selector performance
  • Updated: Digital signature

New in Advanced ETL Processor Enterprise 6.3.7.9 (Dec 22, 2020)

  • Fixed: Loading data from FoxPro

New in Advanced ETL Processor Enterprise 6.3.7.8 (Dec 19, 2020)

  • Added: GetSystemDate function returns the fractions of a second now
  • Added: IMAP4 writer can move messages to a different folder now
  • Improved: Replace String Wizard
  • Fixed: Installation issues
  • Fixed: Problem with renaming library objects
  • Fixed: Licence management issues
  • Fixed: Issues with cloning connections

New in Advanced ETL Processor Enterprise 6.3.7.6 (Nov 23, 2020)

  • Fixed: Issues with special characters inside sql server database names
  • Fixed: Replace String Wizard bugs
  • Added: Popup menu to Replace String Wizard

New in Advanced ETL Processor Enterprise 6.3.7.5 (Nov 22, 2020)

  • Added: Replace String Wizard
  • Improved: Setup look and feel
  • Fixed: Issues with special characters inside field names

New in Advanced ETL Processor Enterprise 6.3.7.4 (Nov 22, 2020)

  • Fixed: Access violations while using Get Excel Cel Value Dinamic
  • Fixed: Wrong Package Name variable issue
  • Improved: Execution log refresh behaviour

New in Advanced ETL Processor Enterprise 6.3.7.3 (Nov 1, 2020)

  • Added: Support Excel formulas creation

New in Advanced ETL Processor Enterprise 6.3.7.2 (Oct 17, 2020)

  • Improved: SMS connection dialogue

New in Advanced ETL Processor Enterprise 6.3.7.1 (Oct 2, 2020)

  • Added:
  • Owner field to file system reader
  • Owner variable to file metadata package object
  • FileOwner scripting language function

New in Advanced ETL Processor Enterprise 6.3.7.0 (Sep 26, 2020)

  • Added: Support for reading Tableau Hyper files
  • Added: Support for creatinng Tableau Hyper tables
  • Added: Support for python version 3.8 and 3.9
  • Improved: Tableau hyper client update
  • Fixed: Note object color bug
  • Fixed: Options dialogue email bug

New in Advanced ETL Processor Enterprise 6.3.6.17 (Jul 28, 2020)

  • Added: Variables: ,,,,,,
  • Added: Check License package object

New in Advanced ETL Processor Enterprise 6.3.6.16 (Jul 5, 2020)

  • Improved: Support for DATETIME2 Fields

New in Advanced ETL Processor Enterprise 6.3.6.15 (Jun 25, 2020)

  • Fixed: Issues with Azure blob loading

New in Advanced ETL Processor Enterprise 6.3.6.14 (Jun 23, 2020)

  • Fixed: Issues with running packages using GUI

New in Advanced ETL Processor Enterprise 6.3.6.13 (Jun 11, 2020)

  • Fixed: Issues with Accumulate String transformation function

New in Advanced ETL Processor Enterprise 6.3.6.10 (May 17, 2020)

  • Improved: Software registration process
  • Fixed: Issues with Australian Post Code validation

New in Advanced ETL Processor Enterprise 6.3.6.9 (May 4, 2020)

  • Improved: JSON Data Handling

New in Advanced ETL Processor Enterprise 6.3.6.8 (Apr 10, 2020)

  • Added: Support for SQL Server 2017
  • Fixed: Issues with loading data into varchar(max) field
  • Improved: SQL Server error handling

New in Advanced ETL Processor Enterprise 6.3.6.7 (Feb 24, 2020)

  • Improved: Email processing supports regular expressions now
  • Improved: Support for variables was added to IMAP4 folder names

New in Advanced ETL Processor Enterprise 6.3.6.6 (Feb 16, 2020)

  • Improved: Email attachments handling
  • Added: Path builder

New in Advanced ETL Processor Enterprise 6.3.6.5 (Feb 16, 2020)

  • Added: colors to notes
  • Fixed: issues with aborting joiner tranformation on error
  • Fixed: issues with deleting text inside notes

New in Advanced ETL Processor Enterprise 6.3.6.4 (Feb 5, 2020)

  • Added: Support for PostgreSql 12
  • Added: Ability to delete files after compression
  • Improved: Expanded IMAP4 drop down box
  • Fixed: Spelling errors

New in Advanced ETL Processor Enterprise 6.3.6.3 (Jan 30, 2020)

  • Added: Ability to select Amazon connection endpoint
  • Added: variable to Receive Email Package object (IMAP4 and POP3)
  • Fixed: Fixed issue with loosing transformations while closing transformation tab
  • Fixed: Fixed issue with Objects library

New in Advanced ETL Processor Enterprise 6.3.6.2 (Jan 23, 2020)

  • Added: Ability to select Amazon connection endpoint

New in Advanced ETL Processor Enterprise 6.3.6.1 (Dec 1, 2019)

  • Added: IMAP4 as data writer connection
  • Fixed: IMAP4 reader shows UID correctly now

New in Advanced ETL Processor Enterprise 6.3.6.0 (Nov 16, 2019)

  • Added: Support for telegram Bot API

New in Advanced ETL Processor Enterprise 6.3.5.7 (Oct 30, 2019)

  • Fixed: SplitRegX transformation function bug

New in Advanced ETL Processor Enterprise 6.3.5.6 (Oct 1, 2019)

  • Added: Select Objects with no links menu option
  • Added: Select Inputs menu option
  • Added: Select Outputs menu option
  • Added: Select Linked Objects menu option

New in Advanced ETL Processor Enterprise 6.3.5.5 (Sep 16, 2019)

  • Added: Added ability to pull license from the license server
  • Fixed: Package copy/paste issues
  • Fixed: Eventlog crashes
  • Fixed: Bat files execution problems
  • Fixed: Last record flag issue for files with two lines

New in Advanced ETL Processor Enterprise 6.3.5.4 (Jul 28, 2019)

  • Fixed: Objects Library bugs
  • Added: Parameters to External Application package acction

New in Advanced ETL Processor Enterprise 6.3.5.3 (Jul 11, 2019)

  • Added: Case sensitive option to Lookup transformation object

New in Advanced ETL Processor Enterprise 6.3.5.2 (Jul 7, 2019)

  • Added: Restore repository option
  • Fixed: Issues with joining empty files

New in Advanced ETL Processor Enterprise 6.3.5.1 (Jul 1, 2019)

  • Added: Clear log Action
  • Improved: Loop Action Logging
  • Improved: Set Variable Action
  • Improved: Salesforce connection uses TLS 1.2 now
  • Fixed: Project clone issues

New in Advanced ETL Processor Enterprise 6.3.5.0 (Jun 18, 2019)

  • Added: Support for Amazon S3 and Azure Blobs
  • Added: Amazon S3 operations: Download, upload and delete files, Create and delete baskets, Download basket files List
  • Added: Azure blob operations: Download, upload and delete files, Create and delete containers, Download container files List
  • Improved: Third party components update:

New in Advanced ETL Processor Enterprise 6.3.4.12 (May 13, 2019)

  • Added: Syslog datasource

New in Advanced ETL Processor Enterprise 6.3.4.11 (May 1, 2019)

  • Fixed: JSON Data reader AV

New in Advanced ETL Processor Enterprise 6.3.4.10 (Apr 22, 2019)

  • Improved: Excel action can change file extension now

New in Advanced ETL Processor Enterprise 6.3.4.9 (Mar 26, 2019)

  • Improved: Software Installation Process
  • Improved: Third Party Components Update
  • Fixed: Minor Python Integration Issues

New in Advanced ETL Processor Enterprise 6.3.4.8 (Mar 23, 2019)

  • Improved: if registration fails message is displayed
  • Improved: "Disable Package Actions Variables By Default" is not be enabled by Default.

New in Advanced ETL Processor Enterprise 6.3.4.7 (Mar 20, 2019)

  • Improved: if an object is read only, it's shown in grey color
  • Improved: Added right context menu to the tabbed view of the designers, it allows to autosave all items being closed
  • Improved: Added '[-4]-Finish Package Execution - Failure' option to all package action's designers
  • Improved: Added '[-3]-Finish Package Execution - Success' option to all package action's designers

New in Advanced ETL Processor Enterprise 6.3.4.6 (Mar 7, 2019)

  • Improved: Extracts data from OLE Db up to 4 times faster
  • Improved: Extracts data from SQLite up to 2 times faster
  • Improved: The application starts much faster
  • Improved: It is now possible to add files to the existing archives
  • Fixed: Issues with reading google spreadsheet data

New in Advanced ETL Processor Enterprise 6.3.4.4 (Dec 21, 2018)

  • Added: New datasource - Twitter
  • Improved: Loads data into SQL server up to 25 percent faster
  • Improved: Generating Tableau hyper files up to 25 percent faster
  • Improved: Generating Tableau tde files up to 30 percent faster
  • Improved: Active Directory Connection look and feel
  • Improved: Twitter message can include pictures
  • Improved: Gpg4win support for variables

New in Advanced ETL Processor Enterprise 6.3.4.3 (Nov 22, 2018)

  • Improved:
  • Slight performance improvement

New in Advanced ETL Processor Enterprise 6.3.4.2 (Oct 15, 2018)

  • Added:
  • Change Encoding Package Action

New in Advanced ETL Processor Enterprise 6.3.4.1 (Sep 24, 2018)

  • Added: Ability to download,upload,delete and create directories to FTP Monitor dialog

New in Advanced ETL Processor Enterprise 6.3.4.0 (Sep 10, 2018)

  • Added: Support for DropBox, Google Drive, Microsoft OneDrive, Box, Amazon Cloud Drive, Hubic, HiDrive and Yandex Disk cloud storage
  • Added: Cloud storage operations: Download, Upload, Create Remote Directory, Delete Remote Directory, Delete Files and Directory List
  • Added: Enable logging option to FTP Action Properties dialog
  • Added: Ability to download,upload,delete and create directories to FTP Action Properties dialog
  • Added: Enable logging option to POP3 Action Properties dialog
  • Added: Enable logging option to IMAP4 Action Properties dialog
  • Improved: Made FTP Action Properties dialog re sizable
  • Improved: Various bug fixes and improvements

New in Advanced ETL Processor Enterprise 6.3.3.2 (Aug 22, 2018)

  • Improved: JSON null values handling

New in Advanced ETL Processor Enterprise 6.3.3.1 (Aug 21, 2018)

  • Added: Loading data into Google Spreadsheets
  • Improved: Third party components update
  • Fixed: FTP Upload Issues

New in Advanced ETL Processor Enterprise 6.3.2.18 (Aug 13, 2018)

  • Fixed: Issues with loading data into Varchar(MAX) fields (SQL Server)
  • Improved: transformer fields metadata

New in Advanced ETL Processor Enterprise 6.3.2.17 (Jul 27, 2018)

  • Added: Added Get Excel Cell Value Dynamic transformation function
  • Improved: Object selection visibility

New in Advanced ETL Processor Enterprise 6.3.2.16 (Jul 23, 2018)

  • Improved: Third party components update

New in Advanced ETL Processor Enterprise 6.3.2.15 (Jul 17, 2018)

  • Improved: loading data into sql server is up to 10 percent faster
  • Fixed: Addressed issues with loading data into XML,Image and Identity fields (SQL Server)

New in Advanced ETL Processor Enterprise 6.3.2.14 (Jul 14, 2018)

  • Improved: Up to two times faster loading data into sql server
  • Added: Support for TLS 1.2 SQL Server connections

New in Advanced ETL Processor Enterprise 6.3.2.13 (Jul 12, 2018)

  • Improved: Made Calculation dialogue box resizable
  • Improved: Made Script Package Action dialogue box resizable
  • Improved: Made Send Email Package Action dialogue box resizable
  • Fixed: Issues with exporting data into csv and tab files from grids

New in Advanced ETL Processor Enterprise 6.3.2.12 (Jul 7, 2018)

  • Added: GetWindowsTemporaryDirectory,GetTemporaryFile,GetTemporaryFileInDirectory,GetTemporaryDirectory transformation language functions
  • Added: Get File Content Dynamic transformation function
  • Improved: Third party components update
  • Improved: Pivot and unpivot performance

New in Advanced ETL Processor Enterprise 6.3.2.11 (Jul 7, 2018)

  • Fixed: Loading Data Into Time Fields

New in Advanced ETL Processor Enterprise 6.3.2.10 (Jul 3, 2018)

  • Added: ReadMe file to backup
  • Improved: Archive error handling
  • Improved: Setup Process

New in Advanced ETL Processor Enterprise 6.3.2.8 (Jun 23, 2018)

  • Improved: Spelling corrections
  • Improved: Email Notifications can be send on all package failures
  • Improved: SMTP connection testing
  • Improved: Automatic database refresh

New in Advanced ETL Processor Enterprise 6.3.2.7 (Jun 20, 2018)

  • Improved: Google Spreadsheet import
  • Improved: Google Spreadsheet Reader Connection
  • Improved: Google Spreadsheet Reader works with intenational characters correctly now
  • Improved: SQL Lookup transformation dialogue
  • Fixed: Salesforce Bulk API load issues
  • Fixed: SQL Lookup transformation issues
  • Fixed: aetlcl.exe AV

New in Advanced ETL Processor Enterprise 6.3.2.6 (Jun 14, 2018)

  • Fixed: Round Transformation Function issues
  • Fixed: Issues with exporting very large grids into excel files

New in Advanced ETL Processor Enterprise 6.3.2.5 (Jun 12, 2018)

  • Fixed: Reader Autoformat issues

New in Advanced ETL Processor Enterprise 6.3.2.4 (Jun 6, 2018)

  • Improved: Error handling for open files

New in Advanced ETL Processor Enterprise 6.3.2.3 (Jun 5, 2018)

  • Fixed: Package logging issues
  • Fixed: Registration issues
  • Improved: Added writer number to Tranformation statistics varibles

New in Advanced ETL Processor Enterprise 6.3.2.1 (May 30, 2018)

  • Added: and packages variables

New in Advanced ETL Processor Enterprise 6.3.2.0 (May 25, 2018)

  • Improved: Directory Monitor
  • Added: New events to watch to Directory Monitor: add, delete, modify and rename files
  • Added: Wait and Timeout option to Directory Monitor
  • Fixed: Salesforce Bulk API load issues

New in Advanced ETL Processor Enterprise 6.3.1.0 (May 10, 2018)

  • Added: Support fot Hyper Tableau files (64 bit version)
  • Added: Upload type option to Publish Tableau File action dialogue
  • Added: "If File Exists" option to Publish Tableau File action dilaogue
  • Added: Support for hyper,tdsx,twb,twbx files to Publish Tableau File action
  • Improved : Publish Tableau File action uses rest now
  • Improved: Third party components update

New in Advanced ETL Processor Enterprise 6.3.0.5 (Apr 10, 2018)

  • Added : Package EMail attachment filter

New in Advanced ETL Processor Enterprise 6.3.0.4 (Apr 2, 2018)

  • Fixed : Loop action issue with adding values
  • Improved : Demos

New in Advanced ETL Processor Enterprise 6.3.0.3 (Mar 7, 2018)

  • Fixed : #3D000 No database selected issue
  • Fixed : Uploading large files via SFTP

New in Advanced ETL Processor Enterprise 6.3.0.2 (Mar 4, 2018)

  • Updated : SFTP components
  • Improved : Backup Error handling
  • Improved : Repository Switching
  • Fixed : Various bug fixes and improvements

New in Advanced ETL Processor Enterprise 6.3.0.1 (Feb 25, 2018)

  • Fixed : Loading data into Google spreadsheet
  • Fixed : Issues with SFTP keys storage
  • Added: Ansi Driver checkbox to odbc connections

New in Advanced ETL Processor Enterprise 6.3.0.0 (Feb 18, 2018)

  • Added: Support for MongoDB
  • Added: Ability to delete nodes
  • Various bug fixes and improvements
  • Repository connection details and designer user interface settings are no longer stored in the registry, ini files are used instead

New in Advanced ETL Processor Enterprise 6.2.2.0 (Jan 28, 2018)

  • Fixed : Addressed issues with saving connection details (SQL Scripts and Report screen)

New in Advanced ETL Processor Enterprise 6.2.1.0 (Jan 20, 2018)

  • Added: HTTP Headers page to Soap,HTTP Download and HTTP form package actions
  • Fixed : Issues with loading data from POP3 connection as part of the Package

New in Advanced ETL Processor Enterprise 6.1.0.0 (Oct 23, 2017)

  • Improved: Restoring backups (Some users add fields to repository tables and that led restore failures)
  • Improved: Look and feel of Pivot object on win2008 server
  • Improved: Look and feel of UnPivot object on win2008 server
  • Improved: Look and feel of Application options dialogue on win2008 server
  • Improved: Look and feel of Smtp connection dialogue on win2008 server
  • Improved: Object Selection Drop donw always shows correct icon now (Scheduler Dialogue and Event Monitor Dialogue)
  • Improved: Removed "Every" field from event_monitors table
  • Improved: Third party components update (Data Grid)
  • Improved: Empty Data Grids show message
  • Improved: Execution log within Package editor looks the same way as execution log (Tree)

New in Advanced ETL Processor Enterprise 6.0.1.0 (Oct 2, 2017)

  • Improved: Third party components update (Excel)
  • Improved: Changed logic fro processing excel files: if software is unable to open file transformation is aborted
  • Added: Check file to Excel Operation Action

New in Advanced ETL Processor Enterprise 6.0.0.13 (Sep 8, 2017)

  • Fixed :
  • Issues with Ping Package Action

New in Advanced ETL Processor Enterprise 6.0.0.12 (Sep 1, 2017)

  • Fixed : Issues with JSON transformations

New in Advanced ETL Processor Enterprise 6.0.0.11 (Aug 28, 2017)

  • Fixed : Issues with reading JSON data

New in Advanced ETL Processor Enterprise 6.0.0.10 (Aug 28, 2017)

  • Added : HTML Editor to Email Action
  • Added : Support for sending embeded images
  • Improved: Pause Package Action

New in Advanced ETL Processor Enterprise 6.0.0.9 (Aug 18, 2017)

  • Fixed: Issues with non English repositories

New in Advanced ETL Processor Enterprise 6.0.0.7 (Aug 8, 2017)

  • Fixed: PGP Encryption Action

New in Advanced ETL Processor Enterprise 6.0.0.6 (Jul 31, 2017)

  • Fixed: Issues with reading brightpearl data

New in Advanced ETL Processor Enterprise 6.0.0.5 (Jul 19, 2017)

  • Fixed: Issues with assigning default values to lookup

New in Advanced ETL Processor Enterprise 6.0.0.4 (Jul 15, 2017)

  • Improved: Functionality of Running totals transformation function

New in Advanced ETL Processor Enterprise 6.0.0.3 (Jul 3, 2017)

  • Added : Content type to SOAP action
  • Improved : SOAP action dialogue
  • Improved : Multiline select statement execution
  • Fixed : Issues with Copy/Paste functionality

New in Advanced ETL Processor Enterprise 6.0.0.2 (Jun 23, 2017)

  • Fixed: Issues with FTP downloads
  • Fixed: Azure backup Issues

New in Advanced ETL Processor Enterprise 6.0.0.1 (Jun 19, 2017)

  • Improved: Open SSL libraries update
  • Improved: Up to 30 percent faster
  • Improved: 64 bit setup installs MS Access Ole DB provider automatically

New in Advanced ETL Processor Enterprise 6.0.0.0 (Jun 16, 2017)

  • Options Dialogue:
  • "Execute only local actions" option was removed
  • "Use agent for execution was" removed
  • Maintenance tab:
  • Complete redesign
  • Schedule tab:
  • Execute on computer check box was removed
  • Schedule dialogue:
  • Execute on computer check box was removed
  • Application Platform drop down box was added
  • Execution log tab:
  • Execute on computer check box was removed
  • Added Submitted,Executed and Platform fields
  • Submitted = application name which added action to the execution queue
  • Submitted = application name which executed the action
  • Submitted = application platform which executed the action (Windows 32bit or Windows 64bit)
  • It is now possible to change use agent option

New in Advanced ETL Processor Enterprise 5.9.4.8 (Jun 14, 2017)

  • Added :
  • Support for SFTP Private Keys
  • Fixed :
  • Issues with QVX Files reading

New in Advanced ETL Processor Enterprise 5.9.4.7 (May 31, 2017)

  • Added :Paste functionality to target definitions (writer fields grid)

New in Advanced ETL Processor Enterprise 5.9.4.5 (May 17, 2017)

  • Fixed: Issues with loading version info

New in Advanced ETL Processor Enterprise 5.9.4.3 (May 11, 2017)

  • Fixed: HTTP Form post action issues

New in Advanced ETL Processor Enterprise 5.9.4.2 (Apr 11, 2017)

  • Added: Tableau Server Connection
  • Added: Publishing Tableau TDE Files
  • Improved: Updated Tableau Client

New in Advanced ETL Processor Enterprise 5.9.3.23 (Mar 26, 2017)

  • mproved: Setup has an option to download Tableau client now
  • Added : SQL Lookup Transformation Function
  • Fixed : Scrolling issues
  • Fixed : Change date dynamic bug

New in Advanced ETL Processor Enterprise 5.9.3.21 (Mar 13, 2017)

  • Fixed : Issues with About Dialogue
  • Fixed : Issues with Registration Dialogue
  • Improved: Setup procedure

New in Advanced ETL Processor Enterprise 5.9.3.20 (Mar 10, 2017)

  • Fixed : Issues with loading version info

New in Advanced ETL Processor Enterprise 5.9.3.19 (Mar 10, 2017)

  • Improved: Maximum ODBC Connection String is 4K now
  • Fixed : One Row QVD creation bug

New in Advanced ETL Processor Enterprise 5.9.3.18 (Feb 19, 2017)

  • Fixed: Issues with system variables

New in Advanced ETL Processor Enterprise 5.9.3.15 (Feb 19, 2017)

  • Improved: Look and feel of object joins
  • Improved: Installation
  • Fixed: Issues with Space horizontally and vertically logic
  • Fixed: Issues with moving objects within object tree

New in Advanced ETL Processor Enterprise 5.9.3.14 (Jan 16, 2017)

  • Improved: Updated Salesforce API to v38
  • Fixed: Addressed issues with log refresh

New in Advanced ETL Processor Enterprise 5.9.3.13 (Jan 16, 2017)

  • Added: Number Of Files Found variable to File Operation, Check File, Zip and FTP Package actions
  • Improved: Report generator components update
  • Improved: Query Builder components update
  • Improved: SSL components update
  • Improved: Improved file delete messages
  • Improved: Repository Creation Wizard
  • Improved: Removed Agent management buttons from log tab and schedule tab
  • Improved: Removed Number of executions field from log tab
  • Improved: Removed clutter from maintain tab
  • Fixed: Addressed issues with scheduler next execution date calculation
  • Fixed: Addressed issues with SFTP file downloads

New in Advanced ETL Processor Enterprise 5.9.3.12 (Dec 23, 2016)

  • Improved : Schedule dialog allows to enter multiple lines now

New in Advanced ETL Processor Enterprise 5.9.3.11 (Dec 23, 2016)

  • Fixed : Issues with MySQL Repository

New in Advanced ETL Processor Enterprise 5.9.3.9 (Dec 13, 2016)

  • Added : FTP Files list as datasource
  • Added : Object Dependency search
  • Fixed : Issues with updating data via table browser

New in Advanced ETL Processor Enterprise 5.9.3.7 (Dec 5, 2016)

  • Added : Added displayName, distinguisedName, initials, mailNickname, publicDelegates, sAMAccountType, scriptPath, showInAddressBook, sn, pager, extensionAttribute1-extensionAttribute15 fields to ActiveDirectory extract
  • Improved : Third party componets update
  • Improved : Table generation
  • Improved : FTP Listing generation

New in Advanced ETL Processor Enterprise 5.9.3.6 (Dec 5, 2016)

  • Added : Support for SFTP V06
  • Added : Table generation option to writer grid
  • Fixed : Issues with reading data from SalesForce

New in Advanced ETL Processor Enterprise 5.9.3.5 (Nov 23, 2016)

  • Added : Excel Operation action

New in Advanced ETL Processor Enterprise 5.9.3.4 (Nov 23, 2016)

  • Added : Option to disable record count
  • Improved : Once deleted packages are disabled in the scheduler
  • Fixed : Fixed issues with reading XML files

New in Advanced ETL Processor Enterprise 5.9.3.3 (Oct 30, 2016)

  • Improved: Up to 10 percent performance increase while loading data into date/time fields

New in Advanced ETL Processor Enterprise 5.9.3.1 (Oct 28, 2016)

  • Added: and variables
  • Improved: Support for JSON as data source

New in Advanced ETL Processor Enterprise 5.9.3.0 (Oct 10, 2016)

  • Added: Support for JSON as data source and target
  • Added: File Metadata Action
  • Improved : Object tree search functionality
  • Improved : Lookup transformation supports JSON as datas source now

New in Advanced ETL Processor Enterprise 5.9.1.9 (Apr 20, 2016)

  • Address issues with Change Date Static,Change Date Dynamic and If WeekDay functions
  • Addressed Salesforce data update issues

New in Advanced ETL Processor Enterprise 5.9.1.8 (Apr 20, 2016)

  • Addressed Salesforce data update issues

New in Advanced ETL Processor Enterprise 5.9.1.7 (Apr 20, 2016)

  • Improved support for RSS feeds

New in Advanced ETL Processor Enterprise 5.9.1.5 (Mar 29, 2016)

  • Calculation transformation funtion support Python now

New in Advanced ETL Processor Enterprise 5.9.1.4 (Mar 29, 2016)

  • Addressed issues with Running Total transformation

New in Advanced ETL Processor Enterprise 5.9.1.3 (Mar 29, 2016)

  • Support for latest tableau api was introduced
  • Log Object bugs fixes

New in Advanced ETL Processor Enterprise 5.9.1.2 (Mar 29, 2016)

  • Added Write to File transformation function
  • Minor bug fixes

New in Advanced ETL Processor Enterprise 5.9.1.0 (Mar 29, 2016)

  • Minor transformation designer improvements
  • Script Package action support for Python was introduced

New in Advanced ETL Processor Enterprise 5.9.0.15 (Mar 29, 2016)

  • Package designer bugs fixes
  • Date fields processing bugs fixes

New in Advanced ETL Processor Enterprise 5.9.0.14 (Mar 29, 2016)

  • Joiner Object bugs fixes

New in Advanced ETL Processor Enterprise 5.9.0.11 (Mar 29, 2016)

  • SalesForce data processing fixes

New in Advanced ETL Processor Enterprise 5.9.0.10 (Mar 29, 2016)

  • Addressed DTD is prohibited issues
  • Addressed email processing problems

New in Advanced ETL Processor Enterprise 5.9.0.9 (Mar 29, 2016)

  • PDF Report quality improvements

New in Advanced ETL Processor Enterprise 5.9.0.7 (Feb 6, 2016)

  • Added End of line customisation for text data target
  • Added fail on no emails check box option to POP3 and IMAP4 packages action

New in Advanced ETL Processor Enterprise 5.9.0.6 (Feb 6, 2016)

  • Scheduler bug fix

New in Advanced ETL Processor Enterprise 5.9.0.5 (Feb 6, 2016)

  • Improved support for very large QVD files

New in Advanced ETL Processor Enterprise 5.9.0.4 (Feb 6, 2016)

  • Added ability to filter incoming messages by Recipient, CC and BCC to package actions
  • Addressed Date validation and conversion problems

New in Advanced ETL Processor Enterprise 5.9.0.3 (Feb 6, 2016)

  • SSL Libraries update
  • SalesForce connection uses TLS 1.1 now
  • Third party components update
  • Addressed issues with IMAP4 package action

New in Advanced ETL Processor Enterprise 5.9.0.1 (Feb 6, 2016)

  • Uses tableau API 9.2 now
  • Addressed issues with print preview screen
  • Addressed issues flicking

New in Advanced ETL Processor Enterprise 5.9.0.0 (Jan 11, 2016)

  • 64 bit version initial release
  • Added MRU List to data entry grid
  • Error handling improvements

New in Advanced ETL Processor Enterprise 5.8.4.0 (Dec 7, 2015)

  • Added SOAP package action
  • Added XSLT Transformation package action
  • Added Open Now button to HTTP download package action
  • Addressed issues with getting stored procedures parameters
  • Addressed issues with downloading files via HTTP/HTTPS

New in Advanced ETL Processor Enterprise 5.8.3.23 (Nov 30, 2015)

  • Add refresh databases button to source and target connections
  • Added support for Unicode in server, database and table names
  • ODBC error messages support Unicode now
  • Added processor info to application title
  • Expanded red box size in the status bar
  • Addressed issues with loading data from JDBC data sources
  • Addressed issues with loading data from Windows Event Log
  • Fixed issues with syntax highlighting in Mapping editor

New in Advanced ETL Processor Enterprise 5.8.3.21 (Nov 16, 2015)

  • Addressed issues with downloading files via HTTP/HTTPS

New in Advanced ETL Processor Enterprise 5.8.3.20 (Nov 16, 2015)

  • Addressed issues with creating Excel files

New in Advanced ETL Processor Enterprise 5.8.3.18 (Nov 6, 2015)

  • Added ability to extract 'List of groups the user(s) belongs to' from Active Directory
  • Added ability to extract 'List of group(s) members' from Active Directory
  • Added Active Directory connection

New in Advanced ETL Processor Enterprise 5.8.3.17 (Nov 3, 2015)

  • Added option to save all objects into text files
  • Added option to check network share free space

New in Advanced ETL Processor Enterprise 5.8.3.15 (Nov 3, 2015)

  • Added option to list only file names via ftp
  • Addressed issues with reading very large QVD files
  • Addressed issues with loading empty files via FTP

New in Advanced ETL Processor Enterprise 5.8.3.14 (Oct 26, 2015)

  • Added option to enable all variables in the package
  • Faster QVD files processing
  • Addressed issues with creating QVD files
  • Addressed issues with downloading files using SSL

New in Advanced ETL Processor Enterprise 5.8.3.13 (Oct 21, 2015)

  • Addressed issues with downloading files via HTTP/HTTPS

New in Advanced ETL Processor Enterprise 5.8.3.12 (Oct 19, 2015)

  • Faster QVD files processing
  • Addressed issues with variables

New in Advanced ETL Processor Enterprise 5.8.3.10 (Oct 14, 2015)

  • Added connection status variable to FTP, SMTP, POP3 ad IMAP4 connections
  • Addressed issues with deleting notes from packages
  • Addressed issues for FTP connection's variables

New in Advanced ETL Processor Enterprise 5.8.3.9 (Oct 14, 2015)

  • Third party components update
  • Reduced memory usage for QVD files processing

New in Advanced ETL Processor Enterprise 5.8.3.8 (Oct 6, 2015)

  • Addressed issues with FTP list action
  • Addressed issues with File merge action
  • Addressed issues with Clone row object

New in Advanced ETL Processor Enterprise 5.8.3.6 (Sep 25, 2015)

  • Addressed issues with Loop package action

New in Advanced ETL Processor Enterprise 5.8.3.5 (Sep 24, 2015)

  • Addressed issues with subtransformation function

New in Advanced ETL Processor Enterprise 5.8.3.4 (Sep 22, 2015)

  • Added Ignore Data Format option to Excel Data reader
  • Added Additional Parameters option to GPG4 Package Action
  • Added After Execution tab to all Package Actions
  • Addressed issues with split function

New in Advanced ETL Processor Enterprise 5.8.3.3 (Sep 17, 2015)

  • Added Check Directory Package action
  • Extended reader and writer variables support
  • Added support for variables to Joiner object

New in Advanced ETL Processor Enterprise 5.8.3.2 (Sep 16, 2015)

  • Added Lookup Replace Transformation function
  • Addressed issues with Running Totals functions
  • Addressed issues with joining empty files

New in Advanced ETL Processor Enterprise 5.8.3.0 (Sep 14, 2015)

  • Added support for Active Directory as data source
  • Added catch all objects to package
  • Addressed issues with filtering date
  • Addressed issues with exporting data into excel files

New in Advanced ETL Processor Enterprise 5.8.2.20 (Sep 4, 2015)

  • Addressed issues with loading empty date fields into MySQL
  • Addressed issues with Split Transformation Function

New in Advanced ETL Processor Enterprise 5.8.2.15 (Aug 31, 2015)

  • Smaller Executable
  • Updated regular expression Engine
  • Added Replace RegX and Split RegX transformation functions

New in Advanced ETL Processor Enterprise 5.8.2.14 (Aug 27, 2015)

  • Added Field Value transformation function

New in Advanced ETL Processor Enterprise 5.8.2.13 (Aug 26, 2015)

  • Added UTC To Local Date and Local Date to UTC script functions
  • Added UTC To Local Date and Local Date to UTC transformation functions
  • Addressed issues HTTP Download action

New in Advanced ETL Processor Enterprise 5.8.2.12 (Aug 26, 2015)

  • Added Read File Content Option to Reader
  • Addressed issues with File Creation Dates

New in Advanced ETL Processor Enterprise 5.8.2.10 (Aug 21, 2015)

  • Addressed issues with Log screen

New in Advanced ETL Processor Enterprise 5.8.2.9 (Aug 18, 2015)

  • Added FileLine transformation fuction
  • Addressed issues with Loop package action

New in Advanced ETL Processor Enterprise 5.8.2.8 (Aug 12, 2015)

  • Addressed issues with adding objects to the library
  • Addressed issues with deleting objects from the library

New in Advanced ETL Processor Enterprise 5.8.2.7 (Aug 12, 2015)

  • Added Save button to Transformer and Validator
  • Addressed issues with Slemma Import

New in Advanced ETL Processor Enterprise 5.8.2.6 (Aug 12, 2015)

  • Addressed issues with Loop package action

New in Advanced ETL Processor Enterprise 5.8.2.5 (Aug 1, 2015)

  • Added support for Clarion dat files

New in Advanced ETL Processor Enterprise 5.8.2.4 (Jul 29, 2015)

  • Addressed issues with sending emails with attachments

New in Advanced ETL Processor Enterprise 5.8.2.3 (Jul 29, 2015)

  • Addressed issues with sorter

New in Advanced ETL Processor Enterprise 5.8.2.1 (Jul 21, 2015)

  • All documentation is in wiki format now
  • Addressed issues with starting multiple packages at the same time

New in Advanced ETL Processor Enterprise 5.8.2.0 (Jul 20, 2015)

  • Added support for Slemma

New in Advanced ETL Processor Enterprise 5.8.1.7 (Jul 13, 2015)

  • Excel Import and export from data grids is much faster now
  • Addressed issues with exporting data as excel from data grids

New in Advanced ETL Processor Enterprise 5.8.1.5 (Jul 13, 2015)

  • Added Encode JSON Object and Decode JSON Object transformation functions
  • Added Encode JSON Array and Decode JSON Array transformation functions
  • Added Encode JSON Pair and Decode JSON Pair transformation functions
  • Addressed issues with deleting records

New in Advanced ETL Processor Enterprise 5.8.1.3 (Jun 29, 2015)

  • Added Encode JSON String and Decode JSON String
  • Addressed issues with deduplicator

New in Advanced ETL Processor Enterprise 5.8.1.2 (Jun 23, 2015)

  • Added trim option to format field names dialogue
  • Updated set fields' names functionality

New in Advanced ETL Processor Enterprise 5.8.1.1 (Jun 23, 2015)

  • Extended Date Diff functionality

New in Advanced ETL Processor Enterprise 5.8.1.0 (Jun 15, 2015)

  • Google spreadsheet API update
  • Support for Salesforce Bulk API was introduced
  • Added MONTH_EXACT to DateDiffS function
  • Zip libraries update
  • Added Search in subdirectories Option to File Operation, Check File and Archive Actions
  • Added agent management buttons to Log and Schedule tabs

New in Advanced ETL Processor Enterprise 5.8.0.38 (Jun 4, 2015)

  • IMAP4 and POP3 fixes
  • Various bugs fixes and improvements

New in Advanced ETL Processor Enterprise 5.8.0.37 (Jun 2, 2015)

  • Support for salesforce BULK API was introduced
  • Report buider version update
  • Various bugs fixes and improvements

New in Advanced ETL Processor Enterprise 5.8.0.36 (May 27, 2015)

  • Addressed issues with loading null values into salesforce

New in Advanced ETL Processor Enterprise 5.8.0.35 (May 26, 2015)

  • Addressed issues with loading data from SQL Server CE

New in Advanced ETL Processor Enterprise 5.8.0.34 (May 19, 2015)

  • Addressed issues with loading data from delimited files

New in Advanced ETL Processor Enterprise 5.8.0.33 (May 19, 2015)

  • Addressed issues with groupper transformation
  • Various bugs fixes and improvements

New in Advanced ETL Processor Enterprise 5.8.0.32 (May 19, 2015)

  • Documentation update
  • Added GetExcelCellValue calculation function
  • Sorter improvements

New in Advanced ETL Processor Enterprise 5.8.0.31 (May 8, 2015)

  • Documentation update
  • Added GetExcelCellValue calculation function
  • Sorter improvements

New in Advanced ETL Processor Enterprise 5.8.0.30 (Apr 30, 2015)

  • Improved performance of Join Transformation.
  • Updated version of Report Editor
  • Addressed issues with memory management

New in Advanced ETL Processor Enterprise 5.8.0.29 (Apr 19, 2015)

  • Addressed issues with Is Number validation function

New in Advanced ETL Processor Enterprise 5.8.0.28 (Apr 17, 2015)

  • Added ability to swap reader and writer
  • Added support for 255 length fields names in Union All object

New in Advanced ETL Processor Enterprise 5.8.0.27 (Apr 16, 2015)

  • GetExcelCellValue function provides more detailed information about errors now
  • Addressed issues with retrieving information about Primary keys
  • Addressed issues with parallel sorting

New in Advanced ETL Processor Enterprise 5.8.0.25 (Apr 14, 2015)

  • Added ability to delete and insert items in the middle of Split, Join and calculation object

New in Advanced ETL Processor Enterprise 5.8.0.24 (Apr 14, 2015)

  • Added email notifications functionality to execution agent
  • Documentation update
  • Addressed issues with date fields processing

New in Advanced ETL Processor Enterprise 5.8.0.23 (Apr 10, 2015)

  • Addressed issues with date formats

New in Advanced ETL Processor Enterprise 5.8.0.21 (Apr 8, 2015)

  • Addressed issues with processing of delimited files

New in Advanced ETL Processor Enterprise 5.8.0.20 (Apr 1, 2015)

  • Up to 6 times faster data deduplication
  • Up to 2 times faster data groupping
  • Groupper is using less memory
  • Up to 2 times faster data extraction from Sql Server
  • Up to 2 times faster data extraction from ODBC sources
  • Up to 2 times faster loading data into SQL Server
  • Up to 2 times faster loading data into ODBC
  • Added record number to package export object
  • Various bugs fixes and improvements

New in Advanced ETL Processor Enterprise 5.8.0.19 (Mar 25, 2015)

  • Up to 2 times faster data extraction from Sql Server
  • Up to 2 times faster data extraction from ODBC sources
  • Up to 40 percent faster loading data into SQL Server
  • Up to 40 percent faster loading data into ODBC
  • Up to 10 percent faster QVX files creation
  • Up to 10 percent faster loading data into PostgreSQL
  • Various bugs fixes and improvements

New in Advanced ETL Processor Enterprise 5.8.0.18 (Mar 18, 2015)

  • Up to 9 times faster QVD files creation
  • Up to 3 times faster reading data from QVD files
  • Up to 2 times faster data sorting
  • Up to 15 percent faster QVX files creation
  • Added thousands separator to transformation objects
  • Various bugs fixes and improvements

New in Advanced ETL Processor Enterprise 5.8.0.17 (Mar 18, 2015)

  • Added ability to lock the objects
  • Addressed issues with processing empty excel files
  • Addressed problems with validator data preview

New in Advanced ETL Processor Enterprise 5.8.0.16 (Mar 10, 2015)

  • Addressed problems with reading googlespreasheet data
  • Addressed Transformers AV's
  • Addressed issues with stopping the agent

New in Advanced ETL Processor Enterprise 5.8.0.15 (Mar 9, 2015)

  • Up to 30 percent faster text file processing
  • Up to 10 percent faster QVD generation
  • Up to 10 percent faster QVX generation
  • Up to 5 percent faster Excel Files generation
  • Up to 20 percent faster XML generation
  • Udapded demos
  • Addressed issues with Joiner object
  • Various bug fixes and improvements

New in Advanced ETL Processor Enterprise 5.8.0.13 (Mar 5, 2015)

  • Up to 10 percent faster text file processing
  • Addressed issues with processing end of line characters inside delimited files

New in Advanced ETL Processor Enterprise 5.8.0.12 (Mar 4, 2015)

  • Up to 7 times faster data sorting
  • Addressed issues with salesforce data processing
  • Fixed problems with data preview
  • Various bug fixes and improvements

New in Advanced ETL Processor Enterprise 5.8.0.10 (Feb 28, 2015)

  • Addressed issues with creating rejected records file

New in Advanced ETL Processor Enterprise 5.8.0.9 (Feb 26, 2015)

  • Addressed issues with running ODBC Manager from application

New in Advanced ETL Processor Enterprise 5.8.0.7 (Feb 25, 2015)

  • SSL libraries update
  • Various bug fixes and improvements

New in Advanced ETL Processor Enterprise 5.8.0.6 (Feb 21, 2015)

  • Working with text files - is more than 2 times faster
  • Creating QVD files - up to 30 percent faster
  • Creating QVX files - up to 30 percent faster
  • Creating Excel files - up to 20 percent faster
  • Loading data into SQL server - up to 10 percent faster
  • Loading data into Oracle - up to 10 percent faster
  • Loading data into PostgreSQL - up to 10 percent faster
  • New version of report builder
  • Report builder documentation update
  • Various bug fixes and improvements

New in Advanced ETL Processor Enterprise 5.8.0.5 (Feb 11, 2015)

  • Support for MS SQL server 2014 was extended
  • Scheduler dialogue improvements
  • Addressed issues with sending SMS messages

New in Advanced ETL Processor Enterprise 5.8.0.4 (Feb 4, 2015)

  • Addressed issues with sequence transformation object
  • Addressed issues with subtransformation object
  • Addressed issues with sending SMS messages

New in Advanced ETL Processor Enterprise 5.8.0.3 (Feb 2, 2015)

  • Addressed issues with theme management
  • Loads recent history of changes by default now (Full history is to big and slows down the application)

New in Advanced ETL Processor Enterprise 5.8.0.2 (Jan 30, 2015)

  • Addressed issues with metadata object
  • Added Vertical Grid
  • Third party components update

New in Advanced ETL Processor Enterprise 5.8.0.1 (Jan 30, 2015)

  • SFTP rename bug fix
  • Table Editor bug fixes

New in Advanced ETL Processor Enterprise 5.8.0.0 (Jan 23, 2015)

  • Support for multiple readers
  • Joiner Renamed to Join
  • Splitter Renamed to Split
  • Joiner Object was introduced
  • Skip empty fields option was introduced to Join object
  • Incremental object search was added to package designer
  • Minor interface improvements
  • Writer and Reader description are mandatory now
  • New option to Include reader name into Rejected records file
  • Documentation update
  • Addressed issue with sending SMS messages

New in Advanced ETL Processor Enterprise 5.7.10.10 (Dec 11, 2014)

  • Addressed issues with GetExcelCelValue transformation function

New in Advanced ETL Processor Enterprise 5.7.10.9 (Dec 10, 2014)

  • Setup and executable are digitally signed now
  • Minor bugs fixes

New in Advanced ETL Processor Enterprise 5.7.10.8 (Dec 5, 2014)

  • Added Reset height option
  • Updated repository creation scripts

New in Advanced ETL Processor Enterprise 5.7.10.7 (Dec 4, 2014)

  • Up to 10 percent faster
  • Check File Action has new option: Check if file is in Use
  • License Update
  • Documentation Update

New in Advanced ETL Processor Enterprise 5.7.10.6 (Dec 3, 2014)

  • Changed the way parameters are passed into reports
  • Documentation update

New in Advanced ETL Processor Enterprise 5.7.10.5 (Dec 2, 2014)

  • Addressed issues with XML encoding

New in Advanced ETL Processor Enterprise 5.7.10.4 (Nov 28, 2014)

  • Addressed some validator issues

New in Advanced ETL Processor Enterprise 5.7.10.3 (Nov 26, 2014)

  • Added If South African company transformation function
  • Added Is South African company validation function
  • Added incremental search to application options dialogue
  • Documentation update
  • Corrected issues with Is number less than,Is number more than and Is number between transformation functions

New in Advanced ETL Processor Enterprise 5.7.10.1 (Nov 24, 2014)

  • Third party components update
  • Incremental search was added to all grids
  • Export to RTF was introduced
  • Excel export formats improvements
  • Various Interface improvements
  • Documentation update
  • Loop Package Action improvements
  • Minor bugs fixes
  • Spelling corrections

New in Advanced ETL Processor Enterprise 5.7.10.0 (Nov 18, 2014)

  • Added support for tableau tde files

New in Advanced ETL Processor Enterprise 5.7.9.44 (Nov 13, 2014)

  • Loop Package Action improvements

New in Advanced ETL Processor Enterprise 5.7.9.43 (Nov 6, 2014)

  • Transformation fails if there were problems with data writer when run from the package
  • Added option to generate table creation script to the transformer source grid
  • Log redirect object improvements
  • Added system variable
  • Various bugs fixes

New in Advanced ETL Processor Enterprise 5.7.9.42 (Nov 3, 2014)

  • Setup Update
  • Added Loop Package Action
  • Added Create list of files option to File Operation Package Action

New in Advanced ETL Processor Enterprise 5.7.9.41 (Oct 30, 2014)

  • Addressed Splitter dialogue issues

New in Advanced ETL Processor Enterprise 5.7.9.40 (Oct 29, 2014)

  • Added new transformation field values

New in Advanced ETL Processor Enterprise 5.7.9.39 (Oct 25, 2014)

  • Addressed Salesforce connection dialogue issues

New in Advanced ETL Processor Enterprise 5.7.9.38 (Oct 24, 2014)

  • Addressed SFTP bugs

New in Advanced ETL Processor Enterprise 5.7.9.37 (Oct 24, 2014)

  • Added two new fields to File Sytem datasource last modification date and last access date

New in Advanced ETL Processor Enterprise 5.7.9.36 (Oct 21, 2014)

  • Minor interface improvements

New in Advanced ETL Processor Enterprise 5.7.9.35 (Oct 21, 2014)

  • Added Hide Template Tab option
  • Better report error handling
  • Report generator bugs fixes

New in Advanced ETL Processor Enterprise 5.7.9.33 (Oct 13, 2014)

  • Report generator bugs fixes

New in Advanced ETL Processor Enterprise 5.7.9.32 (Oct 8, 2014)

  • Added Is Null or Empty string validation function
  • Added If Null or Empty string transformation function
  • Documentation Update
  • Mapping editor bug fixes

New in Advanced ETL Processor Enterprise 5.7.9.30 (Sep 24, 2014)

  • Addressed CASE transformation issues

New in Advanced ETL Processor Enterprise 5.7.9.26 (Sep 16, 2014)

  • Added Support for Message Queuing (MSMQ)
  • Documentation Update
  • Run At Agent Start Scheduler option was introduced
  • Better Data Reader Memory Management

New in Advanced ETL Processor Enterprise 5.7.9.24 (Sep 3, 2014)

  • Support for using variables inside package zip object password was introduced

New in Advanced ETL Processor Enterprise 5.7.9.23 (Sep 1, 2014)

  • Added GUID function to scripting language
  • Documentation Update

New in Advanced ETL Processor Enterprise 5.7.9.22 (Sep 1, 2014)

  • Addressed issues with BIGINT fields

New in Advanced ETL Processor Enterprise 5.7.9.21 (Sep 1, 2014)

  • Management console fixes

New in Advanced ETL Processor Enterprise 5.7.9.20 (Aug 19, 2014)

  • Addressed issues with Get Excel Cell Value transformation function
  • Addressed issues with copy paste functionality

New in Advanced ETL Processor Enterprise 5.7.9.19 (Aug 13, 2014)

  • New package Object - SMS
  • Documentation Update
  • Interface improvements
  • Further improvements to Sending SMS functionality
  • Date Format bugs fixes
  • Addressed problem with keep characters functions

New in Advanced ETL Processor Enterprise 5.7.9.18 (Aug 12, 2014)

  • Support for Sending SMS messages was introduced, following services are supported: Twilio, BulkSMS, TelAPI and Essendex.
  • PostgreSQL repository scripts corrections
  • Documentation Update

New in Advanced ETL Processor Enterprise 5.7.9.16 (Aug 5, 2014)

  • Added URL shortener transformation function
  • Added URL Location transformation function
  • Added IP Location transformation function
  • Added Accumulate Strings transformation function
  • Extended Metadata transformation function functionality
  • Documentation Update

New in Advanced ETL Processor Enterprise 5.7.9.15 (Aug 1, 2014)

  • Interface improvements
  • Addressed issues with CASE transformation function

New in Advanced ETL Processor Enterprise 5.7.9.14 (Aug 1, 2014)

  • Added CASE transformation function
  • Added Delete Leading Characters transformation function
  • Added Delete Trailing Characters transformation function
  • Added support for special characters
  • Interface improvements

New in Advanced ETL Processor Enterprise 5.7.9.13 (Jul 22, 2014)

  • Ability to move objects between different tabs was introduced
  • Subtransformation bugs fixes

New in Advanced ETL Processor Enterprise 5.7.9.12 (Jul 20, 2014)

  • Introduced support for salesforce QueryAll interface
  • Documentation Update
  • Addressed problems with batch import via ODBC

New in Advanced ETL Processor Enterprise 5.7.9.10 (Jul 17, 2014)

  • Addressed problems with refreshing logs

New in Advanced ETL Processor Enterprise 5.7.9.9 (Jul 15, 2014)

  • Excel processing engine update

New in Advanced ETL Processor Enterprise 5.7.9.8 (Jul 11, 2014)

  • Extended functionality of Get Excel Cell Value and Get File Context functions
  • Addressed issues with Undo Redo buttons
  • Addressed excel' files locking problems
  • Addressed problems with refreshing logs

New in Advanced ETL Processor Enterprise 5.7.9.6 (Jul 3, 2014)

  • Added two new transformation functions Get Excel Cell Value and Get File Context
  • Documentation Update

New in Advanced ETL Processor Enterprise 5.7.9.5 (Jun 28, 2014)

  • Support for latest version of Google spreadsheets was introduced

New in Advanced ETL Processor Enterprise 5.7.9.4 (Jun 26, 2014)

  • List of connections is sorted alphabetically now
  • Minor XML processing fixes

New in Advanced ETL Processor Enterprise 5.7.9.3 (Jun 20, 2014)

  • Up to 50 percent faster working with QVD files

New in Advanced ETL Processor Enterprise 5.7.9.2 (Jun 20, 2014)

  • Added Authentication support to HTTP package objects

New in Advanced ETL Processor Enterprise 5.7.9.1 (Jun 13, 2014)

  • Addressed memory leaks problems

New in Advanced ETL Processor Enterprise 5.7.9.0 (Jun 9, 2014)

  • Renamed Web Service Lookup to HTTP Post
  • Added HTTP Get Transformation function
  • Documentation Update

New in Advanced ETL Processor Enterprise 5.7.8.6 (Jun 6, 2014)

  • Web Service Lookup issues were addressed
  • Addressed issues with sending emails with attachments

New in Advanced ETL Processor Enterprise 5.7.8.4 (Jun 5, 2014)

  • Addressed issues of loading data from the files with old creation date
  • Addressed DD-MMM-YYYY date format issues
  • Smaller Setup

New in Advanced ETL Processor Enterprise 5.7.8.3 (May 16, 2014)

  • Fixed problem with log deletion

New in Advanced ETL Processor Enterprise 5.7.8.2 (May 15, 2014)

  • XML and ODBC fixes

New in Advanced ETL Processor Enterprise 5.7.8.1 (May 14, 2014)

  • Execution stability fixes
  • Date Diff function fixes

New in Advanced ETL Processor Enterprise 5.7.8.0 (May 14, 2014)

  • Repository structure was changed
  • Two new tables were added QUEUE_HISTORY and QUEUE_ACTIONS_HISTORY
  • Once package execution is completed records from QUEUE and QUEUE_ACTIONS are moved into those two tables
  • These modifications improve overall application stability

New in Advanced ETL Processor Enterprise 5.7.7.23 (May 14, 2014)

  • Addressed file update problems

New in Advanced ETL Processor Enterprise 5.7.7.22 (Apr 24, 2014)

  • Added separate application to edit options

New in Advanced ETL Processor Enterprise 5.7.7.20 (Apr 18, 2014)

  • Added option clear sheet to Excel writer
  • Added support for dynamic file names in attachments

New in Advanced ETL Processor Enterprise 5.7.7.18 (Apr 18, 2014)

  • Up to 5 percent performance increase
  • MySQL date processing bugs fixes

New in Advanced ETL Processor Enterprise 5.7.7.16 (Mar 17, 2014)

  • Addressed some copy/paste issues
  • MySQL date processing bugs fixes

New in Advanced ETL Processor Enterprise 5.7.7.14 (Mar 17, 2014)

  • Addressed union object issues

New in Advanced ETL Processor Enterprise 5.7.7.12 (Mar 17, 2014)

  • Addressed some subtransformation issues

New in Advanced ETL Processor Enterprise 5.7.7.10 (Mar 5, 2014)

  • Added library of objects
  • Fixed bugs with Copy/Paste of Sub transformation function

New in Advanced ETL Processor Enterprise 5.7.7.9 (Feb 17, 2014)

  • Addressed issues of loading data from Excel files

New in Advanced ETL Processor Enterprise 5.7.7.8 (Feb 7, 2014)

  • Added snap to grid option
  • Added Data Port option to FTP Connection

New in Advanced ETL Processor Enterprise 5.7.7.5 (Feb 6, 2014)

  • Added RichText object to the Report Designer
  • Added option to set defaults
  • Added option to filter target fields
  • Addressed some sqlite issues

New in Advanced ETL Processor Enterprise 5.7.7.3 (Jan 24, 2014)

  • Addressed issues with sending emails

New in Advanced ETL Processor Enterprise 5.7.7.2 (Jan 22, 2014)

  • Added following variables
  • Documentation Update
  • Extended functionality of send email action
  • Addressed issues with day of the week checking
  • Addressed issues with loading data into MySQL

New in Advanced ETL Processor Enterprise 5.7.7.0 (Jan 20, 2014)

  • Addressed some FTP Package dialogue issues

New in Advanced ETL Processor Enterprise 5.7.6.30 (Jan 10, 2014)

  • Updated regular expression for US SSN

New in Advanced ETL Processor Enterprise 5.7.6.28 (Jan 3, 2014)

  • Addressed issues of loading data from flat files

New in Advanced ETL Processor Enterprise 5.7.6.27 (Jan 3, 2014)

  • Addressed issues with long object names

New in Advanced ETL Processor Enterprise 5.7.6.26 (Dec 27, 2013)

  • HTTP Form package object was introduced
  • Documentation update
  • ,, sistem variables we added

New in Advanced ETL Processor Enterprise 5.7.6.25 (Dec 27, 2013)

  • Corrected issues with FTP automation

New in Advanced ETL Processor Enterprise 5.7.6.24 (Dec 21, 2013)

  • Documentation update
  • OleDB support for repository connections

New in Advanced ETL Processor Enterprise 5.7.6.22 (Dec 17, 2013)

  • Addressed issues with loading empty Date fields into MS SQL server

New in Advanced ETL Processor Enterprise 5.7.6.21 (Dec 14, 2013)

  • Support for Zoom in/Out was introduced
  • Target Data tab was introduced to the transformation editor
  • Better printing support
  • Execution Agent was optimized to run less SQL against repository
  • Email processing bug fixes

New in Advanced ETL Processor Enterprise 5.7.6.19 (Dec 9, 2013)

  • Corrected issues with processing emails send by IPAD
  • Addressed issues of loading data from flat files

New in Advanced ETL Processor Enterprise 5.7.6.16 (Dec 5, 2013)

  • Addressed issues of loading data from flat files

New in Advanced ETL Processor Enterprise 5.7.6.15 (Nov 28, 2013)

  • Added send as HTML option
  • Addressed issues of loading data from flat files
  • Fixed bugs related to loading data in to VARCHAR(MAX) fields.

New in Advanced ETL Processor Enterprise 5.7.6.13 (Nov 25, 2013)

  • Better objects positioning while working with multiple tabs
  • Emails are send as HTML now
  • Addressed issues with updating data

New in Advanced ETL Processor Enterprise 5.7.6.12 (Nov 20, 2013)

  • Better handling of large Salesforce tables
  • Support for multiple Salesforce environments was introduced

New in Advanced ETL Processor Enterprise 5.7.6.8 (Nov 15, 2013)

  • Deduplicator AV fix
  • QVD reading bug fixes

New in Advanced ETL Processor Enterprise 5.7.6.7 (Nov 11, 2013)

  • Incremental Object search works with comments and connections now
  • Better handling of empty Salesforce tables
  • More detailed information about Salesforce fields by data reader
  • Support for GreenPlum was introduced

New in Advanced ETL Processor Enterprise 5.7.6.6 (Nov 11, 2013)

  • Added ability to hide tabs on main screen
  • Added tabs to transformation editor
  • Added select count(*) from table menu item to sql browser
  • Added Space Horizontally and Space Vertically buttons
  • Search dialogue edit box value is stored in registry now
  • Addressed issues with date fields processing
  • Addressed issues of loading data from delimited files

New in Advanced ETL Processor Enterprise 5.7.6.4 (Nov 11, 2013)

  • Added option to resize objects selector
  • Addressed some issues of working with default values

New in Advanced ETL Processor Enterprise 5.7.6.3 (Nov 11, 2013)

  • Added search functionality to transformation editor
  • Added search functionality to package editor
  • Salesforce bug's fixes

New in Advanced ETL Processor Enterprise 5.7.6.1 (Nov 11, 2013)

  • Better source connection errors handling

New in Advanced ETL Processor Enterprise 5.7.6.0 (Nov 11, 2013)

  • Salesforce is supported as datatarget
  • Addressed more autoformat problems

New in Advanced ETL Processor Enterprise 5.7.5.9 (Oct 17, 2013)

  • Addressed issues with Salesforce processing

New in Advanced ETL Processor Enterprise 5.7.5.8 (Oct 17, 2013)

  • Addressed issues with HL7 processing
  • Addressed issues with loading data from Salesforce
  • Addressed issues with loading data into NTEXT fields
  • Addressed issues with loading data into MySQL
  • Addressed issues with locking PostgreSQL tables

New in Advanced ETL Processor Enterprise 5.7.5.6 (Oct 10, 2013)

  • Sales force connection support latest API now
  • Support for MariaDB was introduced
  • Documentation Update
  • Addressed problems with package editor
  • Addressed problems with loading date fields
  • Addressed problem with handling NULLs
  • Fixed AV when loading data into MySQL

New in Advanced ETL Processor Enterprise 5.7.5.5 (Oct 8, 2013)

  • Addressed problem with ping object

New in Advanced ETL Processor Enterprise 5.7.5.4 (Oct 8, 2013)

  • Minor Interface improvements
  • Addressed problems with excel date formatting

New in Advanced ETL Processor Enterprise 5.7.5.3 (Oct 7, 2013)

  • New datasource HTTP
  • Documentation update
  • Addressed issues with salesforce connection
  • Addressed problems with fixed width files

New in Advanced ETL Processor Enterprise 5.7.5.2 (Oct 3, 2013)

  • - Addressed problems with formatting dates

New in Advanced ETL Processor Enterprise 5.7.5.1 (Oct 3, 2013)

  • Addressed problems with autoformat option
  • Addressed problems with package variables
  • Corrected problem with FTP progress bar

New in Advanced ETL Processor Enterprise 5.7.5.0 (Sep 28, 2013)

  • Addressed problems with Datediff function

New in Advanced ETL Processor Enterprise 5.7.4.9 (Sep 19, 2013)

  • Another 10 percent performance increase
  • Addressed problems with scientific numbers in Excel
  • Fixed bug with too many rejected records
  • Smaller executable
  • Addressed problem with non ASCI characters in scripts/transformations/mappings etc

New in Advanced ETL Processor Enterprise 5.7.4.6 (Sep 11, 2013)

  • Up to 20 percent performance increase

New in Advanced ETL Processor Enterprise 5.7.4.3 (Sep 5, 2013)

  • Up to 70 percent performance increase

New in Advanced ETL Processor Enterprise 5.7.4.2 (Sep 2, 2013)

  • Further 20 percent performance increase for loading data from text files

New in Advanced ETL Processor Enterprise 5.7.4.1 (Sep 2, 2013)

  • Global Variables (very useful for switching from development to production)
  • Up to 50 percent increase for loading data via OleDB
  • Up to 40 percent increase when using stored procedures for loading the data
  • Further 10 percent performance increase for loading data from text files
  • Documentation update
  • Various bug fixes and interface improvements

New in Advanced ETL Processor Enterprise 5.7.4.0 (Aug 27, 2013)

  • Massive performance boost:
  • Text to INTERBASE TABLE up to 25.50%
  • Text to MS SQL TABLE via BCP up to 32.64%
  • Text to MS SQL TABLE via OLE DB 2000 CLIENT up to 50.00%
  • Text to MS SQL TABLE via OLE DB 2005 CLIENT up to 50.00%
  • Text to MS SQL TABLE via OLE DB 2008 CLIENT up to 50.00%
  • Text to MS SQL TABLE via OLE DB 2012 CLIENT up to 50.00%
  • Text to MY SQL TABLE up to 20.61%
  • Text to ORACLE TABLE via Conventional Path Loading up to 24.40%
  • Text to ORACLE TABLE via Direct Path Loading up to 30.45%
  • Text to ORACLE TABLE via OLE DB up to 19.52%
  • Text to ORACLE TABLE via OLE DB using ODBC up to 30.00%
  • Text to POSTGRESQL TABLE up to 29.15%
  • Better handling of Target Schema Changes
  • It is now possible to use a package variable in web service url
  • It is now possible to use a package variable in defaults
  • Notes have pop up menu now
  • Toolbox in Packages is movable and sizeable
  • SQL Statements: Leading comments -- or /**/ cause SQL to error - corrected
  • Transforms Field List: Ctrl-X, C, V, Do not work (but right click does) - corrected
  • Transforms File Names: Ctrl-X, C, V, Do not work (but right click does) - corrected
  • Transforms Data List: Can not Ctrl-C or Right Click Copy - corrected
  • Log Viewer: Can not Ctrl-C or Right Click Copy - corrected
  • Clarify day label on File Operations - corrected

New in Advanced ETL Processor Enterprise 5.7.3.1 (Jul 31, 2013)

  • Addressed some lookup issues

New in Advanced ETL Processor Enterprise 5.7.2.7 (Jul 22, 2013)

  • Massive performance boost:
  • text to text up to 100 percent
  • odbc to text up to 20 percent
  • text to PostgreSQL up to 25 percent
  • text to Oracle up to 25 percent
  • text to Oledb up to 25 percent
  • text to MYSQL up to 10 percent
  • text to MS SQL server up to 25 percent
  • QVD to text up to 100 percent
  • Multiple files decompression was introduced
  • File Rename with mask was introduced
  • Save changes warnings were added to transformer and validator
  • Copy functionality was added to source and target definitions
  • Bug with deleting writers was fixed
  • Pivot bugs were fixed
  • Undo/Redo bugs were fixes
  • New object creation bugs were fixed

New in Advanced ETL Processor Enterprise 5.7.2.4 (Jun 27, 2013)

  • QVD generation bugs fixes

New in Advanced ETL Processor Enterprise 5.7.2.3 (Jun 14, 2013)

  • Option to schedule execution on the last/first day of the month was introduced
  • "Is Value in Database" and "If Value in Database" were added
  • Documentation update

New in Advanced ETL Processor Enterprise 5.7.2.2 (Jun 10, 2013)

  • Support for the web services was introduced (SOAP)
  • Various bug fixes and interface improvements

New in Advanced ETL Processor Enterprise 5.7.2.1 (Jun 10, 2013)

  • Connection mapping dialogue was added to repository synchronization wizard
  • Data reader timeout was introduced for ODBC, Access, MS Sql Server, OleDB, PostgreSQL, MySQ: and MS Sql Server CE connections
  • Various bug fixes and interface improvements

New in Advanced ETL Processor Enterprise 5.7.2.0 (May 29, 2013)

  • Smaller executable
  • Memory usage was reduced for Excel files
  • Adressed some HL7 issues
  • Various bug fixes and interface improvements

New in Advanced ETL Processor Enterprise 5.7.1.4 (May 11, 2013)

  • Format field name dialogue improvements
  • Datareader minor improvements
  • Addressed Repository Synchronization wizard bugs

New in Advanced ETL Processor Enterprise 5.7.1.3 (May 8, 2013)

  • Various bug fixes

New in Advanced ETL Processor Enterprise 5.7.1.0 (Apr 26, 2013)

  • Introduced Repository Synchronization wizard

New in Advanced ETL Processor Enterprise 5.7.0.10 (Apr 22, 2013)

  • Introduced Repository Synchronization wizard
  • Addressed problems with updating Oracle blob fields

New in Advanced ETL Processor Enterprise 5.7.0.8 (Apr 15, 2013)

  • Addressed some groupper issues

New in Advanced ETL Processor Enterprise 5.7.0.7 (Apr 8, 2013)

  • HL7 Examples were added
  • Undo/Redo Functionality was improoved
  • Documentation update

New in Advanced ETL Processor Enterprise 5.7.0.5 (Apr 5, 2013)

  • Compare values function was added
  • Various bug fixes
  • Documentation update

New in Advanced ETL Processor Enterprise 5.7.0.1 (Mar 27, 2013)

  • IF Functions were introduced
  • Total number of functions now 500+
  • Comments were added to Literal function
  • Various bug fixes and interface improvements
  • Documentation update
  • Addressed some regular expressions bugs

New in Advanced ETL Processor Enterprise 5.6.3.10 (Mar 13, 2013)

  • Added parameter names to calculation object
  • Address ping object issues

New in Advanced ETL Processor Enterprise 5.6.3.9 (Mar 11, 2013)

  • Added Undo an Redo functionality to the transformation designer

New in Advanced ETL Processor Enterprise 5.6.3.8 (Mar 10, 2013)

  • Added support to Redo and Undo to package designer
  • Added Register option to help menu
  • Various bug fixes and interface improvements

New in Advanced ETL Processor Enterprise 5.6.3.6 (Mar 10, 2013)

  • Added snap to grid to functionality
  • Various bug fixes and interface improvements

New in Advanced ETL Processor Enterprise 5.6.3.4 (Mar 10, 2013)

  • Added align left, align top, align right, and align bottom buttons
  • Dedupicator, Lookup and InLinst functions are up to 20 percent faster
  • Ability to link output fields was introduced
  • Hints were added to Lookup object
  • Better object selection for packages and mapings
  • Various bug fixes and interface improvements
  • Support for HL7 messaging was introduced

New in Advanced ETL Processor Enterprise 5.6.2.11 (Mar 2, 2013)

  • Support for PGP was introduced
  • Interface improvements
  • Various bug fixes

New in Advanced ETL Processor Enterprise 5.6.2.10 (Feb 22, 2013)

  • Added Keep Characters Function
  • Added Epoch to Date Function
  • Added Date to Epoch Function
  • Interface improvements
  • Documentation update
  • Various bug fixes

New in Advanced ETL Processor Enterprise 5.6.2.9 (Feb 15, 2013)

  • Added Keep Characters Function
  • Added Epoch to Date Function
  • Added Date to Epoch Function
  • Interface improvements
  • Documentation update
  • Various bug fixes

New in Advanced ETL Processor Enterprise 5.6.2.3 (Jan 29, 2013)

  • Improved support for MS SQL Server 2012
  • Improved support for BDE
  • Logging improvements for Connection type, connection name and connection details
  • Agent bug fixes
  • Various bug fixes

New in Advanced ETL Processor Enterprise 5.6.2.2 (Jan 21, 2013)

  • New function was introduced ExecuteObject(ObjectId)
  • Documentation update
  • Various bug fixes

New in Advanced ETL Processor Enterprise 5.6.2.0 (Jan 11, 2013)

  • Support for BDE and Paradox was introduced
  • Various bug fixes

New in Advanced ETL Processor Enterprise 5.6.1.4 (Dec 31, 2012)

  • Added copy paste functionality to IMAP connections
  • OLE Reports Dialogue is resizable now
  • Various bug fixes

New in Advanced ETL Processor Enterprise 5.5.2.3 (Oct 30, 2012)

  • Added option to ignore XML tags between Table tag and Record tag
  • Documentaiton Update
  • Fixed set variables bugs

New in Advanced ETL Processor Enterprise 5.5.2.2 (Oct 9, 2012)

  • Various bug fixes

New in Advanced ETL Processor Enterprise 5.5.1.2 (Sep 24, 2012)

  • Repository Scripts fix

New in Advanced ETL Processor Enterprise 5.5.1.0 (Sep 14, 2012)

  • Added new object Log which can be used to analyse data quality issues
  • Reader Parameter Object was renamed to Metadata object
  • Ability to extract package name, os user name, computer name, transformation name and Application name was introduced
  • Documentation Update
  • Various bug fixes

New in Advanced ETL Processor Enterprise 5.5.0.0 (Sep 1, 2012)

  • Support for QVD files was introduced
  • Various bug fixes

New in Advanced ETL Processor Enterprise 5.4.3.2 (Aug 13, 2012)

  • New Version control tab was introduced
  • Version control can submit several objects now
  • Version control dialog can delete multiple objects now
  • Various bug fixes

New in Advanced ETL Processor Enterprise 5.4.3.0 (Jul 23, 2012)

  • New package object was introduced = Case
  • Various bug fixes

New in Advanced ETL Processor Enterprise 5.4.2.3 (Jul 18, 2012)

  • Various bug fixes

New in Advanced ETL Processor Enterprise 5.4.2.0 (Jul 5, 2012)

  • Massive performance improvement up to 10+ times for some data sources/targets
  • Various bug fixes

New in Advanced ETL Processor Enterprise 5.4.0.2 (Jul 2, 2012)

  • Support for BrightPearl was introduced
  • Support for IMAP4 was introduced
  • Support for Sales Force was introduced
  • Support for JDBC was introduced
  • Support for IP Sockets was introduced
  • Additional filters for file/zip and check file operations
  • Documentation update
  • Various bug fixes

New in Advanced ETL Processor Enterprise 5.4.0.0 (Jun 26, 2012)

  • Support for BrightPearl was introduced
  • Support for IMAP4 was introduced
  • Support for Sales Force was introduced
  • Support for JDBC was introduced
  • Support for IP Sockets was introduced
  • Additional filters for file/zip and check file operations
  • Documentation update
  • Various bug fixes

New in Advanced ETL Processor Enterprise 5.3.1.4 (Jun 7, 2012)

  • Corrected some problems related to dynamic file names

New in Advanced ETL Processor Enterprise 5.3.1.3 (Jun 6, 2012)

  • Corrected some problems related to dynamic file names

New in Advanced ETL Processor Enterprise 5.3.1.2 (Jun 6, 2012)

  • Support Excel named ranges was introduced
  • Various bug fixes

New in Advanced ETL Processor Enterprise 5.3.1.1 (May 29, 2012)

  • Support Excel named ranges was introduced
  • Various bug fixes

New in Advanced ETL Processor Enterprise 5.3.0.9 (May 25, 2012)

  • Support for adding data to existing excel files was introduced
  • System variables update
  • Various bug fixes

New in Advanced ETL Processor Enterprise 5.3.0.3 (May 16, 2012)

  • Support for excel formating was introduced

New in Advanced ETL Processor Enterprise 5.3.0.2 (May 16, 2012)

  • Uses 10 times less memory for large excel files
  • Support for loading data from RSS, Google spread sheets and windows event logs was introduced
  • Dynamic Excel sheet names
  • Documentation update

New in Advanced ETL Processor Enterprise 5.2.0.3 (Mar 27, 2012)

  • 10x performance increase for generating QVX files

New in Advanced ETL Processor Enterprise 5.2.0.1 (Mar 22, 2012)

  • New arithmetical functions were added Add,Subtract,Divide,Multiply,Max and Min
  • Addressed some SMTP problems

New in Advanced ETL Processor Enterprise 5.2.0.0 (Mar 22, 2012)

  • Union ALL transformation object was created
  • Documentation update
  • Various bug fixes

New in Advanced ETL Processor Enterprise 5.1.1.0 (Mar 10, 2012)

  • Support for Dynamic SQL for ETL transformations was introduced

New in Advanced ETL Processor Enterprise 5.1.0.4 (Mar 10, 2012)

  • Addressed some issues related to working with integrated scheduler

New in Advanced ETL Processor Enterprise 5.0.1.3 (Jan 23, 2012)

  • Timeout was added to sql scripts
  • Documentation update
  • First Record flag, Last Record flag, First Record flag for file/table/sheet, Last Record for file/table/sheet were added to Reader parameter data trasformation function
  • Sequence and Running total trasformation function improvements
  • Various bug fixes

New in Advanced ETL Processor Enterprise 5.0.1.1 (Jan 19, 2012)

  • Corrected some issues related to agent registration

New in Advanced ETL Processor Enterprise 5.0.1.0 (Jan 14, 2012)

  • Support for decompression of following file formats was introduced:
  • Zip archive *.zip;*.jar;*.ear;*.war;*.cbz;*.apk;*.wsz;*.wal;*.xpi;*.crx;*.dfsz;*.pcv;*.bsz;*.mskin;*.wmz;*.ipa;*.docx;*.xlsx;*.pptx;*.sxw;*.sxi;*.sxt;*.sxd;*.sxc;*.sxm;*.sxg;*.stw;*.sti;*.std;*.stc;*.odh;*.odd;*.odt;*.odm;*.ods;*.ots;*.odg;*.otg;*.odp;*.otp;*.odf;*.odb
  • BZip2 archive *.bz2;*.bzip2;*.tbz2;*.tbz
  • Rar archive *.rar;*.r00;*.cbr
  • Arj archive *.arj
  • Z archive *.z;*.taz
  • Lzh archive *.lzh;*.lha
  • 7z archive *.7z
  • Cab archive *.cab;*.fwp
  • Nsis archive *.nsis
  • Lzma archive *.lzma
  • Lzma86 archive *.lzma86
  • Pe archive *.exe;*.dll;*.sys;*.bpl
  • Elf archive *.
  • Mach-O archive *.
  • Udf archive *.iso;*.img
  • Xar archive *.xar;*.safariextz
  • Mub archive *.
  • Hfs archive *.hfs
  • Dmg archive *.dmg
  • Compound archive *.msi;*.msp;*.doc;*.xls;*.ppt
  • Wim archive *.wim;*.swm
  • Iso archive *.iso;*.img
  • Chm archive *.chm;*.chi;*.chq;*.chw;*.hxs;*.hxi;*.hxr;*.hxq;*.hxw;*.lit
  • Split archive *.001
  • Rpm archive *.rpm
  • Deb archive *.deb
  • Cpio archive *.cpio
  • Tar archive *.tar
  • GZip archive *.gz;*.gzip;*.tgz;*.tpz
  • Ntfs archive *.ntfs;*.img
  • Fat archive *.fat;*.img
  • Mbr archive *.mbr
  • Vhd archive *.vhd
  • MsLZ archive *.
  • Flv archive *.flv
  • Swf archive *.swf
  • Swf archive *.swf
  • APM archive *.
  • PPMD archive *.pmd
  • Terse Executable *.te
  • UEFIc archive *.scap
  • UEFIs archive *.
  • SquashFS archive *.squashfs
  • CramFS archive *.cramfs
  • Support for compression of following file formats was introduced:
  • Zip archive *.zip;*.jar;*.ear;*.war;*.cbz;*.apk;*.wsz;*.wal;*.xpi;*.crx;*.dfsz;*.pcv;*.bsz;*.mskin;*.wmz;*.ipa;*.docx;*.xlsx;*.pptx;*.sxw;*.sxi;*.sxt;*.sxd;*.sxc;*.sxm;*.sxg;*.stw;*.sti;*.std;*.stc;*.odh;*.odd;*.odt;*.odm;*.ods;*.ots;*.odg;*.otg;*.odp;*.otp;*.odf;*.odb
  • BZip2 archive *.bz2;*.bzip2;*.tbz2;*.tbz
  • 7z archive *.7z
  • Tar archive *.tar
  • GZip archive *.gz;*.gzip;*.tgz;*.tpz
  • Swf archive *.swf
  • ZIP dialog can decompress and compress files now
  • Order of fields was charged in connection dialog: user selects server name, enters the user name and password and finally user selects the database.
  • Even smaller executable now
  • SMTP testing was fixed for SSL connection
  • Export Dialog alignment problem was corrected
  • Main windows alignment problem was corrected
  • Position saving problem was addressed for validator/transformer/package editor
  • Corrected some repository creation scripts

New in Advanced ETL Processor Enterprise 5.0.0.10 (Dec 30, 2011)

  • New repository structure compatible with Database browser
  • Visual Importer ETL Processor and Active Table Editor
  • After and Before transformation functions
  • Package Debugging
  • Parallel execution
  • Highly optimised code
  • Execution agent is now only 5 mb (compare this to some java etl tools)
  • Schedule for execution Packages, Transformations and SQL scripts
  • Run Packages, Transformations and SQL scripts from command line
  • Application Notes
  • Notes for Directories and Connections
  • Connection testing for FTP,SMTP and POP3
  • CRC16,CRC24,CRC32,Adler32,CRC64,eDonkey,eMule,MD4,MD5,RIPEMD160,SHA1,SHA224,SHA256,SHA384,SHA512,Whirlpool checksums
  • Run Packages, Transformations and SQL scripts from command line
  • Edit lookup data
  • Simplified Repository management
  • Execution log has Execution time percentage
  • Schedule package execution directly from the package designer
  • Same for sql scripts and data transformations
  • Schedule for execution on specific computer
  • Schedule for execution using agent only as option
  • Easy agent management
  • Simplified Repository management
  • Agent status logging and current agent tasks grid
  • Documentation update
  • Support for themes
  • Various bugs fixes and improvements

New in Advanced ETL Processor Enterprise 4.2.7.3 (Dec 8, 2011)

  • Addressed some scheduler issues

New in Advanced ETL Processor Enterprise 4.2.7.1 (Oct 20, 2011)

  • Package debugger was introduced
  • Breakpoints were introduced
  • Execute single package object option was introduced
  • Project Tree View - COLLAPS/EXPAND buttons were added
  • More generic log viewer
  • Ability to group packages, sql scrits reports and emails was addedd
  • Package objects have objects tree for the selection now
  • Execution agent writes startup error messages in the log file
  • Disaprearing tree nodes problem was addressed
  • "Progam" file was created on drive c
  • Double attachments
  • XML XSLT tranformation fix
  • Some auto format issues were addressed
  • Minor interface tweaks
  • Addressed issues related to running execution agent on win64

New in Advanced ETL Processor Enterprise 4.2.7.0 (Oct 10, 2011)

  • Null function
  • Interface Improvements
  • Standard print preview
  • Support for scrolling in Package editor and transformation editor
  • Option "Full tree expand" when unticked objects tree shows list of projects
  • Better error handling for ADO and MS Sql scripts
  • Command line parameter transformation function save problems

New in Advanced ETL Processor Enterprise 4.2.6.19 (Sep 26, 2011)

  • Support for MySQL 5.5 was introduced
  • Boolean fix for MySql
  • Better error hadling for ADO and MS Sql scripts
  • Insert and delete colums for excel and and text data source and targets
  • Interface Improvements
  • Better NULL's handling
  • Command line parameter transformation function was introduced

New in Advanced ETL Processor Enterprise 4.2.6.13 (Sep 12, 2011)

  • Format field names dialog box was introduced
  • Quote all menu item was added
  • Fixed problem with compressing files
  • Various bug fixes

New in Advanced ETL Processor Enterprise 4.2.6.10 (Sep 6, 2011)

  • Added Support for XSLT transformations
  • Added Get Variable, XML XSLT transformation, Validate XML function
  • Interface Update
  • Various bug fixes
  • Documentation Update
  • Support for dynamic file names was improved

New in Advanced ETL Processor Enterprise 4.2.6.9 (Aug 10, 2011)

  • Ping Server and Check Database connection was introduced
  • Added File name and Directory name extraction transformation functions
  • Data splitter modifications
  • Various bug fixes

New in Advanced ETL Processor Enterprise 4.2.6.8 (Aug 3, 2011)

  • Added Fields Selector transformation function
  • Various bug fixes

New in Advanced ETL Processor Enterprise 4.2.6.5 (Jul 26, 2011)

  • Improved support for spaces in table names and sql reserved words
  • Added clear log check box to transformation progress dialog
  • Added open open execution log button
  • Added Clone Row, Base64 Encode, Base64 Decode, GUID, Random transformation functions
  • Various bug fixes

New in Advanced ETL Processor Enterprise 4.2.6.4 (Jul 15, 2011)

  • Sorter object allows to define directory to store data in and buffer size
  • New transformation functions
  • Decode HTTPDecode
  • Encode HTTP
  • Encode HTML
  • Decode HTML
  • Unix Path To Dos Path
  • Dos Path To Unix Path

New in Advanced ETL Processor Enterprise 4.2.6.3 (Jul 11, 2011)

  • Range lookup transformation function was introduced
  • When data is exported into excel file numeric values are stored as numbers
  • Various bug fixes

New in Advanced ETL Processor Enterprise 4.2.6.2 (Jul 7, 2011)

  • Added "Search in subdirectories" option to data reader

New in Advanced ETL Processor Enterprise 4.2.6.1 (Jun 29, 2011)

  • This release changes the way the Data Validator works
  • It allows the user to validate and transform the data at the same time.
  • To update:
  • 1. Open Data Validator and map validation rules to output fields.
  • 2. Save Data transformation.
  • 3. Repeat for all transformations

New in Advanced ETL Processor Enterprise 4.2.5.3 (Jun 4, 2011)

  • Incremental Transformation function search was introduced

New in Advanced ETL Processor Enterprise 4.2.5.0 (May 13, 2011)

  • Lookup Improvements and Fixes
  • Data preview improvements
  • Clear log shows dialog box first
  • Transformer and Validator have names now
  • Direct Latest Version downloads from application
  • Various Bug Fixes

New in Advanced ETL Processor Enterprise 4.2.4.17 (May 4, 2011)

  • Various bug fixes
  • Uses MS XML now

New in Advanced ETL Processor Enterprise 4.2.4.15 (Apr 15, 2011)

  • LeftPad(S,Length,Char):String, Pads Left part of the string with Character Char
  • RightDelete(S,Length):String, Deletes Right part of the string
  • RegularExpression(S,Expression):Boolean, Returns true if string matches expression
  • EncodeXMLElement(S,ElementName):String, Returns XML Element ElementName="S"
  • DecodeXMLElement(S,ElementName):String, Returns XML Element Value
  • EncodeXMLAttribute(S,AttributeName):String, Returns XML Attribute
  • DecodeXMLAttribute(S,AttributeName):String, Returns XML Attribute Value
  • EncodeXMLString(S):String,Returns XML String
  • DecodeXMLString(S):String,Returns XML Element Value
  • Two new data transformation fuctions:
  • ReplaceSuffix
  • ReplacePrefix

New in Advanced ETL Processor Enterprise 4.2.4.14 (Apr 14, 2011)

  • Data transformation language extension
  • Added:
  • DeleteCharacters(S,CharactersToDelete) Deletes specific characters from the string
  • Delete(S,Start,End) Deletes part of string S
  • EnsureNoPrefix(S,Prefix) Removes prefix from the string when present
  • EnsureNoSuffix(S,Suffix) Removes Suffix to the string when present
  • EnsurePrefix(S,Prefix) Adds prefix to the string when not present
  • EnsureSuffix(S,Suffix) Adds prefix to the string when not present
  • EscapeString(S) C style sring escape
  • UnEscapeString(S) C style sring unescape
  • LeftDelete(S,Length)Deletes Left part of the string

New in Advanced ETL Processor Enterprise 4.2.4.13 (Apr 11, 2011)

  • Added CopyFile function
  • Various bug fixes

New in Advanced ETL Processor Enterprise 4.2.4.11 (Apr 1, 2011)

  • Command line support for errorlevel was introduced
  • Zip library update and fixes
  • Added post changes button to table browser
  • Added Optimize Column Width button
  • Fixed number of problems related to working with data groupper

New in Advanced ETL Processor Enterprise 4.2.4.10 (Mar 21, 2011)

  • added post chages button
  • added Optimize Column Width button
  • fixed number of problems related to working data groupper
  • added more demos to repository

New in Advanced ETL Processor Enterprise 4.2.4.8 (Mar 5, 2011)

  • Addressed sftp host key not verified problem
  • fixed number of problems related to working with uniqueidentifierfileds in sql server

New in Advanced ETL Processor Enterprise 4.2.4.7 (Mar 2, 2011)

  • Fixed move bugs
  • Addressed number of problems related to working with uniqueidentifierfileds in sql server
  • Fixed bug loading zero length files

New in Advanced ETL Processor Enterprise 4.2.4.6 (Feb 28, 2011)

  • Fixed move bugs

New in Advanced ETL Processor Enterprise 4.2.4.5 (Feb 25, 2011)

  • Addressed number of problems related to working with uniqueidentifierfileds in sql server
  • Fixed bug loading zero length files

New in Advanced ETL Processor Enterprise 4.2.4.4 (Feb 25, 2011)

  • FTP Log is more compact now
  • More useful error messages for copy and move file operations

New in Advanced ETL Processor Enterprise 4.2.4.3 (Feb 15, 2011)

  • Fixed some data sorting bugs

New in Advanced ETL Processor Enterprise 4.2.4.2 (Feb 9, 2011)

  • New Reader parameter: Source File Creation Date
  • SFTP bug fixes
  • Repository sripts update

New in Advanced ETL Processor Enterprise 4.2.4.1 (Feb 4, 2011)

  • Minor bug fixes

New in Advanced ETL Processor Enterprise 4.2.4.0 (Jan 24, 2011)

  • Support for Sql Server Compact Edition was introduced
  • Various bug fixes

New in Advanced ETL Processor Enterprise 4.2.3.9 (Jan 20, 2011)

  • Support for Cross tab reports was introduced
  • Report Export format was extended

New in Advanced ETL Processor Enterprise 4.2.3.7 (Jan 14, 2011)

  • Support for Cross tab reports was introduced
  • Report Export format was extended

New in Advanced ETL Processor Enterprise 4.2.3.6 (Jan 9, 2011)

  • Fixed Issues with SQLite imports
  • Support for zip files > 4 gigs was introduced
  • Some issues related to SMTP and POP3 connections were resolved
  • Support for Charts, Bar codes and OLE objects was added to reports

New in Advanced ETL Processor Enterprise 4.2.3.0 (Dec 13, 2010)

  • Support for SFTP was introduced
  • Export of empty tables was fixed
  • Various problems related to working with very large files were resolved
  • Copy and Move file operations can also rename multiple files
  • Put into target directory:
  • {ChangeFileExt('','.old')}
  • C:\{ExtractFileName(ChangeFileExt('','.old'))}
  • Calculation was not showing result correctly in preview mode

New in Advanced ETL Processor Enterprise 4.2.2.10 (Nov 30, 2010)

  • Copy project option was added
  • Various bugs fixes

New in Advanced ETL Processor Enterprise 4.2.2.6 (Nov 24, 2010)

  • Various bugs fixes

New in Advanced ETL Processor Enterprise 4.2.2.5 (Nov 20, 2010)

  • Major update:
  • Calculations and scripting language changes
  • Syntax is slightly different now
  • source fields are aways strings
  • a) no need to use "[F1]"
  • b) [F1]+[F2] will concatenate two fields
  • if you want to add them use conversion functions
  • StrtoFloat([F1])+StrtoFloat([F2])
  • use single quotes instead of double quotes
  • eg GetSystemVariable('SYSTEM_DATE') GetSystemVariable("SYSTEM_DATE")
  • Lots of new fuctions, procedures and language changes (see documentation)
  • Date time fields support
  • Default Format was changed to YYYY-MM-DD HH:NN:SS.ZZZ for ODBC and SQL server connections
  • They also support fractions of seconds now
  • Problem with null dates was resolved

New in Advanced ETL Processor Enterprise 4.2.2.4 (Nov 18, 2010)

  • MD5 transfornation function was added
  • Scripting language was extended
  • Various Excel related bug fixes
  • Documentation update

New in Advanced ETL Processor Enterprise 4.2.2.3 (Nov 15, 2010)

  • Works correctly with mixed case objects in PostgreSQL
  • Scripting language was extended
  • Various bug fixes
  • FTP bug fixes
  • Documentation update

New in Advanced ETL Processor Enterprise 4.2.2.2 (Oct 26, 2010)

  • Data grid grouping access violations fixes
  • Send email to support fixed

New in Advanced ETL Processor Enterprise 4.2.2.1 (Oct 22, 2010)

  • Loads Data from XML files
  • Exports data into XML
  • Works correctly with multiple PosgreSQL schemes
  • Support for PosgreSQL 9 was introduced
  • Support for German Locale was introduced
  • Select all and copy from data grids
  • Documentation Update

New in Advanced ETL Processor Enterprise 4.2.1.1 (Sep 20, 2010)

  • Supports multiple text line delimiters now

New in Advanced ETL Processor Enterprise 4.2.1.0 (Sep 15, 2010)

  • Works directly with SQLite now
  • Various Interbase/Firebird related bug fixes
  • Fixed bug with import of MS Access tables with spaces in names
  • Minor Interface Changes
  • Fixed FTP list command for WindowsNT
  • Memory leaks were fixed
  • "Fail when no files found" check box was added to FTP object

New in Advanced ETL Processor Enterprise 4.2.0.10 (Sep 2, 2010)

  • Various bug fixes

New in Advanced ETL Processor Enterprise 4.2.0.8 (Aug 23, 2010)

  • It is now possible to pass variables between packages and transformations
  • Keep value transformation function
  • Shows PK information for access target and ole db target
  • Renaming transformations changes tab caption as well
  • No more duplication in transformation and validator grids
  • Copy,cut,paste from sql log
  • Access violation when directory does not exist for a backup/export
  • Table browser loads data much faster
  • Sql browser loads data much faster
  • Log screen loads much faster
  • Various Access violation and bug fixes
  • Documentation update

New in Advanced ETL Processor Enterprise 4.2.0.7 (Aug 19, 2010)

  • Various bugs fixes
  • Was not saving update key
  • Add column did not refresh data for excel and text data source and target
  • Problem with excel sheets with spaces
  • Delete characters did not show any characters to delete in title
  • Wrong icon for grid grouping in table browser

New in Advanced ETL Processor Enterprise 4.2.0.3 (Aug 9, 2010)

  • Various Excel related bugs fixes

New in Advanced ETL Processor Enterprise 4.2.0.0 (Aug 9, 2010)

  • Data grids modifications:
  • Grouping panel was added
  • Advanced filter dialog was introduced
  • Record number
  • New look and feel
  • Excel:
  • Works directly with Excel 3.0-2007
  • No ODBC, OleDB or MS Jet Required
  • Works correctly with mixed data types
  • Works correctly with cells with more 255 characters
  • No need for IMEX=1, HDR=Yes or Registry hacks (TypeGuessRows)
  • Loads data correctly all the time + no need to edit Excel file
  • Can create excel files in Excel 3.0-2007 format
  • Can insert data starting from specific cell
  • Can clear area before adding data into Excel

New in Advanced ETL Processor Enterprise 4.1.0.12 (Aug 9, 2010)

  • Massive performance improvement for large data repositories
  • Various access violations were fixed
  • Problem with duplicated fields was resolved

New in Advanced ETL Processor Enterprise 4.1.0.11 (Jul 26, 2010)

  • Massive performance improvement for large data repositories
  • Various access violations were fixed
  • Problem with duplicated fields was resolved

New in Advanced ETL Processor Enterprise 4.1.0.10 (Jul 26, 2010)

  • Various interface improvements
  • Popup menu was added to data grouper.
  • New options for unpivot and pivot data transformation object
  • Documentation update
  • Various bug fixes

New in Advanced ETL Processor Enterprise 4.1.0.7 (Jun 28, 2010)

  • Some problems were addressed related to loading data into varchar(max),nvarchar(max),varbinary(max)

New in Advanced ETL Processor Enterprise 4.1.0.6 (Jun 3, 2010)

  • ETL Package Variables
  • Package Script
  • HTTP Download Object
  • Documentation Update
  • Unlimited Email Attachments
  • System variables

New in Advanced ETL Processor Enterprise 4.1.0.5 (May 22, 2010)

  • Print reports directly to printer
  • Several new report export formats - Excel, Rtf, Csv and Pdf

New in Advanced ETL Processor Enterprise 4.1.0.1 (Apr 26, 2010)

  • Support for SQL Server 2005/2008 was improved

New in Advanced ETL Processor Enterprise 4.1.0.0 (Apr 26, 2010)

  • Database to Email and Email to Database transformations
  • Transform files into blob fields and Export of blob fields
  • Detailed SMTP Log
  • Detailed POP3 Log
  • Detailed FTP Log
  • Secure Email
  • It is no longer required to use "SET sql_mode='ANSI'" for MySql Connection
  • Ole db connections works with blobs now
  • Ms Sql Server connection support: TEXT, NTEXT, VARBINARY(MAX), VARCHAR(MAX),XML, NVARCHAR(MAX), IMAGE
  • ODBC Performance Improvements.
  • ODBC Support for BLOBS was improved and tested with various databases
  • Oracle connection support for BLOB,CLOB and NCLOB, LONG RAW data types.
  • PostgresSQL connection works with bytea
  • Interbase/Firebird support for blobs
  • MySQL support for blobs
  • Several MS Access bug fixes
  • Redesign of reader and writer properties dialog boxes.
  • Total number of Data transformation functions is now 49
  • Documentation Update

New in Advanced ETL Processor Enterprise 3.3.3.7 (Feb 26, 2010)

  • Secure email is now supported More detailed log for SMTP,POP3 and FTP Project Restore

New in Advanced ETL Processor Enterprise 3.3.3.6 (Feb 21, 2010)

  • 7 new ETL Transformation functions were added In Place Replace Encode Xml Element Decode Xml Element Encode Xml Attribute Decode Xml Attribute Encode Xml String Decode Xml String Total number of Data transformation functions is now 48 Documentation Update+minor bug fixes

New in Advanced ETL Processor Enterprise 3.3.3.5 (Feb 9, 2010)

  • Support for FTPS and FTPES was introduced

New in Advanced ETL Processor Enterprise 3.3.3.2 (Jan 10, 2010)

  • Now you can use Advanced ETL Processor to generate SQL Insert Scripts from any table

New in Advanced ETL Processor Enterprise 3.3.3.0 (Jan 3, 2010)

  • Support for Ole Db was Introduced (this part is still in beta stage) InList and Lookup ETL objects bugs were fixed

New in Advanced ETL Processor Enterprise 3.3.2.19 (Dec 17, 2009)

  • Check Disk Space Object was introduced
  • Minor bug fixes

New in Advanced ETL Processor Enterprise 3.3.2.18 (Nov 29, 2009)

  • Minor Bug Fixes Documentation Update Support for Dynamic file names was extended Now you can use calculations in target file names {GetSystemVariable('SOURCE_FILE_NAME')+'.good'} {GetSystemVariable('SOURCE_FILE_NAME')+'.very_very_bad'} FTP Improvements

New in Advanced ETL Processor Enterprise 3.3.2.16 (Oct 26, 2009)

  • Two new transformation functions were added: Replace Characters and Delete Characters
  • Minor Bug Fixes
  • Documentation Update

New in Advanced ETL Processor Enterprise 3.3.2.15 (Oct 14, 2009)

  • Some issues related to renaming files were resolved

New in Advanced ETL Processor Enterprise 3.3.2.11 (Oct 6, 2009)

  • Some issues related to zip object and repository backup were resolved

New in Advanced ETL Processor Enterprise 3.3.2.9 (Sep 30, 2009)

  • Corrected couple of bugs related to reports execution

New in Advanced ETL Processor Enterprise 3.3.2.6 (Sep 20, 2009)

  • New package object called "Data Export" was introduced Now you can export 3000+ tables from the database with couple of clicks Now you can filter incoming emails based on sender and subject

New in Advanced ETL Processor Enterprise 3.3.0.18 (Jun 15, 2009)

  • Updated Documentation
  • you can use for default vaues, for example Bad date will expand into Bad date 014200