Release Date: 12 December 2020

OneCloud will be making platform enhancements, Saturday, December 12, 2020, from 11 am to 1 pm EST. There will be no downtime for this release.

Platform Enhancements

Integration Studio - Chain Templates

Chain Templates are now available in OneCloud Integration Studio. Chain Templates are a powerful way to streamline and standardize the development of Chains.

Read the Docs

Connections between nodes within an Integration Studio Chain can be more easily created. The interface has been enhanced so connections can be dropped anywhere on a target node.

Data Prep - Excel Formula Field Selector

The Excel Formula Transformation now eliminates the need to type in a field name and instead simply select a field. This enhancement improves efficiency and reduces potential formula errors.

Data Prep - Difference Viewer

The Data Prep user interface now allows a user to preview the results of the currently selected Transformation and the immediately proceeding Transformation. The enhanced preview no longer requires the prior transformation to be selected to visualize the results of the transformation. This functionality can help streamline the creation of a new transformation which may be dependent on previewing the result of the prior transformation.

Additionally, the changes indicator now displays textual information rather than symbols to highlight changes to the Pipeline data due to transformations added to the Pipeline.

Connectors (BizApps)

Tabular Transformation

The Tabular Transformation BizApp now provides a Pivot and Unpivot Command, which can be used to transpose data from rows to columns or columns to rows.

Read the Docs

File Utilities

The File Utilities BizApp now includes a Stack Files Command, which can be used to stack asymmetric files. This varies from the Tabular Transformation BizApp Stack Files Command, which requires that the files being stacked have an equivalent number of fields across all files being stacked.

Read the Docs


New Chatbot

OneCloud has deployed a new chatbot that leverages improved machine learning and will seek to help answer questions in a more efficient and timely manner. As part of this deployment, the knowledge base has been migrated to a new URL ( but will continue to be accessible from the support portal by clicking on the Knowledge Base link. Please update any bookmarked links for specific articles, as links to individual articles will no longer be reachable. Also, please be aware that the Discussion Forum articles have been migrated to this new location.


The following defects are fixed in this platform update:

  • Runtime Variables not available to Workspace Resources

  • Error extracting HFM system accounts

  • File trigger not disabled when disconnected from a Chain

  • Iteration failing on a Windows deployed GroundRunner

  • Run Chain Event still runs even when skip conditions are met

  • Cannot set time for schedules when using a Safari browser

  • JSON iteration not working properly

  • Unable to download OAC log files from Command with Warnings

  • Phantom connection created when promoting Chains

  • Data Prep - Excel Formula error on fields with multiple spaces

  • Data Prep - Decimal places not respected in an Excel formula result

  • Data Prep - Unable to upload sample file with special characters in the header


Many of our recent changes come from user insights, so please don't hesitate to drop us a line at!

Did this answer your question?