Skip to Content

10.37 Harmony Release Notes

10.37 Harmony Post-Release 2

Included in this post-release is an update to this Harmony component (June 28, 2021):

  • Google Drive Connector

Fix

  • Google Drive Connector List Files activity updated
    An updated Cloud Studio connector for Google Drive is now available to use with agents version 10.1 or later, with the List Files activity updated to resolve an issue with unrecognized fields. The updated connector can be accessed from the Cloud Studio design component palette and will automatically be downloaded by an agent as required.

10.37 Harmony Post-Release 1

Included in this post-release is an update to this Harmony component (June 22, 2021):

  • Microsoft Dynamics CRM Connector

Fix

  • Microsoft Dynamics CRM Connector updated to use Organization Service URLs
    A new version of the Jitterbit CRM REST connector for Microsoft Dynamics 365 is now available that uses a server's Organization Service URL. The new version can be downloaded from the Harmony Portal Downloads page. Once the new connector has been installed on a Private Agent, existing projects will need to have their configurations updated to use the Microsoft Dynamics 365 server's Organization Service URL in place of the Discovery Service URL and then be redeployed.

10.37 Harmony Release

Harmony Portal, Private Agents, and Sandbox Cloud Agent Group

The 10.37 release date is by region:

  • APAC: 10 June 2021 AEST, June 9, 2021 PDT

  • EMEA: 10 June 2021

  • NA: June 14, 2021

Included in this release are updates to these Harmony components:

The Sandbox Cloud Agent Group and cloud applications accessed through the Harmony Portal will be updated to 10.36 at the time of the release. Design Studio and Private Agent installers will be available in each region as of the conclusion of each region's release.

As of June 1, 2021, Design Studio and Private Agent version 10.19 have reached end of life and are no longer supported. We recommend that all users of these (and earlier) versions upgrade to the latest versions as soon as practicable.

New Features

Cloud Studio

  • Snowflake: Merge and Update activities added
    Two new activities, Merge and Update, have been added to the Snowflake connector.

Changes

Agents

  • Important PostgreSQL database upgrade notice
    The Linux Private Agent version 10.37 upgrades the PostgreSQL database to version 9.6. When upgrading a Linux Private Agent from a pre-10.37 version to a version that is 10.37 or later, the PostgreSQL database will be reinitialized. This upgrade will recreate the database on your Private Agent and your data will be recovered during this upgrade process. After the upgrade, any backups created using an earlier PostgreSQL version will not be compatible. The upgrade process can take up to 30 minutes depending on the number of projects and the size of the environments associated with your Private Agent group. Any pending jobs will be put in a pending queue to run after the upgrade is complete. This upgrade does not involve the Windows Private Agent.

Enhancements

Agents, Design Studio, and Cloud Studio

  • NetSuite: Support for WSDL version 2021.1
    We have verified support for NetSuite WSDL version 2021.1 using agents 10.26 and higher.

Harmony Portal

  • Added support to multiple organizations simultaneously
    You can now access multiple organizations using different tabs.

Design Studio

  • Increased number of HTTP retries to a maximum of 50
    When configuring an HTTP source and HTTP target in Design Studio, you can now choose up to 50 retries with a five-second interval.

Cloud Studio

  • Email: Support for IMAP connections added
    Added support for configuring an IMAP connection in addition to an SMTP connection.

  • RabbitMQ: Added support for the AMQP standard
    The RabbitMQ connector now supports Advanced Message Queuing Protocol (AMQP), a protocol for business messaging. Using AMQP requires a secure connection and CA-certified certificates.

  • Preview mode now supported for all transformations
    You can now use sample file preview for all transformations, with the exception of Salesforce, ServiceMax, NetSuite, and Database connector operations.

  • Enhancements to UI features and behaviors
    We continue to make enhancements to the Cloud Studio UI and functionality including item selection and right-clicking actions.

Fixes

Agent, Cloud Studio, and Data Studio

  • FTP: SFTP security option now uses correct authentication
    When using both a private key and a username/password combination with SFTP security, the connection uses both authentication methods.

Agent

  • HMAC-SHA1 Generator plugin now handles special characters
    The HMAC-SHA1 Generator plugin can now use special characters such as carriage returns. Use the parameters $Jitterbit.HMACSHA256.Base64EncodedMessage and $Jitterbit.HMACSHA1.Base64EncodedMessage and set both to true.

  • Null values in a JSON parsed successfully with JSON.parse()
    When parsing a JSON in a Jitterbit JavaScript using JSON.parse(), null values no longer cause an error, and the JSON processes successfully.

Cloud Studio

  • Database connector: $ allowed at the end of a Microsoft Excel tab or table name
    When inserting data into a Microsoft Excel spreadsheet or workbook, a $ at the end of a tab or table name no longer causes an error.

  • Database connector: Spaces can now be used in a table name
    Tables with spaces in their name can be used in the without errors with the Database connector.

  • Snowflake: Mixed case now allowed for database, schema, and table names
    We now encode the names of databases, schemas, and tables, which mixed case in the names.

  • Script changes preserved after exiting expanded mode
    Any script changes made in the script editor's expanded view are preserved on exit and the last save time is updated in the transformation.

  • Project variables now persist
    In prior releases, project variables were sometimes removed randomly. This no longer occurs.

  • Data types interpreted correctly when importing a file
    When importing a WSDL, JSON, XML, or CSV file, long data types are now interpreted correctly and not as an integer type.

  • A test of the connection is successful when using hidden project variables
    Testing a connection with hidden project variables now succeeds.

  • Resolved user conflict errors when a single user is editing transformations and values
    You no longer see user conflict errors when providing custom values to fields, editing mappings in transformation, or with hierarchical schema editing.

Management Console

  • The correct log messages are displayed
    Clicking an item in the log now displays the correct message.