Celigo platform 2024.7.1 release notes

Tom Santiago

Updated October 15, 2024 00:13

What's new

Celigo AI for transformations

Designed to streamline and accelerate the development process across a variety of integration scenarios, Celigo AI for Transformations 2.0 will bridge knowledge gaps and significantly reduce the time required to build complex transformations.

Access the Celigo AI panel within the transformations window. Whether you are a technical expert or a business user, you can either simply provide a prompt or use native auto-transform functionality and receive assistance to complete your tasks efficiently.

Celigo AI for transformations excels in multiple transformation scenarios, including (but not limited to):

Rows to record: Transform multiple rows of data into a structured record.
Record to rows: Break down a single record into multiple rows.
Rows to rows: Convert rows of data to a different format or structure.
Field modifications: Modify specific fields within the source data to generate a new, transformed record.

Streamed responses from Knowledge bot

As soon as you ask a question, the Knowledge bot will start delivering its response in real time. You’ll get your answer in a dynamic, ongoing stream, keeping you informed from the first moment and making the interaction feel more like a human conversation.

Celigo AI support for Azure Synapse connector

Use Celigo AI to convert plain language into SQL queries, streamlining Azure Synapse connector configurations. Simplify import/export setups and boost configuration efficiency.

This enhancement allows a broader range of individuals to leverage data without the need for complex SQL logic, significantly improving productivity, minimizing errors, and accelerating data-driven insights.

Snowflake bulk load capabilities

Effectively manage larger datasets with Snowflake’s bulk load capabilities using local files, thereby reducing the time and resources needed for data transfers. By providing more control over the data ingestion process, as well as a more scalable approach to accommodate growing volumes of data, this feature makes it easier for engineers and database administrators to manage data workflows, while business users are able to access data more quickly for analysis.

Note: Snowflake bulk load via file does not support variant columns; please use batch inserts for these.

Filter “Your existing flow steps” by connection

Using the option, “Optionally filter by connection,” you can narrow down flow steps based on their associated connections, making it simpler to find exactly what you’re looking for, especially when dealing with multiple resources tied to different applications.

We’ve also updated the user interface for more clarity and direction:

The label “Create from scratch” now reads “Create flow step.”
The note for your existing flow steps has been changed from “Clone an existing flow step from your account” to “Clone or reuse an existing flow step from your account.”
Just like the existing connection field, you can type the name of the connection in the filter field to quickly find what you need without scrolling through a list.

Filter your existing flow step 1

Filter your existing flow step 2

What's enhanced

Automatically recover rate limit errors for imports where oneToMany is set

Auto-recovery is now enabled for operations involving connections in exports, lookups, and imports, regardless of whether the one-to-many configuration is used. integrator.io will automatically detect and recover from these errors, minimizing downtime and reducing the need for direct user action.

This feature operates in the background, providing a seamless experience without any additional setup. You can continue with your tasks confidently, knowing that rate limits will be managed more effectively.

Windows Server 2012 R2 reaching end of support

Starting November 6th, 2024, the Celigo on-prem agent will no longer support Windows Server 2012 R2. This decision aligns with Microsoft’s plans to end support for this operating system, details of which can be found in Microsoft's Lifecycle Policy announcements.

To ensure uninterrupted service and compatibility with the latest Celigo integrations, it is imperative that users of Windows Server 2012 R2 upgrade to a more current version of Windows Server before November 6th, 2024. The Celigo Product Team will be sending direct reminders via email over the coming months, and if you require assistance with the upgrade process, don’t hesitate to contact Celigo support or your trusted CSM.

What's fixed

Async helper XML errors from the Amazon – NetSuite integration app weren’t reflected in debug logs.
The XML parser Advanced field editor failed to detect invalid XML characters when Parse strategy was set to Automatic.
The Clone Amazon – NetSuite integration app template corrupted the copy and dropped record types, connections, and flow mappings.
Manual token-based auth connections to NetSuite did not allow you to set the required environment setting.
Filter scripts couldn’t use flow-level custom settings.

Help Center updates

See Celigo platform connectors 2024.7.1 release notes for connector updates.