Release Notes

v3.1.3 - 2024-10-22

New Features
- Allow a sort property to be specified when selecting data from a database and writing to a file.

New Features
- Objects with errors are placed at the top of the list when emailing workflow status.
- Provide button to navigate back to SQL when generating a custom sql mapping with a syntax error.
- Add search screen to home page
- Add most recently updated maps by all users to home page
Bug Fixes
- Fixed bug in browse data screen that prevented scrolling when expanding object tree.
- Fixed bug that prevented connections used in email widgets from importing properly.

New Features:
- Google Analytics 4 Connector: A new connector has been added, enabling data retrieval from Google Analytics 4.
- Change Tracking Support for Sql Server: The platform now supports change tracking when sourcing data from Sql Server.
- Handling of Empty Delimited Files: Delimited files that are empty will no longer cause an error and will be skipped instead.
- "Create Empty File" Option: When generating a mapping that writes a delimited file, the new file target option "Create Empty File" is now available. By default, this option is disabled.
- Incremental Value: A new feature allows users to prevent the incremental value from changing in a mapping if the workflow fails.
- Reset Incremental Values at Runtime: Users now have the capability to reset incremental values for all mappings in a workflow during runtime.
- Updated Landing Page: The landing page has been updated to display the last 10 mappings that the user has worked on.
Bug Fixes:
- Improved Performance for Historical Log Files: Performance has been enhanced when fetching historical log files.
- Scheduling UI Improvement: The scheduling UI no longer re-enables a paused job upon saving.

Changes
- Kodda Scheduler will no longer allow multiple instances of a scheduled job to run at the same time. (Scheduled jobs must be resaved to take advantage of this)
- Kodda Restful API's.
  - Connections
    endpoint added to retrieve all available connections
  - Workflows
    endpoint to retrieve all workflows
    endpoint to retrieve workflow details
    endpoint to retrieve workflow execution history
    endpoint to run a workflow
    endpoint to export a workflow
  - Maps
    endpoint to retrieve all maps
    endpoint to retrieve map details
    endpoint to retrieve map execution history
    endpoint to run a mapping
    endpoint to export a mapping
  - Scheduler
    endpoint to retrieve scheduler status
    endpoint to retrieve all scheduled jobs
  - Tasks
    Endpoint to retrieve a tasks status
  - Import
    Endpoint to parse and list Import Objects
    Endpoint to import objects
- New Kodda function added for sql server extracts that leverage a binary value for incremental loads. When used Kodda will cast the stored value to a varbinary data type.
Bug Fixes
- Fix bug related to parsing queries with optionally defined columns.
- Fixed parsing of SQL Server queries that contain an OPTION clause. Kodda will now properly rewrite these queries to ensure the option is at the end of the query.
- Fixed a bug that prevented applying changes on file upload screen.
- Ensure queries are not split when push-down optimization is enabled and multiple extractors are defined.

Changes
- Read Only - A new user group has been added to support read only users who wish to view Kodda mappings and workflows.
- Emailing of Data Sets - Providers users with the ability to attach a dataset to an email task in a workflow.
- Performance improvements and improved memory management when using Redshift as a data source.
- Improved loading to postgres targets.
- PGBouncer - When PGBouncer is enabled logs will be written to the syslog.
Bug fixes
- Fixed bug when user selects to load Null Values as an empty string and column is part of a primary key.

Changes

Reduce number of API calls required to identify available files in S3
Performance improvements when loading and generating mappings from S3 delimited files.
Addition of hotkeys to workflow screen to improve UX. (Alt+X to disable/enable components in a workflow)
Support added for multiple LDAP servers in setup.cfg
New mapping run-time parameter to enable failing a map when 0 records are read from the source.
Auto-refresh map and workflow operation screens
Allow viewing connection table and testing connections for non admin users.

Bug fixes
- Update pgbouncer default config to allow SSL connections
- Bug Fix to object export - Allow unicode characters to be exported from table and column comments.
- Bug Fix to Workflow engine - Fix bug for workflows with multiple dependency paths and a parent task in one path fails, while the second path is still running.

Updates to workflow screen
- Workflow audit history attributes have been added to east pane.
- Added highlighting of objects on mouse over to better differentiate the mouse being over a workflow widget vs the workflow canvas.
- New click through capabilities on workflow items. (I.e. click to drill to map or nested workflows).
- Update to email notifications. Disabled tasks and objects are now included in workflow status emails to improve visibility into steps that were disabled at runtime.
Mappings
- Reduced the number of database calls when generating or updating a mapping.
- Set default file size when delivering data to Redshift and Snowflake. This will reduce reliance on developers having to set this parameter.
Inclusion of PG_BOUNCER:
- PG_Bouncer is now included as part of the default build.This optional component can be enabled by adding the parameter pg_bouncer = enabled to the MetaDB and secDB sections of the setup.cfg file.

Last updated 2 months ago