Qlik Community

QlikView Documents

Documents for QlikView related information.

How to save all tables in the database as Qvd files.

etl_tools
Contributor

How to save all tables in the database as Qvd files.

This Article demonstrates how to save all tables in the database as QVD files.

  1. Download and install Advanced ETL Processor Ent
  2. Create new directory to store QVD files
  3. Create database connection to pull data from
  4. Create new package
  5. Add “File operation” to the package and configure it
  6. Add Export to the package and configure it
  7. Execute package
  8. Job is one


Notes

Data is exported into specific directory first so it is important to clean it for so we use file operation for it.

Export object  uses mask to find the tables and when new table is added it will be exported automatically.

Screenshots

Package

Exported QVD's

File Operation

Export Object Properties

More information about Advanced ETL Processor

Advanced ETL Processor Enterprise is data integration automation Tool

By combining simple Package actions together Advanced ETL Processor Enterprise helps businesses and Fortune 100 companies build complex data-warehouses and automate complicated business processes with ease.

Comments
jaimeaguilar
Valued Contributor II

I've tested this tool as well as Qeye, some months ago. I think that this ETL Tool is great for making the ETL process in QlikView more graphical so it can be clearer for users that are not so technical. It has many transformation functions, some of them not present natively in QlikView. So overall, my thoughts about this tool is that it can be a great companion to QlikView in such cases where you need complex transformations or when the QlikView project is "entrerprise size". I even remember seeing an option that allow to writeback data from QV to DB

etl_tools
Contributor

jaimeaguilar

Thank you for the positive feedback

We did try to publish Q-Eye on the qlik market without any lack

PS

We do not visit this page very often so please us our support forum is you have any questions

ETL-Forum ::

mr_barriesmith
Contributor

Why not use QlikView?

//STEP 3 - STRONGLY RECOMMEND A DEBUG LOAD WITH LIMIT ON ROWS

DBTABLELIST: SQLTABLES;  //This reads the metadata from the database

DBTABLES:

load

  TABLE_NAME as DBTABLE

resident DBTABLELIST

  where TABLE_TYPE = 'TABLE';

drop table DBTABLELIST;

//STEP 4 - IF SQLTABLES DOES NOT WORK, POPULATE THE INLINE BELOW

//         OR IF YOU WANT TO FOCUS ON A SET OF TABLES, LIST THEM HERE AND COMMENT OUT SQLTABLES

load * inline [

  DBTABLE

];

for z = 1 to FieldValueCount('DBTABLE')

  let z1 = FieldValue('DBTABLE',z);

  "$(z1)":

  select * from $(zQuoteO)$(z1)$(zQuoteC);

  store "$(z1)" into "QVD\$(z1).qvd" (QVD);

  drop table "$(z1)";

next z;

jaaldurgam
Valued Contributor

Might be more of graphical UI is not available through QV. ETL processor looking nice Btw is it for free or there is any cost involved

Sreeni

Version history
Revision #:
1 of 1
Last update:
‎08-14-2014 05:33 AM
Updated by: