Change log

Change log

2023.6

  • Version control system integration (import/export entities) (Export doc Import doc)
  • Test case labels (Documentation)
  • Test case relations (schema, object, columns) (Documentation)
  • Test case comments (Documentation)
  • Multi-column results for test cases (Documentation)
  • Connections page UI rework
  • Test cases page UI rework
  • “Changes” column to Test cases page
  • Test suite HTML report is now sortable by clicking on headers
  • Links in HTML report test case additional info are now clickable
  • Add/edit test cases permission in roles
  • Removed directories level limit of 5
  • API to manage users and roles (Documentation)
  • Security logs

2023.4

  • Multiple authentication methods in parallel (AD/LDAP + OAuth + local user system)
  • New execution bar with possibility to minimize
  • Improved compare engine performance
  • Compare test case result samples can now be displayed in HTML report
  • Test case history chart is shown for all test cases with numeric results
  • Added “Security logs” to logs view in Dashboard
  • Added SQLite integration for Connections
  • Security fixes

2023.3:

  • Possibility to change system time for the application
  • Global variables for test cases (https://litech.app/documentation/#Global_variables)
  • API endpoint to execute test cases based on filters (https://litech.app/documentation/api/#Execute-2)
  • Count of added/edited test cases is now shown on “Save” button
  • “New test case” button is moved to navigation bar
  • Possibility to include sample test case results in test suite HTML reports (added “Results in report” option for test suite settings).
  • Test case results are now possible to download as CSV
  • Duplicated test cases now display [Copy] in their description
  • Duplicated test cases are inserted next to their originals in test cases view
  • Possibility to execute test cases that use multiple resultsets (e.g. inserting into temporary tables within a test case)
  • HTML reporting for profiling objects
  • Possibility to set threshold sensitivity for profiling objects
  • Status is now shown for historic data in profiling charts
  • Prediction with threshold is now displayed for all profiling executions
  • Profiling objects filter on Dashboard is now based on object names and grouped by connections
  • Add/edit directories privileges
  • Test suite/profiling URL now available as alert parameter and in HTML reports
  • Added more informative icons/hover-boxes to various forms
  • Added general help (?) window to the bottom left corner
  • Redesigned Settings page
  • Custom email subject line
  • Added interactive legend to daily data quality chart on Dashboard

2022.12:

  • New improved Dashboard
    • Daily data quality chart
    • Changes to previous day
    • Alarms
  • Test suite directories
  • HTTPS can now be enabled from cert files

2022.11:

  • Self-signed certificates for OAuth autherization
  • OpenEdge Progress connection support

2022.10:

  • Webhooks custom JSON
  • Exasol connection is now supported
  • Possibility to test connections from add/edit connection view
  • New prediction types for test cases:
    • Average
    • Polynomial
  • Possibility to add profiling objects with/without rules
  • Profiling dynamic rules now have “default” switch – default rules are automatically generated, non-defaults can be added manually
  • A view to see and manage all rules for a profiled object
  • Removed profiling manual thresholds as these are now automatically calculated
  • Possibility to remove profiling rule execution from history by clicking on it on history chart
  • Profiling column value rule custom SQL
  • UX/UI improvements

2022.6:

  • Reworked UX/UI for:
    • Profiling objects
    • Test suites
    • Test cases
  • Metadata collecting for REST API and CSV connections
  • Profiling for REST API and CSV connections
  • Last active timestamp for users
  • Compare test case results are now available as CSV files
  • Execution history now displays statuses for all executions
  • Added row count rule for profiling objects
  • Added percentage indicator for profiling rules
  • Possibility to add profiling columns without rules

2022.4:

  • Profiling and test suite schedulers are now run in series (previously scheduler exceeded parallel connection limit)
  • Test case rules are now available from “Test cases” sidebar (instead of separate page)
  • When generating object-based test cases, only available rules are shown (previously all rules were visible)
  • Possibility to add multiple expected results for a test case
  • Possibility to set expected result as previous result (=, >, <)
  • Schedule chart is now visible on desktop, instead of Test suite page
  • Schedule chart now contains profiling executions
  • Execution history data retention can now be set from Settings page (default 60 days)
  • New role privilege to allow or disallow executing
  • Added sorting and filtering for Users
  • Added sorting and filtering for Test case rules
  • Connectors are now visible for Test case rules when managing them
  • Fixed issues:
    • Issue when importing test cases
    • UI fixes

2022.2:

  • Profiling/test cases chart switch for Dashboard
  • Possibility to auto-refresh information/charts on Dashboard
  • Admins can now cancel any execution from Dashboard by hovering on running execution and clicking X
  • Possibility to use change indicators for test cases (comparing to previous result)
  • Test suites can no longer be executed (and an error is displayed) if they are already being executed by someone else
  • Possibility to disable profiling column value rule
  • Possibility to set maximum count of values that are profiled for a column (in Settings, default set as 10)
  • Improved test suite schedule chart to display execution times more accurately
  • Fixed issues:
    • Duplicated test cases did not have set connections
    • Profiling column value count 0 was inserted even if it no longer existed
    • Cancelling executions failed in some cases
    • Fixed issue with tool failing to get metadata for Oracle and MsSQL databases

2022.1:

  • Metadata UI redesign when opening metadata for a connection
  • Added possibility to refresh schemas manually for a connection
  • No longer possible to accidentally delete metadata that is used in profiling
  • API V1 release
  • Test cases now have “Created by” label
  • Profiling object pie chart now displays limited columns, prioritised by columns that have erroneous rules
  • Test suites are now by default set as “Public” when creating a new test suite
  • Test suites no longer have “Threads” or “Timeout” settings as they are set in connection settings
  • Test cases page no longer has “Threads” setting
  • Possibility to copy and share test case URL (copy to clipboard button)
  • Profiling rules default threshold set to 10% from 5%
  • Possibility to replace HTTPS certification
  • Fixed issues:
    • Test case HTML report column width issues
    • Connections are now in ascending order
    • Fixed issue with illegal character errors in logs

2021.12:

  • Possibility to delete specific values from profiled column value history
  • Added CPU % to settings page chart
  • “Drivers” are now renamed to “Connectors”
  • Improved concurrency for multi-user usage
  • Opening profiling objects is now faster
  • Fixed issues:
    • Issue with adding dynamic rules
    • Issue with importing and exporting test cases
    • Issue with test suite schedule chart
    • Issue with importing metadata from multiple schemas
    • Issue with restoring from backups

0.0.22:

  • Possibility to cancel profiling rule executions
  • Profiling schedule and executions are now displayed on Desktop view
  • Possibility to set how many errors are allowed for a profiled object before automatic alert is sent
  • Profiled object Alerts and Schedule view enhancements
  • Profiling rule “Delete” icon is now displayed even if rule is not opened
  • Profiled object top values now accurately detect if a value no longer is found in object
  • Possibility to view profiled object top value chart for selected values
  • Test cases in archived test suites are no longer visible
  • Comparison test cases now display error when row limit is reached

0.0.21:

  • Users will be redirected to login page if session is expired
  • Test suite schedule density is now visualized as a chart
  • Possibility to enable/disable test case
  • Possibility to exclude ‘error’ status test cases from test suite results
  • ‘Save all’ button for profiling dynamic data types
  • Mass action for adding/removing profiling objects
  • Possibility to automatically add columns with rules when adding a new profiling object
  • Mass action to change test case connection
  • Test suites page is now sortable
  • Fixed issues:
    • Tests page initial load did not load some test cases

0.0.20:

  • Possibility to mass assign and remove roles from users
  • Users without add/edit connection privileges can now view connection meta data
  • Default User role can now add/edit connections
  • Fixed issues:
    • Test suite report not working
    • Parts of pages with many entries were not scrollable
    • Tests page search function did not work with whitespaces

0.0.19:

  • Possibility to choose test result prediction (% diff) based on Linear Regression or Previous result
  • Users can now define level of data from JSON for REST connections
  • Test cases without connection privileges are no longer visible for users
  • Connections without privileges are no longer visible for users
  • Added role privileges for:
    • Adding/editing test suites
    • Adding/editing profiling objects
    • Adding/editing profiling rules
  • Fixed issues:
    • Rounding errors on test and profiling reports
    • Visual issues with test suite report
    • Settings page subpage URL fixes
    • Wrong test suites displayed on login

0.0.18:

  • Users are now redirected to previous page after authentication
  • Profiled object report view
  • Test suite PDF report changed to HTML with additional information about results
  • Sharing Tests page URL now includes filters
  • Fixed issues:
    • No test suites were selected on Desktop view after initial log in
    • Scheduled executions are now in local (system) timezones
    • Changing user roles sometimes failed to save

0.0.17:

  • HTTPS support
  • Fixed issues with table widths in Chrome
  • Test suite scheduler now executes test suites simultaneously (set to 2 parallel executions by default)
  • Possibility to change usernames (only Admins can change usernames)
  • Button to view test cases related to profiled object
  • Profiled objects sorting
  • Mass actions for profiled objects (execute, delete, schedule)
  • Mass clear / assign rules for a profiled object

0.0.16:

  • Setting to automatically create user for Oauth2/LDAP log in if user is not registred
  • Possibility to cancel execution for manually executed profiling rules
  • SQL filter for profiled object
  • Profiled object email/webhook alerts with scheduled executions
  • Profiled column top values prediction threshold
  • Profiled column top values error indicator (using set threshold)
  • “Save all” button for profiling rules
  • “Add all columns” button for profiled object
  • Functionality to add new profiling rule to all applicable columns
  • Duplicate rules are no longer displayed when adding a rule for a profiled column
  • Datetimes and dates can now be profiled (MAX(date), MIN(date) etc)

0.0.15:

  • Added 7 REST API endpoints
  • Changed LDAP to perform search within subtree scope (baseDN + subtrees below baseDN)
  • Changes in Profiling:
    • Rules can now be added/changed/removed
    • Types can be created and assigned to rules (assign rules to certain data types)
    • Rules can now be assigned to certain JDBC drivers
    • Small UI changes and bugfixes
  • Fixed issues:
    • Linear regression prediction displayed wrong result in some cases
    • Users did not have privileges for a connection they added

0.0.14:

  • OAuth2 authentication
  • LDAP authentication over SSL
  • Possibility to set threshold for multiple test cases at a time
  • Logged in username displayed in sidebar
  • Possibility to change count of rows displayed for a failed test case
  • Fixed issues:
    • Profiling scheduler did not run on Sundays
    • Page crashed after loading new drivers
    • Changing password for a user failed in some cases

0.0.13:

  • BigQuery data source support
  • CSV files data source support
  • REST API data source support
  • Objects can be filtered by column names when generating test cases
  • Primary key parameters in test generation
  • Possibility to see failed test case results for COUNT(*) tests
  • Possibility to exclude test case from scheduled test suite “Allowed errors(%)” calculation
  • Fixed issues:
    • Dynamic test generation failed in some cases
    • LDAP placeholders missing in Settings page

0.0.12:

  • Redshift data source support
  • Snowflake data source support
  • Test suite archiving
  • Add/edit connections privilege can now be set to a role
  • Add/edit rules privilege can now be set to a role

0.0.11:

  • Slack channel alerts
  • Test suites can now be scheduled on selected days
  • Added column value profiling to Profiling page
  • Custom roles can now be assigned to users to access only selected data sources