What's new in ETL-Tools QlikView Connector 3.4.5.2

Oct 31, 2017
  • Improved: Functionality of Running totals transformation function
  • Improved: Open SSL libraries update
  • Improved: Up to 30 percent faster
  • Added : Support for SFTP Private Keys
  • Fixed : Issues with QVX Files reading
  • Fixed : Issues with assigning default values to lookup
  • Fixed : Issues with reading brightpearl data

New in ETL-Tools QlikView Connector 3.4.4.1 (Jul 5, 2016)

  • Improved : JDBC Error Messages.

New in ETL-Tools QlikView Connector 3.4.4.0 (Jul 5, 2016)

  • Third party components update
  • Support for the new functions introduced in the Excel 2016 January Update
  • Improved compatibility with thid party xlsx files
  • Improved compatibility with invalid xls and xlsx files
  • Improved : Excel 2010 equations are now preserved in xlsx
  • Improved : Log and rejected records files are no longer using executable location
  • Improved : JDBC Errors Handling
  • New : Support SSL v2, v3, v1_1 and v1_2 was introduced
  • New : Support for opening xls versions from 2 to 4
  • Improved support for RSS feeds
  • Minor transformation designer improvements
  • Calculation transformation function support Python now
  • Added Write to File transformation function
  • SSL Libraries update
  • SalesForce connection uses TLS 1.1 now
  • Add refresh databases button to source and target connections
  • Added support for Unicode in server, database and table names
  • ODBC error messages support Unicode now
  • Added ability to extract 'List of groups the user(s) belongs to' from Active Directory
  • Added ability to extract 'List of group(s) members' from Active Directory
  • Better support for QVD's Timestamp and Date fields
  • Added Ignore Data Format option to Excel Data reader
  • Added Lookup Replace Transformation function
  • Fixed : Problems with reading data from unicode files
  • Fixed order of records specific for Excel 2010 to workaround a bug in Excel 2010.
  • Some very complex files could raise an error when opened in Excel 2010, even when they were correct by the xlsx spec.
  • Fixed : Xlsx files with 0 bytes xml files inside could throw an "Invalid XML file" error.
  • Fixed : Data validations entered manually in xls files could fail to work when opened in Excel
  • Address issues with Change Date Static,Change Date Dynamic and If WeekDay functions
  • Addressed Salesforce data update issues
  • Addressed issues with Running Total transformation
  • Log Object bugs fixes
  • Date fields processing bugs fixes
  • Joiner Object bugs fixes
  • Addressed DTD is prohibited issues
  • Addressed Date validation and conversion problems
  • Addressed issues with print preview screen
  • Addressed issues flicking
  • Addressed issues with loading data from JDBC data sources
  • Addressed issues with loading data from Windows Event Log
  • Fixed issues with syntax highlighting in Mapping editor
  • Addressed issues with clone row object
  • Addressed issues with union and sorter objects
  • Addressed issues with subtransformation function
  • Addressed issues with split function
  • Addressed issues with joining empty files

New in ETL-Tools QlikView Connector 3.4.2.4 (Jul 5, 2016)

  • Faster QVD files processing
  • Third party components update
  • Reduced memory usage for QVD files processing
  • Addressed issues with clone row object

New in ETL-Tools QlikView Connector 3.4.2.0 (Sep 28, 2015)

  • Added support for Active Directory as data source
  • Addressed issues with filtering data
  • Addressed issues with exporting data into excel files

New in ETL-Tools QlikView Connector 3.4.1.5 (Sep 28, 2015)

  • Added Save button to Transformer and Validator
  • Added FileLine transformation function
  • Addressed issues with Slemma Import
  • Various bugs fixes and improvements

New in ETL-Tools QlikView Connector 3.4.1.2 (Sep 28, 2015)

  • Added Save button to Transformer and Validator
  • Added FileLine transformation function
  • Addressed issues with Slemma Import
  • Various bugs fixes and improvements

New in ETL-Tools QlikView Connector 3.4.1.1 (Sep 28, 2015)

  • Added support for Clarion dat files

New in ETL-Tools QlikView Connector 3.4.1.0 (Sep 28, 2015)

  • Added support for import from Slemma
  • Excel Import and export from data grids is much faster now
  • Added Encode JSON Object and Decode JSON Object transformation functions
  • Added Encode JSON Array and Decode JSON Array transformation functions
  • Added Encode JSON Pair and Decode JSON Pair transformation functions
  • Added Encode JSON String and Decode JSON String
  • Addressed issues with exporting data as excel from data grids
  • Addressed issues with deduplicator
  • Addressed issues with deleting records

New in ETL-Tools QlikView Connector 3.4.0.0 (Sep 28, 2015)

  • Up to 5 times faster data sorting
  • Up to 6 times faster data de-duplication
  • Up to 2 times faster data grouping
  • Up to 3 times faster reading data from QVD files
  • Up to 4 times faster working with text files
  • Up to 4 times faster data extraction from Sql Server
  • Up to 4 times faster data extraction from ODBC sources
  • Various bugs fixes and improvements

New in ETL-Tools QlikView Connector 3.3.0.5 (Sep 28, 2015)

  • Up to 3 times faster data extraction from Sql Server
  • Up to 3 times faster data extraction from ODBC sources
  • Up to 3 times faster reading data from QVD files
  • Up to 2 times faster data sorting
  • Up to 50 percent faster text files processing
  • Added thousands separator to transformation objects
  • Addressed issues with Joiner object
  • Various bugs fixes and improvements

New in ETL-Tools QlikView Connector 3.3.0.3 (Sep 28, 2015)

  • Up to 7 times faster data sorting
  • Addressed issues with salesforce data processing
  • Fixed problems with data preview
  • Various bug fixes and improvements

New in ETL-Tools QlikView Connector 3.3.0.1 (Sep 28, 2015)

  • Added Vertical Grid
  • Third party components update
  • Addressed issues with theme management
  • Loads recent history of changes by default now (Full history is to big and slows down the application)
  • Addressed issues with metadata object

New in ETL-Tools QlikView Connector 3.3.0.0 (Jan 26, 2015)

  • Support for multiple readers
  • Joiner Renamed to Join
  • Splitter Renamed to Split
  • Joiner Object was introduced
  • Skip empty fields option was introduced to Join object
  • Incremental object search was added to package designer
  • Minor interface improvements
  • Writer and Reader description are mandatory now
  • New option to Include reader name into Rejected records file
  • Documentation update
  • Addressed issue with sending SMS messages

New in ETL-Tools QlikView Connector 3.2.0.2 (Jan 26, 2015)

  • Setup and executable are digitally signed now
  • Added Reset height option
  • Minor bugs fixes

New in ETL-Tools QlikView Connector 3.2.0.1 (Dec 17, 2014)

  • Up to 10 percent faster
  • Licence Update
  • Documentation Update
  • Addressed issues with XML encoding
  • Addressed some validator issues

New in ETL-Tools QlikView Connector 3.2.0.0 (Dec 17, 2014)

  • Incremental search was added to all grids
  • Export to RTF was introduced
  • Excel export formats improvements
  • Various Interface improvements
  • Documentation update
  • Minor bugs fixes
  • Spelling corrections

New in ETL-Tools QlikView Connector 3.1.0.11 (Dec 17, 2014)

  • Added Is Null or Empty string validation function
  • Added If Null or Empty string transformation function
  • Documentation Update
  • Added Support for Message Queuing (MSMQ)
  • Addressed issues with BIGINT fields
  • Mapping editor bug fixes
  • Addressed CASE transformation issues
  • MySQL bugs fixes

New in ETL-Tools QlikView Connector 3.1.0.8 (Sep 1, 2014)

  • Addressed issues with Get Excel Cell Value transformation function

New in ETL-Tools QlikView Connector 3.1.0.5 (Aug 14, 2014)

  • Added URL shortener transformation function
  • Added URL Location transformation function
  • Added IP Location transformation function
  • Added Accumulate Strings transformation function
  • Extended Metadata transformation function functionality
  • Interface improvements
  • Added CASE transformation function
  • Added Delete Leading Characters transformation function
  • Added Delete Trailing Characters transformation function
  • Added support for special characters
  • Extended functionality of Get Excel Cell Value and Get File Context functions
  • Documentation update
  • Subtransformation bugs fixes

New in ETL-Tools QlikView Connector 3.1.0.2 (Aug 14, 2014)

  • Ability to move objects between different tabs was introduced
  • Added two new transformation functions Get Excel Cell Value and Get File Context
  • Introduced support for salesforce QueryAll interface
  • Excel processing engine update
  • Addressed problems with batch import via ODBC
  • Addressed issues with Undo Redo buttons
  • Addressed excel' files locking problems
  • Addressed problems with refreshing logs

New in ETL-Tools QlikView Connector 3.1.0.1 (Aug 14, 2014)

  • Support for latest version of Google spreadsheets was introduced

New in ETL-Tools QlikView Connector 3.1.0.0 (Aug 14, 2014)

  • Up to 50 percent faster working with QVD files
  • Renamed Web Service Lookup to HTTP Post
  • Added HTTP Get Transformation function
  • Up to 10 times faster data sorting
  • Web Service Lookup issues were addressed
  • Addressed DD-MMM-YYYY date format issues
  • Addressed issues of loading data from the files with old creation date

New in ETL-Tools QlikView Connector 3.0.0.7 (Aug 14, 2014)

  • Addressed union object issues
  • Addressed some subtransformation issues
  • Fixed Copy/Paste problems with Sub Transformation object

New in ETL-Tools QlikView Connector 3.0.0.5 (Aug 14, 2014)

  • Addressed issues of loading data from Excel files

New in ETL-Tools QlikView Connector 3.0.0.4 (Aug 14, 2014)

  • Added option to set defaults
  • Added option to filter target fields
  • Addressed issues with day of the week checking

New in ETL-Tools QlikView Connector 3.0.0.3 (Aug 14, 2014)

  • Updated regular expression for US SSN
  • Addressed issues of loading data from flat files
  • Minor interface fixes
  • Autoformat fixes (Some mappings may need to be updated)
  • When new output field is added field id is assigned automatically
  • Documentation update
  • Addressed issues with loading empty Date fields into MS SQL server

New in ETL-Tools QlikView Connector 3.0.0.2 (Dec 16, 2013)

  • Support for Zoom in/Out was introduced
  • Target Data tab was introduced to the transformation editor
  • Addressed issues of loading data from flat files

New in ETL-Tools QlikView Connector 2.2.2.9 (Nov 5, 2012)

  • Added option to ignore XML tags between Table tag and Record tag
  • Added new object Log which can be used to analyze data quality issues
  • Reader Parameter Object was renamed to Metadata object
  • Documentation Update
  • Various bug fixes

New in ETL-Tools QlikView Connector 2.2.0.0 (Sep 17, 2012)

  • Support for QVD was introduced
  • Various bug fixes
  • Documentation update

New in ETL-Tools QlikView Connector 2.1.2.6 (Jun 29, 2012)

  • Support for SalesForce was introduced
  • Support for BrightPearl was introduced
  • 8+ times performance increase
  • Better QlikView Integration
  • Documentation update

New in ETL-Tools QlikView Connector 2.0.2.4 (May 21, 2012)

  • Uses 10 times less memory for large excel files
  • 10 times faster working with large excel files
  • Documentation update