Skip to main content

5.11 Release Notes

Release date

Cinchy version 5.11 was released on June 5th, 2024.

Upgrade guides​

Introducing Cinchy Automations​

Cinchy Automations is a platform tool that allows users to schedule tasks. To reduce the time and manual effort spent on reoccurring tasks, you can now tell Cinchy to perform the following automatically:

  • Executing queries
  • Triggering batch syncs
  • Extracting and running a code bundle, which can contain any number of queries or syncs needed to perform a task.

Using the Automations capability, you can also build an automation that performs multiple tasks in sequence (known as "Automation Steps") to allow for more complex use cases.

You can find the full details on this powerful new capability here.

New Connector​

  • A new destination type has been added to the Connections Experience. The "File" destination provides the option to sync your data into Amazon S3 or Azure Blob Storage as a delimited file.

For the full details of the "File" Destination, please review the documentation here.

General​

  • Nuget package updates. [1]
  • Updated Npgsql to version 7.0.7.
  • Security fixes.

Enhancements​

  • Removed infinite scrolling from tables and in link column dropdowns. [2]
    • Tables now have pagination and will show 250 records per page. This affects both the regular table view as well as the tables that populate in the query builder view.
    • Link Column dropdowns will display the first 100 records. Users can type in the cell to further filter down the list or search for records beyond the first 100.
  • You can now use Personal Access tokens in the following scenarios:
  • Added UTF-8 encoding to the Saved Query endpoint.
  • The Kafka configuration validation for the Connections WebApi and Worker has been improved such that applications will not start if any Kafka config value is invalid.
  • When loading a Form, the sidebar navigation will now correctly highlight the appropriate/currently selected section.
  • To help reduce possible system load, there is a new user-configurable limit on how many CDC event queries may run concurrently.
    • The "CdcQueryConcurrencyIndex" value is defaulted to 5 concurrent queries and can be configured in the Event Listener AppSettings.json. 5 is suitable for many environments.
    • If the load associated with Change Notifications is impacting system performance, consider lowering this value to prioritize other work, at the expense of change processing. Alternatively, provision faster hardware.
    • If Change Notification processing is taking longer than desired, consider increasing this number to allow more concurrent processing, depending on the capacities of your particular system.
  • Link Column drop downs will no longer return null values.
  • When using the "Sort" capability on a table, you can now specify whether you want the data to return nulls first or last. [4] Note that selecting either of these options will have an impact on the performance of the table. Leaving the option blank/unspecified will mitigate the impact.


Null Sorting

  • You are now able to configure Cross-Origin Resource Sharing (CORS) for the Connections Experience.
    This configuration allows the Connections Web API to become reachable by applications running on domains other than that which hosts your Connections Experience, and is especially useful for building projects/applications on Cinchy.
    • This value can be configured in the Connections WebApi > appsettings.json > "AppSettings" field by inputting an array of strings, where each string is a domain. Example:
    "AppSettings": {
      "CorsOrigins" : ["a.com", "b.com", "c.com"],
    }
  • To improve platform performance by limiting the amount of data that must be read, table views will no longer query for columns that are not represented within the context of that specific view.
    • For example, if the table contains the columns [Name], [Age], and [Location], but the view only calls for [Name] and [Age], then the [Location] column will no longer be queried for by the platform.
  • Snowflake Driver was updated from 2.1.5 > 3.1.0, in part to allow for the use of a PrivateLink as the Connection String when using Snowflake as a source.

Bug Fixes​

  • The Active Jobs tab in the Connections UI will correctly show the currently running jobs. [5]
  • Fixed a bug that was preventing the Update and Delete actions from working in Batch Delta Syncs. [6]
    • Additionally, if an invalid Action Type column value is provided when configuring a Delta Sync, the Connection logs will now contain more detailed warning messages. These log messages will include information about the record with the incorrect action type. For example: "Invalid sync action type ActionTypeValue in column ActionTypeColumnName"
      • Note: Valid sync action types are 'Insert', 'Update', 'Delete'. Anything else is invalid.
  • Fixed an invalid CQL bug in the Query Editor UI when using FOR JSON PATH when building queries in PGSQL. [7]
  • Fixed an issue when listener/worker would extract the wrong Idp Url during the simultaneous startup of Cinchy Web & listener/worker. [8]
  • Long running batch jobs will no longer intermittently fail to complete.
  • Fixed a bug where the platform was not saving records where changes were made immediately after record creation.
  • IS NULL checks with a multiselect field or parameter will now yield the expected result for empty values.
  • Adding a filter expression to a Link column via the UI will no longer cause a number conversion error. [9]

Change Log​

General​

Enhancements​

  • [2] Upgraded Handsontable.js version from 0.31.2 > 14.1.0.
  • [3] Added OAuth2Introspection authentication and "Introspection" Authorization method to all connections controllers to allow for both Bearer and PAT auth options.
  • [4] CASE expression sorting is skipped for the default/unspecified sort order.

Bug Fixes​

  • [5] The elapsedTime property type has been changed from string to long.
  • [6] For Delta syncs, added filling of Update and Delete queues.
  • [7] Fixed the appending ordering onto FOR JSON PATH queries in PGSQL.
  • [8] Added Idp Url validation and Retry policy, with up to three attempts. The application will shut down if all three attempts fail.
  • [9] Removed the int casting for link lookup Table ID.