Running complex ETL transformations while loading data into QlikView

[etl_tools]

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

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 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

[etl_tools]

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

[suniljain]

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

[etl_tools]

not at the moment unless you have odc driver

Mike