Transform and validate data while loading it into QlikView.
ETL-Tools-QlikView connector is the only one which can perform complex data transformations and validations while loading data into QlikVew. It has more than 300 functions and can load the data from Flat files, Excel, MS Access, DBF, FoxPro, ODBC, OLE DB, MS Sql Server, Oracle, MySql, PostgreSQL, Firebird, Interbase, POP3 + SSL, File System, XML and QVX files. All this can be achieved without writing a single line of code.
Added support for Clarion dat files
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
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
Operating systems:
Windows XP/2003/Vista/Server 2008/7/8/10
Additional requirements:
QlikView version 10+
Date:
17.08.2015
Related Software