This document provides a brief introduction to the new features and enhancements included in the latest release of the Data Sync tool. This document also details the technical requirements and known issues in the Data Sync tool.| Version | Data Sync theme | Description | | --- | --- | --- | | 2.5.0
(Released: 2024-07-16) | Notifications | Email notification content has been improved

The contents of the email notifications has been improved to be more meaningful for users. (DST-34) | | 2.5.0
(Released: 2024-07-16) | Connectivity | ODBC connections are now supportedThe data sync tool now supports ODBC connections to upload data to Blue. (DST-25) | | 2.5.0
(Released: 2024-07-16) | Scheduler | Scheduled syncs now have a start and stop date

The data sync tool now allows users to include a start sync date and an end sync date to control the synchronization schedule. (DST-22) | | 2.5.0
(Released: 2024-07-16) | Scheduler | A save button is now available on the schedules pageThe schedules page now includes a save button so that users can modify the synchronization schedule without having to perform a manual sync to save their settings. (DST-20) | | 2.4.0
(Released: 2023-11-14) | System | Data Sync tool now supports Blue 9Data sync tool is now compatible with Blue 9. | | 2.3.0
(Released: 2022-05-09) | Import | Added support for the import duplicates into a single record featureAdded support for the "import duplicates into a single record" feature that was added to Blue. | | 2.3.0
(Released: 2022-05-09) | Drivers | Support added for Oracle drivers v19.11.0

Added support for the latest Oracle drivers v19.11.0 | | 2.2.0.0
(Released: 2019-04-26) | Datasources | Data Sync tool now supports the Update option

The Update option (to append data) is now supported in the Data Sync tool and Blue API. The Data Sync tool/API will read Blue datasource settings. This applies to all datasource types except for Hierarchy. | | 2.2.0.0
(Released: 2019-04-26) | Datasources | Data Sync tool now Extension Blocks Synchronization

Extension blocks are now supported in the Data Sync Tool and Blue API. The Data Sync tool/API will read Blue datasource settings. This applies to all datasource types except for Hierarchy. | | 2.0.1.0
(Released: 2018-01-24) | Datasources | Relationship datasources support Row Extension Blocks and Demographic DataRelationship datasources support the new Row Extension data blocks and the additional demographic data. | | 2.0.1.0
(Released: 2018-01-24) | Datasources | Import, Schedule, and Export Hierarchy datasources

Hierarchy type datasources can now be imported, scheduled, and exported just like the other datasource types. | | 1.1.0.01
(Released: 2016-01-14) | Datasources | View the latest changes made to object and user datasources

Download a CSV file that contains all of the changed records for an object or user datasource that have been updated during the most recent sync.

![](https://fdendpoint-onlinehelp-explorance-prod-01-bsdydxd9hxcpeffn.a03.azurefd.net/web/assets/viewchanges.png) | | 1.0.0.00
(Released: 2015-09-10) | Datasources | Import data from many connections

Data from an external datasource can be imported into Blue using CSV files, Excel files, SQL Server, and Oracle. | | 1.0.0.00
(Released: 2015-09-10) | Scheduler | Hourly, Daily and Weekly import schedules

Import schedules can be set up to run every hour, once a day, or once a week. | | 1.0.0.00
(Released: 2015-09-10) | Datasources | Simple field mapping

Field mapping is simple and only needs to be done once for each datasource when using the Data Sync interface. | | 1.0.0.00
(Released: 2015-09-10) | Notifications | Email Notifications

Data Sync will send an email if an error is encountered during a scheduled data import. | | 1.0.0.00
(Released: 2015-09-10) | Notifications | Detailed Error Logs

Detailed error logs are created whenever Data Sync encounters a problem. Error logs are provided for the application and for each datasource. | Features and enhancements| Data Sync theme | Issue description | | --- | --- | | UI/UX | Datasource list always reverts to icon view. Data Sync does not remember the viewing preference for the datasource list and it will always default to icon view even if it was previously changed to detail view. Use the datasource list in icon view or change it to detail view each time the datasource list is visited. | | Datasources | No warning when connecting to an Oracle datasource without the Oracle Client installed. During the installation process, a warning will appear if the Oracle Client is not installed; however, within the app, it is possible to connect to an Oracle datasource. The connection will fail, but the error message is not clear. Only connect to an Oracle datasource if you have the Oracle client installed. | Known issues in this release| Fixed in | Data Sync theme | Summary | | --- | --- | --- | | 2.5.0 (Released: 2024-07-16) | Notifications | Fixed an issue where emails that were being sent from the data sync tool were displaying the HTML tags in the email rather than rendering the messages properly. (DST-33) | | 2.5.0 (Released: 2024-07-16) | System | Fixed an issue where the Save button was not functioning properly when the data sync tool was set to manually sync only. (DST-38) | | 2.5.0 (Released: 2024-07-16) | System | Fixed an issue so that it is no longer required the user be an administrator to run the data sync tool. (DST-33) | | 2.3.0 (Released: 2022-05-09) | Scheduler | Fixed an issue introduced in 2.2.3 that resulted in the immediate sync failing and actually being scheduled nearly a week into the future. (DST-1) | | 2.2.3 | Scheduler | [The weekly sync](data-sync-tool-datasource-set-up) can be scheduled anytime, 7 days a week, with the Data Sync tool (DST). (BLUE-5788) | | 2.1.1 | Oracle | Fixed an issue importing data from Oracle views that resulted in the Data Sync tool failing to import any data if the data coming from the Oracle view contained double quotes around each piece of data. (_ID: TFS19729_) | | 1.1.0.04 | Datasources | Fixed a divide by zero error that would occur when attempting to import a large datasource from a SQL view that may take a long time to compile. _(ID: TFS9762)_ | | 1.1.0.04 | Datasources | Solved a problem that caused an error to appear when importing an Oracle datasource that contains column names that use SQL reserved words. _(ID: TFS9466)_ | | 1.1.0.04 | Datasources | Fixed an issue with the Data Sync tool being used on Windows 10 and Windows Server 2012 that resulted in a timeout error when attempting to export a datasource. _(ID: TFS7955)_ | | 1.1.0.04 | Connectivity | Fixed an issue that prevented successful connections to older versions of Blue resulting in an out of range exception. _(ID: ZD18489, TFS7330)_ | | 1.1.0.03 | Connectivity | Fixed a localization issue with date time formats that caused Data Sync to either fail immediately or eventually timeout trying to connect to Blue. _(ID: ZD17886, TFS7482)_ | | 1.1.0.02 | Localization | Eliminated a timeout issue when synchronizing with a datasource that was caused by problems with the way in which Data Sync was handling international date formats. _(ID: TFS7630)_ | | 1.1.0.02 | Localization | Resolved a bug that caused the Data Sync tool to hang after the sign-in page when the system language was set to something other than US English and the system date format was set to d/MM/yyyy. Dates throughout Data Sync should follow the same format and Data Sync should function regardless of which system language or date format is selected. _(ID: TFS7106)_ | | 1.1.0.02 | Connectivity | Fixed a problem when importing data from an Oracle database that caused a query to be called multiple times resulting in duplicate records appearing. _(ID: TFS6590)_ | | 1.1.0.01 | Connectivity | Fixed an issue where the Data Sync tool would fail to connect with the server if SSL3, TLS, TLS 1.1 were disabled on the server by adding TLS 1.2 to the `BluePushDataAppConfig.xml`. The security protocols can now be enabled or disabled by setting the appropriate value to true or false in the `BluePushDataAppConfig.xml` file. _(ID: TFS5936)_ | | 1.1.0.01 | Connectivity | Modified the Data Sync tool so that it properly handles SQL server connections where the database does not utilize the default schema. _(ID: ZD16816, TFS5834)_ | | 1.1.0.00 | Localization | Eliminated a problem that would cause Data Sync to crash if the date format being used by the system was not dd/mm/yyyy. _(ID: TFS149)_ | | 1.1.0.00 | Connectivity | Fixed an issue where the data synchronization process would fail when connected to an Oracle database with a non-default schema. _(ID: TFS2101)_ | | 1.1.0.00 | Datasources | Modified the CSV export schema to include all required fields and all optional fields. Previously the required fields were not included. _(ID: TFS1085)_ | | 1.1.0.00 | Notifications | Added additional information to the sync history log so that it now includes the sync time along with the sync date. _(ID: TFS3188)_ | | 1.1.0.00 | Scheduler | Adjusted the scheduler logic to prevent a daily sync from being performed immediately so that now it will only begin at the scheduled time. _(ID: TFS3251)_ | | 1.1.0.00 | Datasources | Solved a bug that caused duplicate records encountered during a sync to be correctly identified and resolved, but during subsequent syncs, Data Sync would report duplicates existing even though there were none. Occurred because a temp table in the database was not being properly removed. _(ID: TFS3265)_ | | 1.1.0.00 | Notifications | Fixed an issue that resulted in being unable to set up email notifications. This issue would occur if an attempt to send a test email was made while some of the required settings were not included. _(ID: IT11474)_ | Fixed in this ReleaseFor information on which versions of Explorance software is compatible with your version of Blue please refer to the [Blue compatibility table](blue-compatibility-table).Compatibility

Data Sync tool release notes