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

Advanced ETL Processor Professional Changelog

What's new in Advanced ETL Processor Professional 6.4.2.33

Apr 25, 2024
  • Added: Ability to select mask or RegEx Directory Monitor dialogue (BREAKING CHANGE, PLEASE UPDATE DIRECTORY MONITOR SETTINGS)

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

  • Improved: "Check Date" Functionality.

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

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

New in Advanced ETL Processor Professional 6.4.2.30 (Apr 22, 2024)

  • Improved: "Fields Order" Error Handndling.

New in Advanced ETL Processor Professional 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 Professional 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 Professional 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 Professional 6.4.2.25 (Apr 15, 2024)

  • Improved: License server error handling

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

  • Added: "Fields Order" transformation object

New in Advanced ETL Processor Professional 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 Professional 6.4.2.21 (Apr 5, 2024)

  • Added: and variables

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

  • Improved: Set Variables Package action delimited file handlinng

New in Advanced ETL Processor Professional 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 Professional 6.4.2.15 (Mar 18, 2024)

  • Added: Support for Regular expressions to Directory monitor

New in Advanced ETL Processor Professional 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 Professional 6.4.2.12 (Mar 14, 2024)

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

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

  • Fixed: Issues with reading Excel files

New in Advanced ETL Processor Professional 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 Professional 6.4.2.8 (Mar 5, 2024)

  • Updated: Excel components

New in Advanced ETL Processor Professional 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 Professional 6.4.2.6 (Feb 29, 2024)

  • Added: Fixed Automap feature of Union all dialogue

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

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

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

  • Added: Automap button to Union all dialogue.

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

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

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

  • Added: variable to Check File Package Action

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

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

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

  • Added: XSD Validator package action

New in Advanced ETL Processor Professional 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 Professional 6.4.1.16 (Feb 1, 2024)

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

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

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

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

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

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

  • Updated: Third party components

New in Advanced ETL Processor Professional 6.4.1.11 (Jan 2, 2024)

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

New in Advanced ETL Processor Professional 6.4.1.10 (Jan 2, 2024)

  • Added: Replace option to File operation package action

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

  • Updated: Excel components

New in Advanced ETL Processor Professional 6.4.1.8 (Dec 8, 2023)

  • Added: Search String option to File check package action

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

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

New in Advanced ETL Processor Professional 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 Professional 6.4.1.5 (Nov 28, 2023)

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

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

  • Fixed: Minour Object Tree Bug

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

  • Fixed: Bug with detaching tabs

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

  • Added: Support for python 3.11 and 3.12

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

  • Fixed: Rotate transformation bug.

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

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

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

  • Improved: Block transformation progress bar position

New in Advanced ETL Processor Professional 6.4.0.0 (Nov 7, 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 Professional 6.3.12.17 (Nov 1, 2023)

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

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

  • Improved: Calculation engine update

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

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

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

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

New in Advanced ETL Processor Professional 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 Professional 6.3.12.10 (Oct 1, 2023)

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

New in Advanced ETL Processor Professional 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 Professional 6.3.12.8 (Sep 25, 2023)

  • Added: Incremental search to Expression editor dialogue

New in Advanced ETL Processor Professional 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 Professional 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 Professional 6.3.12.5 (Aug 31, 2023)

  • Improved: Logging fro send email package action

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

  • Improved: Copy and clone functionality

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

  • Improved: SFTP working with private keys

New in Advanced ETL Processor Professional 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 Professional 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 Professional 6.3.12.1 (Jul 12, 2023)

  • Added: Dynamic pivot example

New in Advanced ETL Processor Professional 6.3.12.0 (Jul 12, 2023)

  • Added: User defined fields to properties dialogs

New in Advanced ETL Processor Professional 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 Professional 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 Professional 6.3.11.25 (Jun 7, 2023)

  • Fixed: Office 365 email memory leak

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

  • Added: User Input Package Action

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

  • Added: Default Application Platform to options dialogue

New in Advanced ETL Processor Professional 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 Professional 6.3.11.21 (May 25, 2023)

  • Improved: The total number of demos is 87 now

New in Advanced ETL Processor Professional 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 Professional 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 Professional 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 Professional 6.3.11.17 (Apr 10, 2023)

  • Improved: Excel Operation Action working with mask

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

  • Improved: Ping package action error handling and logging

New in Advanced ETL Processor Professional 6.3.11.15 (Mar 31, 2023)

  • Improved: Ping package action error handling and logging

New in Advanced ETL Processor Professional 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 Professional 6.3.11.14 (Mar 17, 2023)

  • Fixed: Issues with showing lookup data

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

  • Fixed: Issues with package execution default result

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

  • Improved: Increased Data writer fields' dedifintions widths

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

  • Added: Write Variables Check Box to options dialogue

New in Advanced ETL Processor Professional 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 Professional 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 Professional 6.3.11.7 (Dec 9, 2022)

  • Added: Rest Writer.

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

  • Fixed: ExecuteObject Failure - Index Out of Bounds

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

  • Fixed: Office 35 Email Writer AV.

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

  • Fixed: UID was missing from Office 35 Email Reader

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

  • Added: Office 35 Email Writer

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

  • Added: Office 35 Email Reader

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

  • Fixed: Incorrect variable date format

New in Advanced ETL Processor Professional 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 Professional 6.3.10.11 (Sep 26, 2022)

  • Added: variable

New in Advanced ETL Processor Professional 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 Professional 6.3.10.9 (Aug 15, 2022)

  • Fixed: Issue with reading Office 365 email folders list

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

  • Improved: Schedule sorting

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

  • Fixed: Issue with Replace RegX transformation function

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

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

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

  • Fixed: Missing DLL's.

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

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

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

  • Fixed: Databuffer double procession bug

New in Advanced ETL Processor Professional 6.3.10.1 (May 5, 2022)

  • Fixed: Issues with autosaving Import script change.

New in Advanced ETL Processor Professional 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 Professional 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 Professional 6.3.9.4 (Mar 2, 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 Professional 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 Professional 6.3.9.1 (Feb 3, 2022)

  • Fixed: Is value In Database transformation function bug

New in Advanced ETL Processor Professional 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 Professional 6.3.8.4 (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 Professional 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 Professional 6.3.8.1 (Dec 6, 2021)

  • Fixed: IMAP4 and POP3 AV

New in Advanced ETL Processor Professional 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 Professional 6.3.7.32 (Nov 4, 2021)

  • Added: variable

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

  • Added: variable

New in Advanced ETL Processor Professional 6.3.7.31 (Oct 16, 2021)

  • Added:
  • Ability to ignore missing files to file operation

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

  • Added: Ability to ignore missing files to file operation

New in Advanced ETL Processor Professional 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 Professional 6.3.7.28 (Sep 19, 2021)

  • Improved: FTP Error handling

New in Advanced ETL Processor Professional 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 Professional 6.3.7.26 (Jul 16, 2021)

  • Fixed: Issues with saving email attachments.

New in Advanced ETL Processor Professional 6.3.7.25 (Jul 11, 2021)

  • Fixed: Minor Issues with logging

New in Advanced ETL Processor Professional 6.3.7.24 (Jul 1, 2021)

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

New in Advanced ETL Processor Professional 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 Professional 6.3.7.21 (Jun 11, 2021)

  • Added: etltools.ExecuteObject python function
  • Added: Error variables to Transformation, SQL check, SQL Script, and Import package actions
  • Improved: Split RegX transformation function
  • Improved: Email attachment detach uses regular expression now
  • Fixed: Minor spelling mistakes

New in Advanced ETL Processor Professional 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 Professional 6.3.7.19 (May 20, 2021)

  • Fixed: Issue with multiple semicolons within soap header

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

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

New in Advanced ETL Processor Professional 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 Professional 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 Professional 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 Professional 6.3.7.14 (Mar 5, 2021)

  • Added: Extract Attachments option to IMAP4 and POP3 reader

New in Advanced ETL Processor Professional 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 Professional 6.3.7.11 (Feb 7, 2021)

  • Fixed: Fixed issue with package variable.

New in Advanced ETL Processor Professional 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 Professional 6.3.7.9 (Dec 22, 2020)

  • Fixed: Loading data from FoxPro

New in Advanced ETL Processor Professional 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 Professional 6.3.7.7 (Dec 1, 2020)

  • Added: To, ReplyTo, Cc and Bcc fields to POP3 and IMAP4 readers

New in Advanced ETL Processor Professional 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 Professional 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 Professional 6.3.7.3 (Oct 31, 2020)

  • Added: Support Excel formulas creation

New in Advanced ETL Processor Professional 6.3.7.2 (Oct 18, 2020)

  • Improved: SMS connection dialogue.

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

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

New in Advanced ETL Processor Professional 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 Professional 6.3.6.17 (Jul 28, 2020)

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

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

  • Improved: Support for DATETIME2 Fields

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

  • Fixed: Issues with Azure blob loading

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

  • Fixed: Issues with Accumulate String transformation function

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

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

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

  • + Improved: JSON Data Handling

New in Advanced ETL Processor Professional 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 Professional 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 Professional 6.3.6.6 (Feb 16, 2020)

  • Improved: Email attachments handling
  • Added: Path builder
  • Improved: The behaviour of show message action was changed so when running from an agent it writes the message into the log

New in Advanced ETL Processor Professional 6.3.6.5 (Feb 9, 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 Professional 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 Professional 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 Professional 6.3.6.2 (Jan 23, 2020)

  • Added: Ability to select Amazon connection endpoint

New in Advanced ETL Processor Professional 6.3.6.1 (Dec 2, 2019)

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

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

  • Added: Support for telegram Bot API

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

  • Fixed: SplitRegX transformation function bug

New in Advanced ETL Processor Professional 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 Professional 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 Professional 6.3.5.4 (Jul 28, 2019)

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

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

  • Added: Case sensitive option to Lookup transformation object

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

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

New in Advanced ETL Processor Professional 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 Professional 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:
  • Report generator
  • Excel processing libraries
  • Cloud libraries
  • Text conversion libraries
  • Improved: Various bug fixes and improvements
  • Fixed: FTP errors when working with very large files
  • Fixed: Repository Synchronization dialogue issues with MongoDB
  • Fixed: Used by dialogue issues with MongoDB
  • Fixed: Excel data reading problems
  • Fixed: Objects Library bugs

New in Advanced ETL Processor Professional 6.3.4.13 (May 27, 2019)

  • Fixed: Decode JSON Object and Decode JSON Array error handling issues.

New in Advanced ETL Processor Professional 6.3.4.12 (May 11, 2019)

  • Added: Syslog datasource

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

  • Fixed: JSON Data reader AV.

New in Advanced ETL Processor Professional 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 Professional 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 Professional 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 Professional 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 Professional 6.3.4.5 (Jan 18, 2019)

  • Added: Support for calculations inside source reader source file
  • Fixed: Copy/Paste issues with SQL Lookup transformation

New in Advanced ETL Processor Professional 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 Professional 6.3.4.3 (Nov 22, 2018)

  • Improved: Slight performance improvement

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

  • Added:
  • Change Encoding Package Actio

New in Advanced ETL Processor Professional 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 Professional 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 Professional 6.3.3.2 (Aug 22, 2018)

  • Improved: JSON null values handling

New in Advanced ETL Processor Professional 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 Professional 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 Professional 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 Professional 6.3.2.16 (Jul 23, 2018)

  • Improved: Third party components update

New in Advanced ETL Processor Professional 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 Professional 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 Professional 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 Professional 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 Professional 6.3.2.11 (Jul 7, 2018)

  • Fixed: Loading Data Into Time Fields

New in Advanced ETL Processor Professional 6.3.2.10 (Jun 29, 2018)

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

New in Advanced ETL Processor Professional 6.3.2.8 (Jun 22, 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 Professional 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 Professional 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 Professional 6.3.2.5 (Jun 12, 2018)

  • Fixed: Reader Autoformat issues

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

  • Improved: Error handling for open files

New in Advanced ETL Processor Professional 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 Professional 6.3.2.2 (Jun 5, 2018)

  • Fixed: Python Scripting issues

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

  • Added: and packages variables

New in Advanced ETL Processor Professional 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 Professional 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 Professional 6.3.0.5 (Apr 10, 2018)

  • Added : Package EMail attachment filter

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

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

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

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

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

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

New in Advanced ETL Processor Professional 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 Professional 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 Professional 6.2.2.0 (Jan 28, 2018)

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

New in Advanced ETL Processor Professional 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 Professional 6.2.0.0 (Jan 20, 2018)

  • Added: Support for Visual Importer Scripts design and execution

New in Advanced ETL Processor Professional 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

New in Advanced ETL Processor Professional 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 Professional 6.0.0.13 (Sep 8, 2017)

  • Fixed issues with Ping Package Action

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

  • Fixed : Issues with JSON transformations

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

  • Fixed : Issues with reading JSON data

New in Advanced ETL Processor Professional 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 Professional 6.0.0.9 (Aug 18, 2017)

  • Fixed: Issues with non English repositories

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

  • Fixed: PGP Encryption Action

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

  • Fixed: Issues with reading brightpearl data

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

  • Fixed : Issues with assigning default values to lookup

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

  • Improved: Functionality of Running totals transformation function

New in Advanced ETL Processor Professional 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 Professional 6.0.0.2 (Jun 23, 2017)

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

New in Advanced ETL Processor Professional 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 Professional 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 Professional 5.9.4.8 (Jun 14, 2017)

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

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

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

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

  • Fixed: Issues with loading version info

New in Advanced ETL Processor Professional 5.9.4.4 (May 15, 2017)

  • Fixed: Tableau Datetime fields processing issues
  • Fixed: MySql Server Repository Creation Scripts issues
  • Fixed: Repository backup issues

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

  • Fixed: HTTP Form post action issues

New in Advanced ETL Processor Professional 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 Professional 5.9.4.1 (Apr 11, 2017)

  • Fixed : Fixed QVD reading issues

New in Advanced ETL Processor Professional 5.9.4.0 (Apr 11, 2017)

  • Improved: Repository Backup performance
  • Improved: Repository Backup restore performance
  • Improved: Repository Synchronization Wizard can use backup as source for Synchronization
  • Major update:
  • Uses new backup format

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

  • Improved: 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 Professional 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 Professional 5.9.3.20 (Mar 9, 2017)

  • Fixed : Issues with loading version info

New in Advanced ETL Processor Professional 5.9.3.19 (Mar 5, 2017)

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

New in Advanced ETL Processor Professional 5.9.3.18 (Feb 20, 2017)

  • Fixed: Issues with system variables

New in Advanced ETL Processor Professional 5.9.3.15 (Jan 22, 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 Professional 5.9.3.14 (Jan 15, 2017)

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

New in Advanced ETL Processor Professional 5.9.3.13 (Jan 9, 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 Professional 5.9.3.12 (Dec 21, 2016)

  • Improved : Schedule dialog allows to enter multiple lines now

New in Advanced ETL Processor Professional 5.9.3.11 (Dec 20, 2016)

  • Fixed : Issues with MySQL Repository

New in Advanced ETL Processor Professional 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 Professional 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 Professional 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 Professional 5.9.3.5 (Nov 20, 2016)

  • Added : Excel Operation action

New in Advanced ETL Processor Professional 5.9.3.3 (Nov 13, 2016)

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

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

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

New in Advanced ETL Processor Professional 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 Professional 5.9.2.20 (Sep 21, 2016)

  • Added: Added variable
  • Added : Do not show notifications option was added
  • Improved : Computer to execute on is converted to upper case now
  • Improved : Current computer name is used by default as Computer to execute on
  • Fixed : Addressed issues with variable

New in Advanced ETL Processor Professional 5.9.2.17 (Sep 21, 2016)

  • Improved : Global variables handling for Reports

New in Advanced ETL Processor Professional 5.9.2.16 (Aug 22, 2016)

  • Fixed : BDE Datasource issues
  • Improved : MySQL Error handling
  • Improved : Global variables handling

New in Advanced ETL Processor Professional 5.9.2.15 (Aug 15, 2016)

  • Fixed: Problems with reading delimited text files when delimiter is more than one character log

New in Advanced ETL Processor Professional 5.9.2.14 (Aug 3, 2016)

  • Fixed : Problems with clone row transformation object

New in Advanced ETL Processor Professional 5.9.2.13 (Jul 30, 2016)

  • Added: Execute One Action at the time option
  • Fixed : Problems with reading data from Salesforce

New in Advanced ETL Processor Professional 5.9.2.12 (Jul 25, 2016)

  • Fixed : Problems with refreshing list of Oracle Tables

New in Advanced ETL Processor Professional 5.9.2.11 (Jul 21, 2016)

  • Fixed : Problems with AM/PM Date conversion

New in Advanced ETL Processor Professional 5.9.2.10 (Jul 15, 2016)

  • Fixed : SFTP Rename issues

New in Advanced ETL Processor Professional 5.9.2.9 (Jul 5, 2016)

  • Improved : JDBC Processing
  • Fixed : Problems with version control

New in Advanced ETL Processor Professional 5.9.2.8 (Jul 5, 2016)

  • Improved : JDBC Errors Handling

New in Advanced ETL Processor Professional 5.9.2.9 (Jul 4, 2016)

  • Improved : JDBC Processing
  • Fixed : Problems with version control

New in Advanced ETL Processor Professional 5.9.2.8 (Jul 4, 2016)

  • Improved : JDBC Errors Handling

New in Advanced ETL Processor Professional 5.9.2.7 (Jul 4, 2016)

  • Fixed : Problems with Soap Package Action Parameters

New in Advanced ETL Processor Professional 5.9.2.6 (Jun 27, 2016)

  • Fixed : Problems with Soap Package Action Parameters

New in Advanced ETL Processor Professional 5.9.2.5 (Jun 27, 2016)

  • New : Keep Alive option to FTP Dialogue
  • Improved : status bar formatting for FTP operations

New in Advanced ETL Processor Professional 5.9.2.4 (Jun 7, 2016)

  • Fixed : Problems with reading data from unicode files
  • Fixed : Problems with command line execution

New in Advanced ETL Processor Professional 5.9.2.0 (May 29, 2016)

  • Third party compoments update
  • Support for the new functions introduced in the Excel 2016 January Update
  • Improved compatibility with thid party xlsx files
  • Improved compatibility with invalid xls and xlsx files
  • Improved : Excel 2010 equations are now preserved in xlsx
  • Improved : Log and rejected records files are no longer using executable location
  • Improved : Log screen refresh logic
  • New : Support SSL v2, v3, v1_1 and v1_2 was introduced
  • New : Support for opening xls versions from 2 to 4
  • FTP action bug fixes
  • Fixed order of records specific for Excel 2010 to workaround a bug in Excel 2010.
  • Some very complex files could raise an error when opened in Excel 2010, even when they were correct by the xlsx spec.
  • Fixed : Xlsx files with 0 bytes xml files inside could throw an "Invalid XML file" error.
  • Fixed : Data validations entered manually in xls files could fail to work when opened in Excel
  • Fixed : Row Cannot Be Located for Updating issue

New in Advanced ETL Processor Professional 5.9.1.12 (May 17, 2016)

  • Addressed data compression issues
  • Added support for aes192-cbc,aes192-ctr,aes256-cbc,aes256-ctr encryption to FTP connection dialog

New in Advanced ETL Processor Professional 5.9.1.11 (May 17, 2016)

  • Added support for aes192-cbc,aes192-ctr,aes256-cbc,aes256-ctr encryption to FTP client

New in Advanced ETL Processor Professional 5.9.1.10 (Apr 27, 2016)

  • Added variable

New in Advanced ETL Processor Professional 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 Professional 5.9.1.8 (Apr 20, 2016)

  • Addressed Salesforce data update issues

New in Advanced ETL Processor Professional 5.9.1.7 (Apr 9, 2016)

  • Improved support for RSS feeds

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

  • Calculation transformation funtion support Python now

New in Advanced ETL Processor Professional 5.9.1.4 (Mar 28, 2016)

  • Addressed issues with Running Total transformation

New in Advanced ETL Processor Professional 5.9.1.4 (Mar 28, 2016)

  • Addressed issues with Running Total transformation

New in Advanced ETL Processor Professional 5.9.1.3 (Mar 23, 2016)

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

New in Advanced ETL Processor Professional 5.9.1.2 (Mar 23, 2016)

  • Added Write to File transformation function
  • Minor bug fixes

New in Advanced ETL Processor Professional 5.9.1.1 (Mar 16, 2016)

  • Added Write to File transformation function

New in Advanced ETL Processor Professional 5.9.1.0 (Mar 14, 2016)

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

New in Advanced ETL Processor Professional 5.9.0.15 (Mar 8, 2016)

  • Package designer bugs fixes
  • Date fields processing bugs fixes

New in Advanced ETL Processor Professional 5.9.0.14 (Mar 3, 2016)

  • Joiner Object bugs fixes

New in Advanced ETL Processor Professional 5.9.0.11 (Feb 29, 2016)

  • SalesForce data processing fixes

New in Advanced ETL Processor Professional 5.9.0.10 (Feb 11, 2016)

  • PDF Report quality improvements

New in Advanced ETL Processor Professional 5.9.0.9 (Feb 11, 2016)

  • PDF Report quality improvements

New in Advanced ETL Processor Professional 5.9.0.8 (Feb 9, 2016)

  • PDF Report quality improvments

New in Advanced ETL Processor Professional 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
  • Added variables

New in Advanced ETL Processor Professional 5.9.0.6 (Feb 5, 2016)

  • Scheduler bug fix

New in Advanced ETL Processor Professional 5.9.0.5 (Feb 5, 2016)

  • Improved support for very large QVD files

New in Advanced ETL Processor Professional 5.9.0.4 (Feb 1, 2016)

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

New in Advanced ETL Processor Professional 5.9.0.3 (Jan 25, 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 Professional 5.9.0.1 (Jan 14, 2016)

  • Addressed issues with print preview screen
  • Addressed issues flicking

New in Advanced ETL Processor Professional 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 Professional 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 Professional 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 Professional 5.8.3.21 (Nov 17, 2015)

  • Addressed issues with downloading files via HTTP/HTTPS

New in Advanced ETL Processor Professional 5.8.3.21 (Nov 17, 2015)

  • Addressed issues with downloading files via HTTP/HTTPS

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

  • Addressed issues with downloading files via HTTP/HTTPS

New in Advanced ETL Processor Professional 5.8.3.20 (Nov 14, 2015)

  • Addressed issues with creating Excel files

New in Advanced ETL Processor Professional 5.8.3.18 (Nov 5, 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 Professional 5.8.3.17 (Nov 5, 2015)

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

New in Advanced ETL Processor Professional 5.8.3.16 (Oct 29, 2015)

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

New in Advanced ETL Processor Professional 5.8.3.15 (Oct 27, 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 Professional 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 Professional 5.8.3.13 (Oct 20, 2015)

  • Addressed issues with downloading files via HTTP/HTTPS

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

  • Faster QVD files processing
  • Addressed issues with variables

New in Advanced ETL Processor Professional 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 Professional 5.8.3.9 (Oct 12, 2015)

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

New in Advanced ETL Processor Professional 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 Professional 5.8.3.6 (Sep 24, 2015)

  • Addressed issues with Loop package action

New in Advanced ETL Processor Professional 5.8.3.5 (Sep 23, 2015)

  • Addressed issues with subtransformation function

New in Advanced ETL Processor Professional 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 Professional 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 Professional 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 Professional 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 Professional 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 Professional 5.8.2.15 (Sep 1, 2015)

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

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

  • Added Field Value transformation function

New in Advanced ETL Processor Professional 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 Professional 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 Professional 5.8.2.10 (Aug 21, 2015)

  • Addressed issues with Log screen

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

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

New in Advanced ETL Processor Professional 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 Professional 5.8.2.7 (Aug 11, 2015)

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

New in Advanced ETL Processor Professional 5.8.2.6 (Aug 5, 2015)

  • Addressed issues with Loop package action

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

  • Added support for Clarion dat files
  • Added support for Twitter

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

  • Addressed issues with sending emails with attachments

New in Advanced ETL Processor Professional 5.8.2.3 (Jul 23, 2015)

  • Addressed issues with sorter

New in Advanced ETL Processor Professional 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 Professional 5.8.2.0 (Jul 20, 2015)

  • Added support for Slemma

New in Advanced ETL Processor Professional 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 Professional 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 Professional 5.8.1.3 (Jun 29, 2015)

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

New in Advanced ETL Processor Professional 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 Professional 5.8.1.1 (Jun 23, 2015)

  • Extended Date Diff functionality

New in Advanced ETL Processor Professional 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 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 d 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 Professional 5.8.0.38 (Jun 4, 2015)

  • IMAP4 and POP3 fixes
  • Various bugs fixes and improvements

New in Advanced ETL Processor Professional 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 Professional 5.8.0.36 (May 27, 2015)

  • Addressed issues with loading null values into salesforce

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

  • Addressed issues with loading data from SQL Server CE

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

  • Addressed issues with loading data from delimited files

New in Advanced ETL Processor Professional 5.8.0.33 (May 18, 2015)

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

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

  • Documentation update
  • Added GetExcelCellValue calculation function
  • Sorter improvements

New in Advanced ETL Processor Professional 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 Professional 5.8.0.29 (Apr 19, 2015)

  • Addressed issues with Is Number validation function

New in Advanced ETL Processor Professional 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 Professional 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 Professional 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 Professional 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 Professional 5.8.0.23 (Apr 10, 2015)

  • Addressed issues with date formats

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

  • Addressed issues with processing of delimited files

New in Advanced ETL Processor Professional 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 Professional 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 Professional 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 Professional 5.8.0.17 (Mar 13, 2015)

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

New in Advanced ETL Processor Professional 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 Professional 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 Professional 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 Professional 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 Professional 5.8.0.10 (Feb 28, 2015)

  • Addressed issues with creating rejected records file

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

  • Addressed issues with running ODBC Manager from application

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

  • SSL libraries update
  • Various bug fixes and improvements

New in Advanced ETL Processor Professional 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 Professional 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 Professional 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 Professional 5.8.0.3 (Feb 2, 2015)

  • Addressed issues with theme management
  • Loads recent history of changes by default now

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

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

New in Advanced ETL Processor Professional 5.8.0.1 (Jan 27, 2015)

  • SFTP rename bug fix
  • Table Editor bug fixes

New in Advanced ETL Processor Professional 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 Professional 5.7.10.10 (Dec 11, 2014)

  • Addressed issues with GetExcelCelValue transformation function

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

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

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

  • Added Reset height option
  • Updated repository creation scripts

New in Advanced ETL Processor Professional 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 Professional 5.7.10.5 (Dec 2, 2014)

  • Addressed issues with XML encoding

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

  • Addressed some validator issues

New in Advanced ETL Processor Professional 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 Professional 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 Professional 5.7.10.0 (Nov 18, 2014)

  • Added support for tableau tde files

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

  • Loop Package Action improvements

New in Advanced ETL Processor Professional 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 Professional 5.7.9.42 (Nov 6, 2014)

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

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

  • Addressed Splitter dialogue issues

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

  • Added new transformation field values

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

  • Addressed Salesforce connection dialogue issues

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

  • Addressed SFTP bugs

New in Advanced ETL Processor Professional 5.7.9.37 (Oct 23, 2014)

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

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

  • Minor interface improvements

New in Advanced ETL Processor Professional 5.7.9.35 (Oct 18, 2014)

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

New in Advanced ETL Processor Professional 5.7.9.33 (Oct 11, 2014)

  • Report generator bugs fixes

New in Advanced ETL Processor Professional 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 Professional 5.7.9.30 (Sep 24, 2014)

  • Addressed CASE transformation issues

New in Advanced ETL Processor Professional 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 Professional 5.7.9.24 (Sep 3, 2014)

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

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

  • Added GUID function to scripting language
  • Documentation Update

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

  • Addressed issues with BIGINT fields

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

  • Management console fixes

New in Advanced ETL Processor Professional 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 Professional 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 Professional 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 Professional 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 Professional 5.7.9.15 (Aug 1, 2014)

  • Interface improvements
  • Addressed issues with CASE transformation function

New in Advanced ETL Processor Professional 5.7.9.14 (Jul 28, 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 Professional 5.7.9.13 (Jul 22, 2014)

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

New in Advanced ETL Processor Professional 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 Professional 5.7.9.10 (Jul 17, 2014)

  • Addressed problems with refreshing logs

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

  • Excel processing engine update

New in Advanced ETL Processor Professional 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 Professional 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 Professional 5.7.9.5 (Jun 28, 2014)

  • Support for latest version of Google spreadsheets was introduced

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

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

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

  • Up to 50 percent faster working with QVD files

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

  • Added Authentication support to HTTP package objects

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

  • Addressed memory leaks problems

New in Advanced ETL Processor Professional 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 Professional 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 Professional 5.7.8.4 (May 30, 2014)

  • Addressed issues of loading data from the files with old creation date
  • Smaller Setup

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

  • Fixed problem with log deletion

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

  • XML and ODBC fixes

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

  • Execution stability fixes
  • Date Diff function fixes

New in Advanced ETL Processor Professional 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 Professional 5.7.7.23 (May 14, 2014)

  • Addressed file update problems

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

  • Added separate application to edit options

New in Advanced ETL Processor Professional 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 Professional 5.7.7.18 (Apr 18, 2014)

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

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

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

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

  • Addressed union object issues

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

  • Addressed some subtransformation issues

New in Advanced ETL Processor Professional 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 Professional 5.7.7.9 (Feb 17, 2014)

  • Addressed issues of loading data from Excel files

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

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

New in Advanced ETL Processor Professional 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 Professional 5.7.7.3 (Jan 24, 2014)

  • Addressed issues with sending emails

New in Advanced ETL Processor Professional 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 Professional 5.7.7.0 (Jan 20, 2014)

  • Addressed some FTP Package dialogue issues

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

  • Updated regular expression for US SSN

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

  • Addressed issues of loading data from flat files

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

  • Addressed issues with long object names

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

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

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

  • Corrected issues with FTP automation

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

  • Documentation update
  • OleDB support for repository connections

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

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

New in Advanced ETL Processor Professional 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 Professional 5.7.6.19 (Dec 14, 2013)

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

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

  • Addressed issues of loading data from flat files

New in Advanced ETL Processor Professional 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 Professional 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 Professional 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 Professional 5.7.6.8 (Nov 15, 2013)

  • Deduplicator AV fix
  • QVD reading bug fixes

New in Advanced ETL Processor Professional 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 Professional 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 Professional 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 Professional 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 Professional 5.7.6.1 (Nov 11, 2013)

  • Better source connection errors handling

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

  • Salesforce is supported as datatarget
  • Addressed more autoformat problems

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

  • Addressed issues with Salesforce processing

New in Advanced ETL Processor Professional 5.7.5.8 (Oct 14, 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 Professional 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 Professional 5.7.5.5 (Oct 8, 2013)

  • Addressed problem with ping object

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

  • Minor Interface improovments
  • Addressed problems with excel date formatting

New in Advanced ETL Processor Professional 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 Professional 5.7.5.2 (Oct 3, 2013)

  • Addressed problems with formatting dates

New in Advanced ETL Processor Professional 5.7.5.1 (Sep 30, 2013)

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

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

  • Addressed problems with Datediff function

New in Advanced ETL Processor Professional 5.7.4.5 (Sep 10, 2013)

  • Up to 20 percent performance increase

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

  • Up to 70 percent performance increase

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

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

New in Advanced ETL Processor Professional 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 Professional 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 Professional 5.7.3.1 (Jul 31, 2013)

  • Addressed some lookup issues

New in Advanced ETL Processor Professional 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 Professional 5.7.2.5 (Jun 26, 2013)

  • Functionality of Splitter and Get Line functions was improved
  • Documentation update
  • Various bug fixes and interface improvements

New in Advanced ETL Processor Professional 5.7.2.4 (Jun 26, 2013)

  • QVD generation bugs fixes

New in Advanced ETL Processor Professional 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 Professional 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 Professional 5.7.2.1 (Jun 10, 2013)

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

New in Advanced ETL Processor Professional 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 Professional 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 Professional 5.7.1.3 (May 8, 2013)

  • Various bug fixes

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

  • Introduced Repository Synchronization wizard

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

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

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

  • Addressed some groupper issues

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

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

New in Advanced ETL Processor Professional 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 Professional 5.6.3.10 (Mar 13, 2013)

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

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

  • Added Undo an Redo functionality to the transformation designer

New in Advanced ETL Processor Professional 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 Professional 5.6.3.6 (Mar 10, 2013)

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

New in Advanced ETL Processor Professional 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 Professional 5.6.2.11 (Mar 2, 2013)

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

New in Advanced ETL Processor Professional 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 Professional 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 Professional 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 Professional 5.6.2.2 (Jan 21, 2013)

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

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

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

New in Advanced ETL Processor Professional 5.6.1.4 (Dec 27, 2012)

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

New in Advanced ETL Processor Professional 5.6.1.0 (Dec 3, 2012)

  • Introduced Auto complete functionality
  • Addressed some issues related to loading data from QVD files
  • Various bug fixes

New in Advanced ETL Processor Professional 5.6.0.0 (Nov 26, 2012)

  • Support for stored procedures as data target was introduced
  • Performance improvements for MS SQL Server Connection
  • Various Bug Fixes
  • Documentation Update

New in Advanced ETL Processor Professional 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 Professional 5.5.2.2 (Oct 9, 2012)

  • Various bug fixes

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

  • Repository Scripts fix

New in Advanced ETL Processor Professional 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 Professional 5.5.0.0 (Sep 1, 2012)

  • Support for QVD files was introduced
  • Various bug fixes

New in Advanced ETL Processor Professional 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 Professional 5.4.3.1 (Jul 31, 2012)

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

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

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

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

  • Various bug fixes

New in Advanced ETL Processor Professional 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 Professional 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 Professional 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 Professional 5.3.1.4 (Jun 7, 2012)

  • Corrected some problems related to dynamic file names

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

  • Corrected some problems related to dynamic file names

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

  • Support Excel named ranges was introduced
  • Various bug fixes

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

  • Support Excel named ranges was introduced
  • Various bug fixes

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

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

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

  • Support for excel formating was introduced

New in Advanced ETL Processor Professional 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 Professional 5.2.0.3 (Mar 27, 2012)

  • 10x performance increase fro generating QVX files

New in Advanced ETL Processor Professional 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 Professional 5.2.0.0 (Mar 22, 2012)

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

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

  • Support for Dynamic SQL for ETL transformations was introduced

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

  • Addressed some issues related to working with integrated scheduler

New in Advanced ETL Processor Professional 5.0.1.3 (Feb 1, 2012)

  • Support for QlikView QVX files was introduced
  • Various bug fixes

New in Advanced ETL Processor Professional 5.0.1.2 (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 Professional 5.0.1.1 (Jan 23, 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 Professional 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 Professional 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
  • 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 Professional 4.2.7.3 (Nov 19, 2011)

  • Addressed some scheduler issues

New in Advanced ETL Processor Professional 4.2.7.1 (Oct 25, 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 Professional 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 Professional 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 Professional 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 Professional 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 Professional 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 Professional 4.2.6.8 (Aug 3, 2011)

  • Added Fields Selector transformation function
  • Various bug fixes

New in Advanced ETL Processor Professional 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 Professional 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 Professional 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 Professional 4.2.6.2 (Jul 7, 2011)

  • Added "Search in subdirectories" option to data reader

New in Advanced ETL Processor Professional 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 Professional 4.2.6.0 (Jun 28, 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: Open Data Validator and map validation rules to output fields. Save Data transformation. Repeat for all transformations

New in Advanced ETL Processor Professional 4.2.5.3 (Jun 4, 2011)

  • Incremental Transformation function search was introduced

New in Advanced ETL Processor Professional 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 Professional 4.2.4.17 (May 4, 2011)

  • Various bug fixes
  • Uses MS XML now

New in Advanced ETL Processor Professional 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 Professional 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 Professional 4.2.4.13 (Apr 11, 2011)

  • Added CopyFile function
  • Various bug fixes

New in Advanced ETL Processor Professional 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 Professional 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 Professional 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 Professional 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 Professional 4.2.4.6 (Feb 28, 2011)

  • Fixed move bugs

New in Advanced ETL Processor Professional 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 Professional 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 Professional 4.2.4.3 (Feb 15, 2011)

  • Fixed some data sorting bugs

New in Advanced ETL Processor Professional 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 Professional 4.2.4.1 (Feb 4, 2011)

  • Minor bug fixes

New in Advanced ETL Processor Professional 4.2.4.0 (Jan 24, 2011)

  • Support for Sql Server Compact Edition was introduced
  • Various bug fixes

New in Advanced ETL Processor Professional 4.2.3.9 (Jan 20, 2011)

  • Support for Cross tab reports was introduced
  • Report Export format was extended

New in Advanced ETL Processor Professional 4.2.3.7 (Jan 14, 2011)

  • Support for Cross tab reports was introduced
  • Report Export format was extended

New in Advanced ETL Processor Professional 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 Professional 4.2.3.5 (Jan 9, 2011)

  • 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 Professional 4.2.2.10 (Nov 30, 2010)

  • Copy project option was added
  • Various bugs fixes

New in Advanced ETL Processor Professional 4.2.2.6 (Nov 24, 2010)

  • Various bugs fixes

New in Advanced ETL Processor Professional 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 Professional 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 Professional 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 Professional 4.2.2.2 (Oct 26, 2010)

  • Data grid grouping access violations fixes
  • Send email to support fixed

New in Advanced ETL Processor Professional 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 Professional 4.2.1.1 (Sep 20, 2010)

  • Supports multiple text line delimiters now

New in Advanced ETL Processor Professional 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 Professional 4.2.0.10 (Sep 2, 2010)

  • Various bug fixes

New in Advanced ETL Processor Professional 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 Professional 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 Professional 4.2.0.3 (Aug 9, 2010)

  • Various Excel related bugs fixes

New in Advanced ETL Processor Professional 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 Professional 4.1.0.12 (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 Professional 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 Professional 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 Professional 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 Professional 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 Professional 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 Professional 4.1.0.4 (May 17, 2010)

  • New button was added to data transformation log
  • Show first 100 records

New in Advanced ETL Processor Professional 4.1.0.1 (Apr 26, 2010)

  • Support for SQL Server 2005/2008 was improved

New in Advanced ETL Processor Professional 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 Professional 3.3.3.7 (Feb 26, 2010)

  • Secure email is now supported More detailed log for SMTP,POP3 and FTP objects Project Restore

New in Advanced ETL Processor Professional 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 Professional 3.3.3.5 (Feb 9, 2010)

  • Support for FTPS and FTPES was introduced

New in Advanced ETL Processor Professional 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 Professional 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 Professional 3.3.2.19 (Dec 17, 2009)

  • Check Disk Space Object was introduced
  • Minor bug fixes

New in Advanced ETL Processor Professional 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 Professional 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 Professional 3.3.2.15 (Oct 14, 2009)

  • Some issues related to renaming files were resolved

New in Advanced ETL Processor Professional 3.3.2.11 (Oct 6, 2009)

  • Some issues related to zip object and repository backup were resolved

New in Advanced ETL Processor Professional 3.3.2.9 (Sep 30, 2009)

  • Corrected couple of bugs related to reports execution

New in Advanced ETL Processor Professional 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 ans subject

New in Advanced ETL Processor Professional 3.3.2.2 (Sep 2, 2009)

  • Now works directly with MySql PostgreSQL Interbase and Firebird

New in Advanced ETL Processor Professional 3.3.2.1 (Aug 4, 2009)

  • Minor Bug Fixes
  • Documentation Update

New in Advanced ETL Processor Professional 3.3.2.0 (Jul 27, 2009)

  • Updated sequence transformation object Running totals
  • Updated documentation
  • Minor bug fixes

New in Advanced ETL Processor Professional 3.3.0.18 (Jun 11, 2009)

  • Updated Documentation you can use for default vaues for example Bad date will expand into Bad date 014200 Minor bug fixes

New in Advanced ETL Processor Professional 3.3.0.17 (Jun 9, 2009)

  • FTP Move files option was added Move files has "Overwrite files" option now Minor bug fixes

New in Advanced ETL Processor Professional 3.3.0.16 (Jun 5, 2009)

  • Some spelling errors were corrected FTP Directory Listing is tab delimited now Minor bug fixes

New in Advanced ETL Processor Professional 3.3.0.14 (May 25, 2009)

  • Automatic Version check was introduced Various bug fixes

New in Advanced ETL Processor Professional 3.3.0.2 (Apr 13, 2009)

  • This version works up to 30 percent faster comparing to the previous release Full support for unicode
  • Support for sql functions and oracle sequences
  • It is now possible to pull data directly from Oracle database without ODBC.
  • Various bug fixes

New in Advanced ETL Processor Professional 3.2.0.8 (Mar 21, 2009)

  • Updated SQL Query Builder Support for Oracle 11g