Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to perform ETL with QlikSense?

Hello,

I wanted to know how we can perform the ETL process with Qlik Sense and how can we compare it with the SSIS of MS SQL server?

Thanks in advance for the help.

Regards

Vimal

1 Solution

Accepted Solutions
Gysbert_Wassenaar

In Qlik Sense you add instructions to load and manipulate date using the Data Manager and the Data Load Editor. It can be compared to SSIS with regards that technically both perform Extract, Transform and Load actions. But SSIS is a purpose built ETL Tool. Qlik Sense is a Data Discovery tool with some built-in ETL functionality.


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Gysbert_Wassenaar

In Qlik Sense you add instructions to load and manipulate date using the Data Manager and the Data Load Editor. It can be compared to SSIS with regards that technically both perform Extract, Transform and Load actions. But SSIS is a purpose built ETL Tool. Qlik Sense is a Data Discovery tool with some built-in ETL functionality.


talk is cheap, supply exceeds demand
Not applicable
Author

Qlikview/Qliksense is infinitely more "intelligent" vs SSIS.

SSIS is a "brute force" specialized ETL tool, that will not "tolerate" any change in the source metadata.

In Qlik you could select/filter/identify subsets driven by business driven conditions. It is true that the underlying data is stored in a proprietary Qlik format. However, any table/chart could be exported into excel in matter of seconds (in Qlikview even better/simpler that from Qliksense). For complicated data models, for prototype stage, Qlik is infinitely more flexible (than SSIS).

Summary: Qlik is not a specialised ETL tool, however, it can be successfully used as for ETL.

thank you,

Alexei Akimov

DataWrangler
Former Employee
Former Employee

Hi Vimal,

I recently posted two items of potential relevance to your question; I hope you find them useful:

  1. Seek and Ye Shall Find: Introducing the Structured ETL Engine for Qlik
  2. Thrones, Castles, and Catapults: The Value of Rule-Based ETL Engines in BI Projects

Cheers,

Jeff R. Robbins