3 Replies Latest reply: Apr 10, 2012 4:35 AM by Mike Rewnick RSS

    Running complex ETL transformations while loading data into QlikView

    Mike Rewnick

      QlikView can pull the data from almost anything but what if your data looks like this?

       

      Complex Data.png

       

      Or you main data source is Oracle table but you need to validate it against Excel file

       

      Very soon you will be able to perform powerful data transformation while loading the data into QlikView using Advanced ETL Processor QlikView connector.

       

      Advanced ETL Processor QlikView connector .png

      Advanced ETL Processor has more than 300 data validation and transformation functions such as sorting grouping deduplications regular expressions and much more.

       

      Process as follows:

       

      Design data transformation using Advanced ETL Processor

      Make sure that you have only one data writer and the connection type is QVX file

       

      Than within QlikView write a script:

       

      CUSTOM CONNECT TO "Provider=AETLP_QlikView_Connector.exe;XUserId=FXPZaHB;XPassword=POLVJLA;";

       

      Customers:

      LOAD *;

      SQL SELECT *

      FROM C:\1_presentation\templates\customers.ats;

       

      Film:

      LOAD *;

      SQL SELECT *

      FROM C:\1_presentation\templates\film.ats;

       

      Inventory:

      LOAD *;

      SQL SELECT *

      FROM C:\1_presentation\templates\inventory.ats;

       

      Rental:

      LOAD *;

      SQL SELECT *

      FROM C:\1_presentation\templates\rental.ats;

       

      Note

       

      Advanced ETL Processor QlikView connector is currently going through internal testing process and will be available in the next week. Please contract us if you wish to help us with testing.

       

       

      http://www.etl-tools.com/contact-db-software-laboratory.html