Fast, powerful, flexible, feature rich ETL tools. Complete business and data transformation automation.

Text, XML, Excel, Access, DBF, Foxpro, ODBC, OLE DB, MS Sql Server, Oracle, MySql, PostgreSQL, Firebird, Interbase, SQLite, POP3, SMTP, File System, FTP, SSL, Unicode.

Built-in scheduler, business rules designer, package designer, report designer, data browser. Powerful data transformation language, regular expressions and more...

Home

Frontpage

Working with QVX files

Those people who work with QlikView know that it requires direct connection to the database to pull the data from, which is not possible to implement in some situations. One of the solutions is to use QVD files but again there is no way to create them without using QlikView.

In version 10 QlikView has introduced support for QVX files.

QVX (QlikView data eXchange) is a new file/stream format for high performance data input into QlikView. A QVX formatted file contains metadata describing a table of data and the actual data. In contrast to the QVD format, which is proprietary and optimized for minimum transformations inside QlikView, the QVX format is public and requires a few transformations when exporting data from traditional data base formats.

Adavanced ETL processor and Visual Importer ETL allow the user to export entire data warehouse into QVX files just with in few click and no programming


Create QVX form any datasource

Data can be generated from virtually any data source.

Note

All data is exported as UTF8 text using row delimiter

Here is the link to file format specification.

http://community.qlikview.com/servlet/JiveServlet/previewBody/2677-102-1-2852/QlikView%20QVX%20File%20Format.pdf

Online tutorial.

How to save entire datawarehouse into QVX files with just s few cliks

 

New Year with New Business intelligence software

Today we are proud to announce that after several months of hard work and intensive testing new versions of Visual Importer ETL, Advanced ETL Processor, Active Table Editor and Database Browser  are finally live. They bring to the users enormous number of useful changes, usage improvements and bug fixes.

AETL - Package Designer

  • Parallel Processing
  • Highly optimised code
  • Execution agent is now only 5 mb (compare this to some java etl tools)
  • Schedule for execution Packages, Transformations and SQL scripts
  • Application Notes
  • Notes for Directories and Connections.
  • Connection testing for FTP,SMTP and POP3
  • Mutiple SMTP, POP3, and FTP connections
  • CRC16,CRC24,CRC32,Adler32,CRC64,eDonkey,eMule,MD4,
    MD5,RIPEMD160,SHA1,SHA224,SHA256,SHA384,SHA512,
    Whirlpool checksums
  • Package Debugging
  • Multiple SQL editors
  • New repository structure compatible with Database browser,
    Advanced ETL Processor and Active Table Editor
  • Design and Generate Reports
  • Easy agent management
  • Run Packages, Transformations, Import scripts and SQL scripts
    from the command line
  • 300 data transformation and validation functions
  • Edit lookup data
  • Simplified Repository management
  • Execution log has Execution time percentage
  • Schedule package execution directly from the package designer
  • Same for sql scripts and data transformations
  • Schedule for execution on specific computer
  • Schedule for execution using agent only as option
  • Easy agent management
  • Simplified Repository management
  • Agent status logging and current agent tasks grid
  • Documentation update
  • Support for themes
  • After and Before transformation functions

Have an Idea? Let us know and we will implement it for you.
Do not know how to transfom the data, let us know and we will help you.

Visual Importer ETL - Report Designer

Please use our support forum to provide us with feedback, we are are always happy to assist anyone having problems

 

Visual Importer ETL version 8 is ready for testing

After several months of hard work  Visual Importer ETL version 8 is finally available for download. It introduces enormous amount of useful changes, improvements and bug fixes:

Dowload Professional or Enterprise version
  • Package Debugging
  • Parallel execution
  • Highly optimised code
  • Application Notes
  • Various bugs fixes and improvements

Upgrading Reposistory

Support will provide assistance to existing customers who pay for support and maintenance.

Reporting problems

Please use our support forum to provide us with feedback. we are currently looking for beta testers and will be happy to assist anyone having problems

New version of Visual Importer ETL

 

Annoncing Active Table Editor - Version 5

After months of hard work  Active Table Editor version 5 is available for download. It introduces enormous amount of useful changes, improvements and bug fixes:
  • Linked Reports
  • Ability to print individual records
  • Various bugs fixes and improvements

Upgrading Reposistory

Support will provide assistance to existing customers who pay for support and maintenance.

Reporting problems

Please use our support forum to provide us with feedback. we are currently looking for beta testers and will be happy to assist anyone having problems

New version of Active Table Editor

 

More Articles...

  •  Start 
  •  Prev 
  •  1 
  •  2 
  •  3 
  •  4 
  •  5 
  •  6 
  •  7 
  •  Next 
  •  End 

Page 1 of 7

Products

Testimonials

"I've been very impressed with Advanced ETL Processor. It is extremely powerful and can validate and transform practically any data set you work with."

David Gig,
Director of Information Technology

Our customers

BP

BBC

HSBC

Databases we work with

Go to top