Advanced ETL Processor can now generate QVD files from the following data sources: Text, XML, Excel, Access, DBF, Foxpro, ODBC, OLE DB, MS SQL Server, Oracle, MySql, PostgreSQL, Firebird, Interbase, SQLite, POP3, RSS, Windows Event Log, Google Spreadsheets, SalesForce, BrightPearl and QlikView QVX files.


Advanced ETL Processor currently supports 20 data targets and 27 data sources


About QVD Files

A QVD (QlikView Data) file is a file containing a table of data exported from QlikView. QVD is a native QlikView format and can only be written to and read by QlikView. (NOT ANY MORE) The file format is optimized for speed when reading data from a QlikView script but it is still very compact. Reading data from a QVD file is typically 10-100 times faster than reading from other data sources.

QVD files can be read in two modes, standard (fast) and super-fast. The selected mode is determined automatically by the QlikView script engine. The super-fast mode can be utilized only when all fields or a subset thereof are read without any transformations (formulas acting upon the fields), though the renaming of fields is allowed.

Note:

We did a lot of testing but there is a chance that we missed something, so if you find any problems please post your comments on our support forum and we will do our best to help you.

Date/Time format strings control the conversion of strings into date time type.

Date Time Format Strings are composed from specifies that describe values to be converted into the date time value.

In the following table, specifies are given in lower case. Case is ignored in formats, except for the "am/pm" and "a/p" specifies.

Specifier          Description

d                      Day as a number without a leading zero (1-31).

dd                    Day as a number with a leading zero (01-31).

m                     Month as a number without a leading zero (1-12).

mm                  Month as a number with a leading zero (01-12).

mmm              Month as an abbreviation (Jan-Dec).

mmmm           Month as a full name (January-December).

yy                    Year as a two-digit number (00-99).

yyyy                Year as a four-digit number (0000-9999).

h                      Hour without a leading zero (0-23).

hh                    Hour with a leading zero (00-23).

n                      Minute without a leading zero (0-59).

nn                    Minute with a leading zero (00-59).

s                       Second without a leading zero (0-59).

ss                     Second with a leading zero (00-59).

zzz                   Fraction of Second with a leading zero (000-999).
                        (Works only for oracle time stamp fileds)

tt                      Uses the 12-hour clock for the preceding h or hh specifier,  'am' for any hour before noon, and 'pm' for any hour after noon.

We have 368 guests and no members online