1. Refreshed UI/UX
Affected area: Etlworks UI
Once again, we updated the Etlworks Integrator UI/UX to further improve user experience.
1.1 The tags and filters are now sticky and take less space on the screen
1.2 The tag view and expandable tags are now enabled by default
2. Added the ability to send emails in HTML Format
Previously it was only possible to send emails in plain text or as an attachment.
In this update, we introduced the ability to send emails in HTML Format.
3. Added the ability to configure an Excel worksheet name or index at the transformation level
In Etlworks Integrator, the name or index of the Excel worksheet is configured in the Excel Format.
In this update, we introduced the ability to use the same Connection and Format to read from or write into different Excel worksheets.
When creating the source-to-destination transformation, use the
filename|worksheet notation in the
matrix.xlsx|income tells the system to read data from the worksheet
income in the file
4. Added the ability to connect to MongoDB over the SSH tunnel
In this update, we introduced the ability to connect to the MongoDB over the SSH tunnel.
5. Added the ability to enforce case sensitive table matching for MySQL CDC connector
Prior to this update, the MySQL CDC connector was whitelisting the tables to extract data from based solely on their names. For example, if there is a database
test and the tables
Abc the stream would include records from
In this update, we introduced the ability to enforce the case sensitive matching of the
db.table defined for the source.
1. Changes to how the system handles user-defined responses in the PUSH APIs
Affected area: user-defined PUSH API
Prior to this update, the system retained the files created as a user-defined response for the PUSH API.
Starting with this update, the system automatically deletes the response files after API returns the call back to the caller.
Changes under the hood
We are now one step closer to introducing versioning in Etlworks Integrator.
Starting with this update, the system automatically captures all the changes in the Flows, Formats, and Listeners and stores them as versions in the database.
In the next update, we will introduce the UI, which will allow end-users to revert the specific Flow, Format, or Listener to any of the previous versions.
The versioning UI will also allow users to visually compare versions, just like in any modern version control, such as Git.
Please stay tuned!