A new version of Advanced ETL Processor is out with a much more anticipated new feature: the ability to work with multiple excel sheets within a single transformation. This was not possible before. the only way was is to create a separate transformation for every single sheet and execute them sequentially.
All you need to do is point writers to the same file. In the example below, "Writer C1" adds data to the C1 excel sheet and "Writer C2" adds data to the C2 excel sheet. This not only makes the life of our ETL software users easier but also improves performance.
Another useful feature is "Cache values" option of "Get Excel Cell Value Dynamic" transformation function. This increase performance multiple times.
Other changes are:
EVENT_MONITORS holds data about Event MonitorsNODES Holds metadata information about the computer where software is installed and runningNODES Holds metadata information the software installed on the computer, used pause execution
Following fields were removed from QUEUE and QUEUE_HISTORY tables
NUMBER_OF_EXECUTIONS,APPLICATION_NAME,EXECUTE_ON_COMPUTER and COMPUTER_TO_EXECUTE_ON
Following fields were added to QUEUE and QUEUE_HISTORY tables
APPLICATION_SUBMITTED,APPLICATION_EXECUTED and APPLICATION_EXECUTED_PLATFORM
EXECUTE_ON_COMPUTER was removed from SCHEDULE table and APPLICATION_PLATFORM was added
In this version, we concentrated on fixing small bugs and extending the functionality of the Management console
Other changes are:
+ Added: Event monitors editor to Management Console + Added: Incremental Search to Object Selector to Management Console + Improved: Restoring backups (Some users add fields to repository tables and that led to 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 Dropdown always shows the 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 the message + Improved: Execution log within Package editor looks the same way as execution log (Tree)
The new version of Advanced ETL Processor introduces support for GUID generation, Random number generation, and base 64 Encoding/Decoding.
A lot of XML files have very complex structure and XSLT allows to transform the data into more readable format:
<table> <record> <field1>value1<field1> <field2>value2<field1> <record> <record> <field1>value1<field1> <field2>value2<field1> <record> <table>
XML can be transformed before loading the data or if the user wants to process/validate XML which is stored in the database field two new data transformation functions can be used
We would like to thank our customers for providing useful feedback
After months of hard work Active Table Editor Version 5 is available for download. It introduces an enormous amount of useful changes, improvements and bug fixes:
Support will provide assistance to existing customers who pay for support and maintenance.
Please use our support forum to provide us with feedback. we are currently looking for beta testers and will be happy to assist anyone having problems
Based on our user's feedback in the latest version of Visual Importer ETL we introduced "Auto Complete Function",the rest of the products to follow.
Following forms and dialogs support now Auto Complete Fuction: Table Browser, SQL Before, SQL After, Calculation, Expression Builder
Advanced ETL processor provides extended support for automation of compression and decompression operations, it supports a wide range of archive file formats such as
Keeping an eye on ETL logs is extremely important, over time they can become too big and consume a large amount of disk space. Clear log action is here to help our users to address this problem.
We would like to thank you Todd Mathews from Ims fast pak for providing us with useful feedback
Other changes are:
Advanced ETL Processor offers full support for Microsoft SQL Server Compact Edition.
Users can now perform complex transformations of Microsoft SQL Server Compact Edition data, Import, Export, Transform and Validate any data with ease.
SQL Server Compact 3.5 SP2 is a free, easy-to-use embedded database engine that lets developers build robust Windows Desktop and mobile applications that run on all Windows platforms including Windows XP, Vista, Pocket PC, and Smartphone.
Available on both 32-bit and x64 platforms, SQL Server Compact 3.5 helps you drive new levels of performance within your organization through data.
Based on our user's feedback in the latest version of Visual Importer ETL we introduced "Case package Action"
That makes it possible to execute different work-flow action depending on variable value.
Following products are affected:
If you have just updated the software we recommend making repository backup immediately.
As a result of format change backup and restore operations are must faster.
Repository Synchronization Wizard can use the backup as a source for Synchronization
This allows to create standard solutions and sell them to the end-users. They can be easily updated later when necessary.
Starting from the middle of March 2019 users would need to enter the license code and control number to register the software.
We used a very old licensing system and we wanted to change it for a very long time. License type can be now clearly seen on the about box and maintenance tab. This change applies to all our software products.
New data transformation function creates copies (clones) of a row and outputs them directly after the original row to the next steps.
Clone row properties Dialog
We would like to thank Vattikonda from https://www.cepres.com/ for providing us with useful feedback
The latest version of our ETL Software support reading and posting Telegram messages using Bot API. This opens a new window of opportunity for chat automation.
Note: The user must talk to the Bot first
We would like to thank Vassalli from Galvolux for providing us with useful feedback
The new version of Database Browser is available for download. In this version, we have introduced a data import wizard.
About Database Browser
This easy to use tool allows the user to connect to any database and browse or modify data, run SQL scripts, export and print data. And the most important thing it is Free-ware.
In this release, we have introduced support for tabs
A full list of changes
+ Support for multiple tabs+ Connections and Execution history are stored in a separate database now+ New connection dialogue+ Comments for connections+ Create date, update date and user name information for connections
A new version of Advanced ETL Processor is available for download
In this release, we have introduced debugger and greatly enhanced the development of Data transformation packages
+ Package debugger was introduced+ Breakpoints were introduced+ Execute single package object option was introduced+ Project Tree View - COLLAPSE/EXPAND buttons were added+ More generic log viewer+ Ability to group packages, SQL scripts reports, and emails was added+ Package objects have objects tree for the selection now+ Execution agent writes startup error messages in the log file- Disappearing tree nodes problem was addressed- "Progam" file was created on drive c- Double attachments - XML XSLT transformation fix- Some auto format issues were addressed- Minor interface tweaks- Addressed issues related to running execution agent on win64
Great work! That might be a World’s Record for publishing a new version of a major application.
Page 1 of 4