CloverETL 4.4.0 (Milestone 1)

For the latest production release, please go to CloverETL 4.3 release notes

CloverETL 4.4 Milestone 1 adds further improvements to Salesforce connectivity, including UI enhancements and new SOAP based components with support for Attachments and complex SOQL queries.

We're also looking at broadening Server automation capabilities with Remote File Listeners (starting with FTP support) and we're adding monitoring for Server listeners in general.

About this release: This is a milestone release we publish as a preview of the upcoming 4.4 version. You can expect production-ready release in December 2016. Milestone versions is not recommended for production upgrade. However, some clients successfully enjoy running our milestone releases without trouble.

Released Oct 18, 2016
  • Milestone
Recent Important Releases
4.4.0-M1 Oct 18, 2015
4.3.0 Sep 8, 2016
4.2.1 Aug 18, 2016
4.3.0-M2 Aug 9, 2016
4.3.0-M1 Jun 30, 2016
4.2.0 Jun 9, 2016
4.1.4 Jun 1, 2016
4.1.3 Apr 6, 2016
4.0.8 Dec 8, 2015

See all releases

Try it yourself


New features

Salesforce CRM Connector supports Attachments

We're introducing a new component, SalesforceWriter, a SOAP API based writer. Although very similar to SalesforceBulkWriter (which uses Bulk API) the new component supports uploading Attachments and uses less API calls for single records or small batches. SOAP is slower and allows for smaller batches so for large data sets it is a better choice.

Remote File Listeners

CloverETL Server Corporate and Cluster only

You can now watch not just local folders and files, but also remote FTP folders.

File Event Listeners now have local/remote option that allow you to configure remote connections and set up watched folders just like you're used to for local files.

Reacting to Task Failures

CloverETL Server Corporate and Cluster only

Ever needed to configure a reaction (email alert, cleanup job flow) in case a Server listener fails?

In this milestone we're instroducing new "Task Failure" listeners - new type of listener that can watch its peers and trigger an action if they fail.

You can set up multiple Task Failure listeners, each one either watching a specific listener or all events of a certain type (e.g. all failures of any File Event Listener).

Amazon Redshift Driver built-in

You'll find Amazon Redshift driver in the DB connection configuration dialog out-of-the-box now. Amazon recommends using this driver instead of the Postgres driver.

Installation/Upgrade Instructions for CloverETL 4.4

To help you with installation or upgrading to this version, we've prepared a simple checklist for you:

Before You Upgrade

  • Be sure to check "Compatibility" notes for ALL intermediary releases. We mark all changes that can potentially alter the function of your existing transformations by "Compatibility" label to make it easier for you. You can safely ignore most of them as we try hard to keep as much backwards compatibility as we can. There's a comprehensive list of all releases that will help you get the information quickly.
  • Upgrade Designer and Server together. We always release Designer and Server together under one version. It's highly recommmend to upgrade Server and Designer at the same time. Although using different version of Designer to connect to Server might work, it is not generally supported.
  • There are no incremental patches. We don't release incremental patches. Every upgrade is in fact a full installation that, if installed over older version, will update whatever necessary in your workspaces, sandboxes and databases as needed automatically .
  • Don't forget to backup. Although none of the above upgrade steps requires explicit backup, we recommend you always back up your work. The upgrade will keep all your transformations, jobflows and configurations safe. However, as a good word of advice, it never hurts to have a backup.

Designer Upgrade

  • Download the latest version by logging into your customer account. If you no longer have access there, no problem. Click here to recover your password or contact our CloverCARE Support.
  • Install new version of Designer. You can install Designer over your existing installation. The process will automatically clean up the old version. Don't worry, you will NOT lose your workspaces, graphs and transformations. However, if you installed some additional plugins to Designer (Eclipse plugins) you might need to reinstall them, Eclipse should automatically help you do that. When you start the application, point it to your existing workspace directory. With some major releases we may notify you about upgrading the workspace to the latest version. In such cases you won't be able to use the workspace with previous versions. Thus, be sure to upgrade all Designers if you're sharing the workspace.
  • Activate the product on first start. We issue new license keys with every major version (i.e. from 4.2 to 4.3). We automatically renew the keys for you. Just go to the download area again and copy/paste the license key from there. If you can't find the latest keys, you will need to renew your product maintenance.

Server Upgrade

  • Download the latest version by logging into your customer account. You'll find Server in the same list as Designer downloads. If you no longer have access there, no problem. Click here to recover your password or contact our CloverCARE Support.
  • Plan for downtime. Upgrading the Server requires downtime, so plan your upgrades in advance. If you're running multiple environments, upgrade non-production installation first and run all your checks there first.
  • Follow step-by-step Server Upgrade Guide. We've prepared detailed instructions on how to properly shut down Server and install a new one. Server will upgrade its database and sandboxes from any previous version automatically.
  • Activate the product on the login screen of Server Console. The license key changes with every major version (i.e. from 4.2 to 4.3) and we automatically renew the keys for you. Just go to the download area again and copy/paste the license key from there.

Detailed list of improvements and fixes in 4.4.0-M1

Salesforce CRM Connector [ See All | Hide All ]

New SalesforceWriter component based on Salesforce SOAP API New Feature CLO-9172 4.4.0-M1
SOQL editor Improvement CLO-9428 4.4.0-M1
SOQL syntax highlighting Improvement CLO-9429 4.4.0-M1
Inline edit SOQL in component editor Improvement CLO-9328 4.4.0-M1
SalesforceWriter: upload attachments to Salesforce via specified path Improvement CLO-9492 4.4.0-M1
SalesforceWriter: non existent file when uploading attachments is reported on reject port Improvement CLO-9538 4.4.0-M1
SalesforceBulkWriter: warning if trying to use unsupported upload of attachments Improvement CLO-9502 4.4.0-M1
Sort Salesforce object fields Improvement CLO-9550 4.4.0-M1

Amazon Web Services [ See All | Hide All ]

ParallelReader support for Amazon S3 New CLO-9500 4.4.0-M1
Redshift JDBC driver is now bundled with CloverETL (Replaces Postgres for Redshift use) New CLO-7143 4.4.0-M1

Remote File Event Listeners   [  See All  |  Hide All  ]

File event listener for remote locations New Feature CLO-3934 4.4.0-M1
UX improvements in file listener form Improvement CLO-9476 4.4.0-M1
Listener for failed listener New Feature CLO-9473 4.4.0-M1

Other improvements [ See All | Hide All ]

Possibility to omit XML declaration in XMLWriter for easier writing of XML fragments New CLO-9465 4.4.0-M1
Make variable tooltip work for records Improvement CLO-9412 4.4.0-M1
Improved formatting of CTL in graph xml for additional components Improvement CLO-9244 4.4.0-M1
Data inspector - search improvement Improvement CLO-9201 4.4.0-M1
File URL dialog: explain discrete/source/stream port writing or reading Improvement CLO-8973 4.4.0-M1
Higher priority cluster node selection Improvement CLO-9590 4.4.0-M1
ParallelReader support for S3 Improvement CLO-9535 4.4.0-M1

Fixes [ See All | Hide All ]

Fixed: Automatic metadata propagation makes Designer unresponsive Fix CLO-9097 4.4.0-M1
Fixed: UniversalDataReader very slow when using wildcards in archives Fix CLO-6584 4.4.0-M1
Fixed: Wildcard resolution in readers matches directories Fix Compatibility CLO-9619 4.4.0-M1
Fixed Designer performance drop for graph with many subgraphs Fix Improvement CLO-9466 4.4.0-M1
Implicit metadata are not persisted any more Fix Improvement CLO-9530 4.4.0-M1

ETL Developers (This item is most useful for developers; it either brings new functionality for transforming data or brings optimizations)

Administrators (This item is an improvement or feature that will help setup, install, administer and manage the application)

Support (This item helps staff supporting the production operation to identify potential problems or avoid such)