Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

etl_tools
Contributor

Running complex ETL transformations while loading data into QlikView

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

Tags (2)
3 Replies
etl_tools
Contributor

Running complex ETL transformations while loading data into QlikView

ETL-Tools QlikView Connector is ready for the users

http://www.dbsoftlab.com/etl-tools/qlikview-connector/overview.html

There are several several QlikView connectors available to the users. All they do is bring the data into QlikView but they do not do anything with the data

ETL-Tools QlikView Connector is the only one who can transform and validate the data while loading it QlikView

ETL-Tools QlikView Connector.png

suniljain
Honored Contributor

Running complex ETL transformations while loading data into QlikView

is it possible to extract data from sap bw and sap r/3 with the help of this tool ?.

etl_tools
Contributor

Running complex ETL transformations while loading data into QlikView

not at the moment unless you have odc driver

Mike