ETL-Tools QlikView Connector
ETL-Tools QlikView Connector is an ideal tool for customers who are working with complex and bad quality data. Cleaning and conforming the data can be tedious task. ETL-Tools QlikView Connector gives the users ability to transform and validate the data while loading it QlikView. It has more than 500 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, JDBC, SalesForce, RSS, Google Spreadsheet, IMAP4, POP3 + SSL, File System, XML, BDE and even QVX files.
ETL-Tools QlikView Connector can transform and validate Strings, Numbers, Dates, Postcodes, phone numbers, Driving licences and much more. All this can be achieved without writing a single line of code.
ETL-Tools QlikView Connector can be run as stand-alone QlikView application, so user can design data transformations and validations and even create QVX files,
or it can be run from the QlikView itself when loading the data
The connector is developed for QlikView 10, but also works perfectly with later versions of QlikView.
ETL-Tools QlikView Connector is based on Advanced ETL Processor data transformation engine. The users who are already familiar with Advanced ETL Processor will find it easy to use
Automatic script generation
Once data transformation is designed ETL-Tools QlikView Connector allows the user to create the QlikView load script and it is done with just one mouse click!
The data integration process can often seem overwhelming, because of the vast number of large-scale, complex, and costly enterprise integration applications available on the market. QlikView Connector gives our customers data integration capabilities built into a straightforward graphical user interface. At any stage user can press the "Magic Button" and see the result of transformation without actually loading the data.
Chained transformations enable you to create complex mappings in which the output of one mapping becomes the input of another. Some complex transformation are very hard to understand, this powerful feature allows you to design and debug complex transformations one small step at the time. Each chained component becomes a modular entity in an interdependent transformation sequence, allowing for conversions to be made on-the-fly.
Complex Data Transformation Example
QlikView can pull the data from almost anything but what if your data looks like this?
Or your main data source is Oracle table but you need to validate it against Excel file? ETL-Tools QlikView Connector is a perfect tool for such a complex data
There are several several QlikView connectors available to the users. All they do is bring the data into QlikView but they do not do anything with the data
ETL-Tools QlikView Connector is the only one who can transform and validate the data while loading it into QlikView
QlikView Connector ScreenshotsClick on thumbnail to see the screenshot
QlikView Connector requires QlikView version 10 and above