QlikView documentation and resources.
This Article demonstrates how to save all tables in the database as QVD files.
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.
Export Object Properties
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.
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
Thank you for the positive feedback
We did try to publish Q-Eye on the qlik market without any lack
We do not visit this page very often so please us our support forum is you have any questions
Why not use QlikView?
//STEP 3 - STRONGLY RECOMMEND A DEBUG LOAD WITH LIMIT ON ROWS
DBTABLELIST: SQLTABLES; //This reads the metadata from the database
TABLE_NAME as DBTABLE
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 [
for z = 1 to FieldValueCount('DBTABLE')
let z1 = FieldValue('DBTABLE',z);
select * from $(zQuoteO)$(z1)$(zQuoteC);
store "$(z1)" into "QVD\$(z1).qvd" (QVD);
drop table "$(z1)";
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