Customer Portal

With CloverDX 6.1 we are continuing to improve CloverDX’s usability for business users. In this release, we focused on data quality and the ability to process large data volumes while still remaining in control of your data.

We’ve added the ability for Wrangler users to validate their data using built-in as well as custom validation rules. This way you can easily validate emails, credit cards, phone numbers or any other values as needed.

Wrangler then collects all information about invalid records at the end of the transformation and allows users to see the reports of validation errors to help them correct the data.

You can also easily share jobs you created in Wrangler by exporting them right from your My jobs table, sending the export via email or even messaging app. The recipient can then easily import the job including data sources and their configuration.

We’ve also implemented additional transformation steps to make it easier for Wrangler users to manipulate their data and made many improvements to overall user experience when editing Wrangler jobs.

With CloverDX 6.1 we’ve finished our transition to Java 11 and Java 8 is no longer supported in any application stack.

New features in 6.1

Data validation in Wrangler

Wrangler now allows you to validate your data using new built-in as well as custom rules. You can easily validate emails, phone numbers, credit cards or even custom data using formulas to verify that your transformations work with valid values.

Results of all validations performed by Wrangler – your own rules as well as built-in rules automatically verified by Wrangler – are collected and available for you to inspect. You can see high-level summary reports or even download full details in a “reject file” in CSV or Excel format.

The reject file contains details which allow you to determine why certain row was rejected and follow up on that either by modifying the job to handle the data or by working with source system owners to help them correct their data.

Validation summary report showing rejected rows statistics.

New steps in Wrangler

In this release we added several new steps that help you manipulate your data. These steps include date manipulation (Date add/subtract, Date difference and Get part of date) as well as new steps to work with text data (Normalize whitespaces, Propercase and Mask text).

The Mask text step is the first step from our data anonymization collection which we’ll be expanding in the future. It allows you to anonymize sensitive data by masking parts of your data with mask characters (usually star ‘*’ or ‘x’). It allows you to select which characters to anonymize and produces results that are still recognizable but no longer disclose private information:

Phone numbers before and after masking

We’ve also made many improvements to other steps – for example, Delete column(s) step can now delete any number of columns at once.

 

Sharing your work in Wrangler

To share the jobs that you created in Wrangler, you can use our new Export job functionality which is accessible from job’s context menu in My jobs table.

Exporting a job from its context menu on My jobs screen

You can then easily send the exported job and the recipient will be able to import everything including data sources and their settings.

OAuth2 connections in libraries

OAuth2 connections included in libraries are now shown in library configuration screen in Server Console after the library is installed:

OAuth2 connection settings

This allows the Server admin to authorize the connection right away in the Server without needing to use the Designer which in turn makes library installation much easier and faster.

This is especially useful when you are publishing data in Data Catalog where you can have quite a lot different connections to variety of cloud APIs.

 

Smaller updates

Platform updates

With CloverDX 6.1 CloverDX Server no longer supports running on Java 8. Following table lists the supported platforms for running CloverDX Server:

  • Apache Tomcat 9 + Eclipse Temurin JDK 11
  • VMware tc Server Standard 4.1 with Tomcat 9 + BellSoft Liberica JDK 11 LTS
  • Red Hat JBoss Web Server 5.4 + Red Hat OpenJDK 11

 

 

To help you install or upgrade to this version, we've prepared a simple checklist:

Before You Upgrade

  • Be sure to check the "Compatibility" notes for ALL intermediary releases. We mark all changes that can potentially alter the function of your existing transformations with a "Compatibility" label. Typically, you can safely ignore most of them, as we try hard to keep as much backwards compatibility as possible. 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 a single version. It's highly recommended to upgrade Server and all Designers at the same time. Although using different versions 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 the older version, will automatically update whatever is necessary in your workspaces, sandboxes, and Server databases as needed, no user data will get overwritten.
  • 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 lost your credentials or no longer have access there, click here to recover your password or contact our CloverCARE Support.
  • Install the 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—be sure to upgrade ALL Designers at once if you're sharing the workspace.
  • Activate the product on first start. You will need a new key as we issue new license keys for every new major version (e.g. from 4.9 to 5.0). If you're on our maintenance program, we automatically renew the keys for you. Just go to the License Keys again and copy/paste the license keys from there. If you can't find the latest keys, please contact us 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, click here to recover your password or contact our CloverCARE Support.
  • Plan for downtime. Upgrading Server requires downtime, so plan your upgrades in advance. If you're running multiple environments, upgrade the non-production installation first and run all your tests there first.
  • Follow our 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. Server requires new license keys with every major version (e.g. from 4.9 to 5.0) and we automatically renew the keys for you. Just go to the License Keys again and copy/paste the license key from there.

 

Release Compatibility/Upgrade notes, Features & Fixes Published Download

Error Handling in Wrangler - Rejects

New step: Validate with formula
CLO-26407 Improvement
New step: Validate phone number
CLO-26445 Improvement
New step: Validate email
CLO-26424 Improvement
New step: Validate credit card
CLO-26444 Improvement
Implement dialog for rejected rows
CLO-26464 Improvement
Append validated values at the end of the error message
CLO-26461 Improvement
Add ability to store and display invalid records in Wrangler ("rejects")
CLO-26406 Improvement

Wrangler Improvements

Wrangler notifications
CLO-25227 Improvement
Wrangler delete step should not fail when column is not present in data
CLO-26225 Improvement
Show errors in My Jobs table in the dialog
CLO-26465 Improvement
Show error message in editor of failing steps
CLO-25534 Improvement
Scroll to changed columns automatically
CLO-26063 Improvement
Save scroll position in step list
CLO-26501 Improvement
Reorder steps in steps sidebar action
CLO-26205 Improvement
New step: Mask text
CLO-26598 Improvement
New Wrangler step: Proper case for string columns
CLO-26222 Improvement
New Wrangler step: Clean whitespaces
CLO-26223 Improvement
My Jobs table improvements
CLO-26463 Improvement
Multiselect for Delete column step
CLO-26224 Improvement
Make the step panel resizable
CLO-26282 Improvement
Libraries logos in catalog too small
CLO-26354 Improvement
Keep custom column width after refresh of the table
CLO-25533 Improvement
Improve visualization of warning and aborted job
CLO-26026 Improvement
Improve usability of error cells
CLO-25810 Improvement
Improve source caching
CLO-25868 Improvement
Improve errors in check config
CLO-26073 Improvement
Export and Import Job backend
CLO-26206 Improvement
Empty screen, when user deletes all columns
CLO-25877 Improvement
Duplicate Step action
CLO-26204 Improvement
Duplicate Job action
CLO-26202 Improvement
Date related steps
CLO-25698 Improvement
Connector should open on click on the whole connector row
CLO-25902 Improvement
Confirmation dialog for data source change
CLO-25696 Improvement
Align number values to right in source preview
CLO-25579 Improvement
Change empty screen on My jobs page
CLO-26431 Improvement

Libraries Improvements

Run initialization job from disabled library
CLO-25830 Improvement
Permissions for library sandboxes
CLO-25541 Improvement
OAuth2 connection for libraries
CLO-26319 Improvement
Add owner and DS description to library overview
CLO-26369 Improvement
Admin should be able to use data connectors
CLO-25953 Improvement

Miscellaneous

Event Listeners Showing License Error Despite Valid License
CLO-21403 Improvement
Display tracking of wrangler jobs in execution history
CLO-26221 Improvement
Job Inspector for wrangler generated subgraphs
CLO-26297 Improvement
Disable server Audit log by default
CLO-26359 Improvement
CTL function properCase
CLO-26589 Improvement
CTL function normalizeWhitespaces
CLO-26588 Improvement

Security

Poor handling of account password change
CLO-24697 Security
Change password after first-time login of Wrangler user
CLO-26005 Security
CVE FIX - Update Sqlite jdbc driver to 3.42.0.0
CLO-26562 Security
CVE FIX: Update axis2 to version 1.8.2
CLO-26293 Security
CVE FIX - Upgrade parquet-hadoop to v1.13.0
CLO-26165 Security
CVE FIX - Upgrade Mime4j Core to v0.8.9
CLO-26164 Security
CVE FIX - Upgrade mysql-connector-java to v8.0.33
CLO-26163 Security
CVE FIX - Upgrade Apache CXF libraries to v3.5.5
CLO-26162 Security
CVE FIX - Upgrade SnakeYAML to v 2.0
CLO-26161 Security

Fixes

JNDI conn in parallelized graph checksConfigs for JNDI declaration in Core configuration
CLO-26241 Fix
SpreadSheetWriter slow with formulas and overwrite moded
CLO-25655 Fix
JSONExtract - error on extracting subtree to variant
CLO-25302 Fix
Invalid column date format makes job uneditable
CLO-25995 Fix
Designer - offline urls lose ability to reconnect when all server projects get deleted
CLO-26392 Fix
ExecuteWranglerJob documentation is not displayed in the Designer
CLO-26189 Fix
Header in editor overlap index column
CLO-26025 Fix
Wrong error message in "Create a new job" dialog
CLO-26010 Fix
User without execute permission to connector can use it in job (as a source)
CLO-25954 Fix
Suspicious log entry when installing library
CLO-25520 Fix
Confusing Secure Parameter warning
CLO-19001 Fix
Preview endpoint should return 404 when user doesn't have read permission
CLO-25972 Fix

Compatibility

Drop support for Java 8 deployments for CloverDX Server
CLO-23806 Compatibility
June 27, 2023 Documentation Download CloverDX 6.1 6.1.0
  • For Developers (Improvements most useful for developers bringing new functionality or optimizations in data transformation and orchestration)
  • For Administrators (Improvements or features that will help setup, install, administer and manage the platform)
  • For Support (Helps staff supporting the production environment to identify and escalate potential problems or avoid such)
  • For Security (Improvements and changes relevant to security focused staff – sys admins and developers alike)