Sequel Data Warehouse Client

August 2023

Version: 8.3.2904

August 21, 2023

Fixes
  • Fix for display of text data sources with very similar names.

  • Correction to the columns displayed for a data set used as a data source in an extract.

  • An error occurred if the Output button was used when the client was not connected to an Environment.

March 2022

Version: 8.3.2902

March 16, 2023

Fixes
  • Fix for handling of rule properties where an External Call is bypassed.

  • Fix for validation of Boolean parameter in User-defined Function creation.

  • Correction to Data Set name validation in certain circumstances.

February 2023

Version: 08.3.2901

February 20, 2023

Enhancements
  • Add support for checking SQLSTATE and SQLCODE values after executing embedded SQL Statements in extract expressions.
Fixes
  • Increase the default number of rows to select for Sample data panel from 3 to 200.
  • Fix for introduction/refresh of Salesforce data sources, where remarks column contains invalid characters.

November 2021

Version: 08.2.2814

November 10, 2021

Fixes
  • Double Click on a structured rule in an extract could cause the client to lock up

  • Validation error in SQL Select expression for Transaction Data Source when referencing numeric parameters multiple times in the expression

December 2020

Version: 08.2.2811

December 14, 2020

Fixes
  • Ensure the count of rejects for an extract is updated correctly on refresh of extract overview.

  • The default ‘save to’ location for Publish Metadata and Export metadata to text is no longer the client install directory in Program Files – the user may not have authority to save to this folder.

  • Refresh of a data source could result in a null pointer exception when processing list of affected extracts.

  • In extract visualization, the last join column for a data source could not be selected/dragged if the data source was collapsed.

  • An incorrect value could be displayed for the date format of a numeric virtual element defined as a date, when viewing the production edition of an extract.

September 2020

Version: 08.2.2810

September 01, 2020

Fixes
  • The OK button was incorrectly disabled on the edit data element panel for a checked-out data set.

June 2020

Version: 08.2.2809

June 30, 2020

Fixes
  • The Column Rules flowchart element in an extract was incorrectly greyed out when expressions (but not structured rules) exist.

  • Adding a data set as a data source in an extract, by using the New button added the first data set in the list, regardless of which data set was

  • chosen.

  • A subject area could be inadvertently created without a group.

  • When adding a data element to a new data set in the wizard, positioning of the list by typing the first character was sometimes incorrect.

  • When adding a data element to a new data set in the wizard, and using a filter to subset the list, the panel would close if the last data element.

  • shown by the filter was selected. It now stays open, allowing the user to remove the filter to show more data elements.

  • The list of references for a data source incorrectly included data set references when the data set had been (unnecessarily) introduced as a

  • data set.

  • Where the same data source was included in an extract multiple times, copy/paste of data source rules between different instances was not

October 2019

Version 08.2.2808
Fixes
  • It is now possible to set a numeric data element in a data set to Accumulate if allowed as a dimension (but not if used as a dimension).

  • The ROWID column defined for EXCEL data source is now larger to prevent load errors when more than 64K rows exist in the spreadsheet.

  • In some cases, a file lock was left on a data set when the Sample function was used from the client.

  • An expression validation error was incorrectly reported when the %diff function was used in some complex scenarios.

  • Support Java 1.8 for custom source groups. Disallow Java 1.6 No Integer Data Elements were incorrectly shown as Big Integer in extract visualization No Fix client lock up if the Print button was used in the printer output panel.

May 2019

Version 08.2.2807
Fixes
  • Sequencing a Virtual Element at very end of program is now allowed. A Virtual element may be used to (for example) execute a UDF at the end of processing.

  • List of Registered Data Sets for an extract did not use SQL names when SQL Naming was set.

  • The Implicitly Hidden attribute was not correctly defaulted when adding a data element to a data set, if the data element default was Yes.

  • Correction to display of secondary environments when linking environments.

  • Data Element Filter erratic behavior. The cursor could jump out of the text box when typing if the Text tab was selected in the bottom section. Also, the filter selection is now retained when checking out, or deleting etc.

  • Improve performance when using sample data function for a View or MQT.

  • Introduce LCT Data Source panel not wide enough for long column names. The panel may now be resized to show the full column name.

November 2018

Version 08.2.2804
Fixes
  • New search function for Data Sources, Data Elements, Data Sets and Extracts.
  • Data Set SQL name incorrectly used for validation when in SQL Name display mode.
  • Error occurs when viewing an eGateway trace file and switching environments.
  • Sample Data not displayed if environment is in an IASP.

October 2018

Version 08.2.2803
Fixes
  • Fix validation issue in expression when multiplying by -1.
  • The View SQL panel for a View or MQT hides at the back.
  • Icon was not immediately updated when unlocking an environment.
  • Data profiling panel may not show distribution information immediately after a profile run.
  • Allow re-size for Message Queue and Serve joblog panels.

August 2018

Version 08.2.2801
Fixes
  • Data set (short) name validation was incorrectly using the long name when in long name view mode.
  • Sample data panel could hide at back in some circumstances.
  • Push database name for MSSQL database could be initialized to wrong version ID on create.

July 2018

Version 08.2.2800
  • Base Release

Back to Sequel Products