Skip to main content

Release Notes

Below you will find History of changes made to Data Synchronisation Studio and Ouvvi from 2023 (Version 6). For releases prior to version 6 please see our older release notes.

2023​

6.0. 3260 - 09/06/2023​

  • FEATURE: Can now connect to Ouvvi Projects from Data Sync
  • UPDATE: Back end now uses .NET Standard in preparation for .NET Core and uses the framework .NET V4.8
  • UPDATE: Connector structure has been re-organised in preparation for .NET Core
  • OUVVI: UI changes made, navigation at top and overlays to improve usability.
  • OUVVI: Connections support OAuth and can be viewed, added and edited from the UI (rather than only being uploaded).
  • OUVVI: Forms based authentication now available with Azure AD support
  • OUVVI: IP Filtering now possible
  • OUVVI: Optimization of back-end processes

6.0. 3274 - 20/07/2023​

  • UPDATE: Actipro Library to V23.1.1
  • FEATURE: Add LOOKUP ARRAY function to Calculated Columns
  • UPDATE: Ignore the Name attribute in Active Directory since you cannot write to it.
  • FEATURE: Create Scheduled Task from Run Tool menu.
  • UPDATE: Change the Installer to use InnoSetup
  • FEATURE: New JSON API connector
  • FEATURE: OUVVI Upgrade Ouvvi V4 to V6.
  • CHANGE: OUVVI Update DB Schema and add constraints to Configuration and Registry Tables.
  • FIX: OUVVI prevent infinite cache of Graph EMail credentials.

6.0. 3284 - 11/08/2023​

  • FEATURE: Add OpenFile action to JSON API connector.
  • FEATURE: Add AuthorizationHeader authentication option to JSON API Connector.
  • FIX: Authentication in LOOKUP from JSON API Connector
  • UPDATE: Validate OAuth configuration before authorization and return appropriate error message.
  • FEATURE: Enable Editing Connection Properties directly from Connection Library Tree View.
  • FEATURE: Capture Exceptions from Data Sync and re-throw to enable more detailed exceptions from Connector on different thread.
  • FIX: Loading referenced Assemblies from Connector Attributes to prevent exception from Dynamic/Project Automation.

6.0. 3286 - 17/08/2023​

  • FIX: Run Tool browse button to *.dsrun Run Project file.
  • FIX: Active Directory escaping CN/DN when containing leading or trailing spaces.
  • FIX: OUVVI fix to call SignalR notification when called via the Start Project API.
  • FIX: OUVVI do not check DB schema on account login to prevent login loop when schema change required.
  • FIX: OUVVI Catch Exception and write detailed Log in AgentWorker.Process

6.0. 3310 - 02/11/2023​

  • FIX: Suppress OAuth2 Browser Script errors.
  • CHANGE: Change Licensing to require license key to run Compare.
  • CHANGE: Change Activation back to simple License Key activation window.
  • FEATURE: Add Incremental Lookup to Dynamics CRM FetchXml connector.
  • FEATURE: SQL Server, SQL Client, ADO.NET convert ArrayTypes to Strings in writer to prevent DataType errors.
  • FEATURE: SQL Server allow selection of OleDB driver to use.
  • FEATURE: Create SQL Table Wizard to include SQL Script in Error Message.
  • FEATURE: Enable Ignoring Calculated Column errors to prevent getting stuck.
  • FEATURE: Throw exception in FileSystem provider if Directory is not found.
  • FIX: Active Directory check range of FileTime Int64 is less than 9999/12/31
  • FEATURE: Add UpdateSourceRow to SharePoint Online connector.
  • FEATURE: Json API Connector Supports Writing via BuiltIn function and Callback writer.
  • FEATURE: Json API Connector Supports data paging by next page index.
  • OUVVI Release 6.0.3310

2024​

6.0. 3332 - 25/01/2024​

  • FEATURE: Add process Identity to Log
  • FIX: Create SharePoint Column when using Encryption Key
  • CHANGE: Default property code snippit to default to string.
  • FEATURE: Delete DSCache files on Startup.
  • CHANGE: Update nuget package references to latest versions.
  • FEATURE: Add SetParameterValue API to JSON API connector.
  • FEATURE: Expand the {Datasource.Name} value in JSON API connector Json Writer.
  • FEATURE: Add the ability to Filter Target Rows with a Datasource filter like you can the source.
  • CHANGE: Optimize the FileStore to reduce GC memory pressure.
  • FEATURE: Improve DataSync startup performance.
  • FEATURE: Allow setting NULL property on Columns in NULL/Empty provider.
  • FEATURE: Add ARM64 support for Windows 11 on Apple Silicon in Parallels.
  • FIX: Open in RunTool from Start Page
  • FIX: Active Directory Group Members when a group member list exceed 1500 users.
  • FIX: JSON API connector DELETE operation.
  • FIX: Unregister Event Handlers in Ouvvi Powershell and Cmd Handler.
  • FIX: OUVVI prevent startup failure on Duplicate configuration setting.
  • FEATURE: OUVVI add Project Status change Step Handler.
  • FEATURE: OUVVI Capture Trigger exceptions in Log.
  • OUVVI Release 6.0.3332

6.0. 3334 - 29/01/2024​

  • FEATURE: Method to add rows to DataTable store from Dictionary and Object
  • FEATURE: Ouvvi handle input errors for TimeSpan Trigger types
  • FIX: Ouvvi Trigger service failing if Time Triggers returned exception.
  • OUVVI Release 6.0.3334

6.0. 3336 - 06/02/2024​

  • CHANGE: Revert Microsoft.SharePoint.Client back to older version since new version had an internal dependency on Microsoft.Data.SqlClient which we do not want to include at this time.
  • OUVVI Release 6.0.3336

6.0. 3340 - 28/02/2024​

  • FIX: Task Scheduler dll missing from build causing errors creating scheduled tasks
  • FIX: Create custom Data Sync connector template project.
  • FEATURE: Add DataSchema Extensions from V8 for looping around schema columns.
  • OUVVI Release 6.0.3340

6.0. 3368 - 23/05/2024​

  • FEATURE: Add PKCE support for OAuth connections enabled for Salesforce, Dynamics and SharePoint connections
  • FEATURE: Sync up checkbox on Synchronise window with Project SucFailOnErrorStatus
  • FEATURE: Prevent Calculated Columns being dropped when there is a compile error.
  • FEATURE: Convert types to string before Testing in CompareTargetIsNullOrEmpty
  • FEATURE: JSON API: Handle response when 204:NoContent
  • FEATURE: JSON API: Add mode to JsonDefaultWriter to include Columns.KeyColumns in Update and Delete operations.
  • FEATURE: JSON API: Add Modes for AllKeys and AllIdentifiers in Default Writer
  • FEATURE: JSON API: Update Json Pager to support Index Paging
  • FEATURE: JSON API: Add OAuth2 Password Grant
  • BUG: JSON API: Fix when Lookups not saving in Project File.
  • FEATURE: Open Xml: Improve Excel Data Type handling and auto convert some values to the actual type i.e. Dates/TimeSpan etc.
  • FEATURE: Add new Connector FileTable to Read/Write Excel/Csv/Xml files directly from SharePoint document libraries.
  • BUG: Fix for Target Filter when you have a dynamic column in the Schema Map.
  • BUG: Fix when you close application after saving
  • BUG: Fix saving window layout
  • FEATURE: Move Schema Map properties to collapsible pane on right.
  • FEATURE: New connector for SQL Azure using Entra ID authentication
  • FEATURE: Salesforce: Add DateTime handling property to configuration to adjust to Local or UTC date times.
  • BUG: Fix when Schema Map has a column name with the same name as a dependency column.
  • FEATURE: Change evaluation mode to allow projects to run without license key, limited to 3000 rows and 20 columns.
  • FEATURE: OUVVI: Add object usage report
  • FEATURE: OUVVI: Add custom Project Start page with options
  • FEATURE: OUVVI: Update SharePoint, Salesforce and Dynamics to use PKCE with OAuth connections.
  • FEATURE: OUVVI: Update Deployment manager to check File Version rather than Product Version in assemblies.
  • FEATURE: OUVVI: Add SQL Azure to connection library options
  • BUG: OUVVI: Fix Ouvvi Apps Import/Export when column names contain spaces
  • BUG: OUVVI: Agent Settings service cache was not expiring
  • OUVVI Release 6.0.3368

6.0. 3378 - 10/10/2024​

  • FEATURE: OAuth2 Certificate support for SharePoint Online, Dynamics, SQL Azure, JSON API Tool.
  • FEATURE: SharePoint Online can now use Application level permissions with OAuth2 and certificate based authentication.
  • FEATURE: Ouvvi TimeTrigger now has a End Time to prevent trigger running outside of scheduled time window.
  • FEATURE: JSON API Tool connector can how access a parent Json Element via Parent-Path property.
  • FEATURE: Evaluation Mode can now test the Run Tool and Scheduled Tasks for 60 days.
  • OUVVI Release 6.0.3378

6.0. 3404 - 17/12/2024​

  • FEATURE: Update Azure connector to use the new SDK.
  • FEATURE: JSON API create a Virtual Column from a Regular Expression.
  • FIX: OData V4 connector ensure we pass ServiceAppendUrl to writer methods.
  • FEATURE: Allow setting the SyncMode from ProjectAutomation
  • CHANGE: Update SqlClient to use new Microsoft.Data.SqlClient library.
  • FEATURE: Add JsonPath hint option when discovering API with JSON API Tool designer.
  • CHANGE: Add Http Timeout of 3 min to Salesforce and JSON API Tool
  • FEATURE: Add Callback Batch option to JSON API Connector
  • CHANGE: Improvements to the JSON API Tool Designer
  • CHANGE: Changes to the SQL Transaction handling with the SQL Connector to specifically rollback on error to prevent ZombieCheck() error.
  • CHANGE: Add a Trace option to the JSON API Fetch Action to output the response to the Log.
  • CHANGE: Update the list of assemblies to skip loading on startup to improve start time.
  • FIX: Ouvvi RunTool Step wasn't recording Duration correctly
  • FEATURE: Ouvvi Add an option to run a Data Sync project from a file.
  • CHANGE: Ouvvi Update SqlClient to use new Microsoft.Data.SqlClient library.
  • FEATURE: Ouvvi Solution file can be used to upload multiple Data Sync project files without a project.xml configuration.
  • OUVVI Release 6.0.3404