10.37 Harmony Post-Release 2
Included in this post-release is an update to this Harmony component (June 28, 2021):
Google Drive Connector
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
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.
- Snowflake: Merge and Update activities added
Two new activities, Merge and Update, have been added to the Snowflake connector.
- 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.
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.
Added support to multiple organizations simultaneously
You can now access multiple organizations using different tabs.
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.
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.
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.HMACSHA1.Base64EncodedMessageand set both to
Null values in a JSON parsed successfully with
$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,
longdata types are now interpreted correctly and not as an
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.
The correct log messages are displayed
Clicking an item in the log now displays the correct message.