How to perform ETL with QlikSense?

[#1]

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

[Gysbert_Wassenaar · Accepted solution]

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.

[#3]

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]

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