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

6.0. 3406 - 30/12/2024​

  • FIX: FileSystem Provider check for Empty folder was returning empty despite files in folder causing exception.
  • CHANGE: SQL Provider to only enable IDENTITY INSERT if it was turned OFF in Finally code block.
  • OUVVI Release 6.0.3406

2025​

6.0. 3414 - 09/01/2025​

  • FIX: Active Directory connector was missing in list.
  • CHANGE: Dynamics handle condition where Option sets do not use naming convention and use data type to decide on ID or Name value.
  • FIX: Update SQL Client connector to work with SQL Synapse
  • FIX: Catch SQL Exception in Rollback for SQL Synapse and throw inner Exception
  • FIX: Check for Empty Directories in DELETE of FileSystem Provider
  • OUVVI Release 6.0.3414

6.0. 3490 - 02/05/2025​

  • GENERAL: Added Multi-Targeting Support to codebase to allow for builds on .NET Core and .NET Framework to support future .NET Core version of Data Sync. Also re-written Ouvvi to run on .NET Core.
  • FEATURE: Add Support for SqlBulkCopy to SqlClient Connector
  • FEATURE: Add SharePoint Chunked File Upload for SharePoint Online to allow large file uploads.
  • FEATURE: Change Datasource filter in Data Sync UI to remove nodes
  • FEATURE: Update Json API to remove empty query parameters and run on separate thread in designer so you can call stop.
  • FEATURE: Add a Prefix option to Json API ForEach so elements can be stacked inside ForEach loops
  • FIX: Json API change to how HttpWebRequestHelper is used to ensure it will refresh the Auth Token during a sync.
  • FIX: Fix issues with OADate in Excel Provider when using European Regional Settings.
  • CHANGE: Add missing Dynamic Columns Methods to Reserved Words
  • CHANGE: Change FileSystem Writer to use TempFile to copy file data to reduce memory usage while syncing.
  • OUVVI: Added a Sort option to the Dashboard View
  • OUVVI: Prevent user impersonation on any Process.Start() as this doesn't reliably work.
  • OUVVI: Update Navigation to use a BreadCrumb rather than the MiniMenu back button.
  • OUVVI Release 6.0.3490

6.0. 3500 - 15/05/2025​

  • OUVVI: Fix rare race condition which caused Agent to get stuck in loop and consume 100% cpu on thread.
  • OUVVI: Release 6.0.3500

6.0. 3512 - 25/06/2025​

  • UPDATE: Port Project Automation Lookup Functions from V3 to V6.
  • FIX: SharePoint Document Uploads were adding a Multi-part Content Type Header to the uploaded file.
  • UPDATE: Refactor HttpWebRequestHelper to remove params [] from methods to make it more obvious.
  • UPDATE: Refactor HttpWebRequestHelper to use Streams
  • FIX: Fix error in SharePoint where you have a column named DisplayName.
  • UPDATE: Update Actipro Controls to latest version
  • UPDATE: Update Nuget Packages to latest versions
  • UPDATE: Update to new Digital Certificate
  • OUVVI: Release 6.0.3512

6.0. 3530 - 17/07/2025​

  • FIX: Data Sync UI sometimes unresponsive when logging back into desktop.
  • FIX: Update Data Sync after applying License Key.
  • FIX: Fix for SQL Server discovery in SQL Connection window.
  • CHANGE: Changed how DateTime values are compared does better rounding to the second. Also can be configured via Project Automation to allow for Millisecond accuracy.
  • CHANGE: Ensure the Compare results tree show the order of execution ADD->UPDATE->DELETE.
  • UPDATE: Update Nuget Packages to latest versions
  • OUVVI: Release 6.0.3530

6.0. 3546 - 28/08/2025​

  • FEATURE: JSON API Connector Add a While condition to JSON API Paging as another option to break out of the Loop. Based on Zendesk cursor paging.
  • FIX: Issue with setting SyncOption from configuration when you have Project Automation code.
  • CHANGE: Dynamics 365 "Ignore Virtual Column" to be Informational Message rather than Error.
  • FIX: SharePoint Online Incremental Load - Cancel wasn't working
  • FIX: SharePoint Online GetListItemAttachment(url) - Didn't work with OAuth2
  • CHANGE: Update SharePoint Online connector to work with lower permissions.
  • CHANGE: SharePoint Online Retry to use RetryAfter HTTP Header value when throttled via HTTP 429 response.
  • CHANGE: Set AllowAutoRedirect to default on for HttpWebRequest Helper. Caused an issue with Google Sheets via the CSV provider.
  • FIX: Update HttpWebRequestHelper to be thread safe.
  • FIX: OUVVI Service Agent thread hang due to Thread deadlock on Response Headers dictionary in HttpWebRequest Helper
  • FIX: OUVVI Solution Import when regional settings are not US-EN parsing version string.
  • CHANGE: Ouvvi use EventWaitHandle to signal service rather than SignalR on local machine.
  • OUVVI: Release 6.0.3546

6.0. 3550 - 01/10/2025​

  • CHANGE: Throw error in SQL Client writer when connection closed.
  • FIX: JSON API ForEach when response returns an array of json objects.
  • FIX: SharePoint Online to refresh Access Token when running long process.
  • CHANGE: Ouvvi to use a File based event signal rather than global mutex due to permission requirements.
  • OUVVI: Release 6.0.3550

2026​

6.0. 3586 - 02/03/2026​

  • FIX: Sharepoint Online getting List by Title rather than calling CSOM API GetByTitle().
  • CHANGE: Do not write the Xml document declaration when generating Data Sync project files.
  • CHANGE: Update to codebase to support .NET10 and drop .NET Core build however remaining on .NET Framework for backward compatibility.
  • CHANGE: ODataV4 connector allow passing additional parameters in the Lookup function.
  • FIX: SharePoint Online connector was invalidating the Client Context during token refresh causing authentication errors.
  • CHANGE: Improvements to DataTableStore for column lookups to tables with many columns improves performance for SQL Bulk Insert operations.
  • CHANGE: Update AWS Nuget packages to latest versions.
  • CHANGE: Remove RTFTOPLAINTEXT from Completion Keywords List.
  • FIX: Dynamics 365 - Updating owner from System User to Team
  • CHANGE: SharePoint Online Add support for Multi-value Choice column by passing ; separated string.
  • CHANGE: SharePoint Online Reduce default batch size and query limit in SharePoint Online reader
  • FIX: DataCompare SourceRow should always return the SourceRow value in Before and After properties and not the value on the target.
  • OUVVI: Remove the XML Document declaration from Data Sync projects when importing from Zip file.
  • OUVVI: Add a feature to enable auto shutdown of the service agent at a specified time and day(s) of week.
  • OUVVI: Revert Agent from using Async/Await back to old school Thread and ThreadPool because of potential ThreadPool starvation issues.
  • OUVVI: Update to codebase to support .NET10 and drop .NET Core build however remaining on .NET Framework for backward compatibility.
  • OUVVI: Remove TimeConverter dll as only required for .NET Core
  • OUVVI: New Feature to allow simple Editing of Data Sync Project XML in Web Page
  • OUVVI: Do not use OpenRemote for IIS Server Manager in IIS Web App Step Handler.
  • OUVVI: Release 6.0.3586

6.0. 3594 - 02/04/2026​

  • FIX: SharePoint Online regression with Choice columns not setting correct value for single selection column type.
  • FIX: SharePoint regression Lookup columns not returning correct values when InternalName != DisplayName.
  • FEATURE: Better Schema Mapping apply properties from Target rather than source to better handle the ReadOnly issue.
  • FEATURE: Ouvvi PowerShell 2 step type for PowerShell.exe and pwsh.exe
  • OUVVI: Release 6.0.3594

6.0. 3630 - 27/04/2026​

  • FEATURE: Import Dataverse Tables into SQL Server via RunTool and Ouvvi Step.
  • CHANGE: Remove dependencies on Windows.Forms in Connectors by removing the requirements for TypeConverters. Update the Template project for creating new connectors to reflect this change.
  • FIX: Property Grid Dropdowns in release build.
  • CHANGE: Rewrite of AssemblyResolver to better handle loading of assemblies and dependencies and prevent issues with loading different versions of same assembly.
  • UPDATE: Update of Nuget vulnerable System.Security.Cryptography.Xml
  • FEATURE: Add an version checker which can also download the latest version from the website and also checks SHA256 HASH.
  • OUVVI: Ensure AutoShutdownAt uses the Ouvvi Timezone.
  • OUVVI: Deployment manager remove SQL Authentication username/password when choosing Windows Authentication.
  • OUVVI: Release 6.0.3630

6.0. 3646 - 01/07/2026​

  • FEATURE: Can now open Ouvvi Connection Library in Data Sync without opening a project.
  • FIX: Running Ouvvi project from Run Tool
  • FIX: Build Date error for License Activation
  • FIX: Double Click issue in SQL connection Browser
  • CHANGE: SQL Client connectors to use is_identity metadata to detect identity columns.
  • CHANGE: Do not AutoMap columns when compiling custom code to prevent unusual behaviour in the Schema Map.
  • FIX: Fix broken links on the start page.
  • CHANGE: Remove reference to System.Text.Json so that binding redirects point to correct version.
  • OUVVI: Resolving conflict of System.Text.Json to version 8.0.5 for compatibility with DataSync.
  • OUVVI: Add a log entry for OAuth token SecurityException.
  • OUVVI: Prevent unhandled Exception inside service loop during maintenance service bringing down agent.
  • OUVVI: Re-write of Cache to use the default MemoryCache.
  • OUVVI: Re-write of Roles and Middleware to use the cache and ensure we get a ClaimsPrincipal on HttpContext.
  • OUVVI: Feature: Logging retry, Services Down message
  • OUVVI: Change how the service agent processes the queue by implementing a ConcurrentQueue from the Agent list and processing from this in-memory queue.
  • OUVVI: Release 6.0.3646

6.0. 3652 - 13/07/2026​

  • FEATURE: Add a configuration setting for SuppressCallbackRegistrationExpanderJob in Dynamics 365 connector.
  • CHANGE: OUVVI Add an DB index to StepStatistics.InstanceID
  • FIX: OUVVI LogMaintenance wasn't being called due to incorrect URL also updated the Log to be informational rather than Trace to pick up the fact that it runs in the log. On Startup we attempt to delete a larger block of 20000 by default.
  • OUVVI: Release 6.0.3652