Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
March 11, 2PM EST: Do More with Qlik - Getting Started wtih Qlik Sense SaaS - Redux. REGISTER NOW
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

View solution in original post

Not applicable

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

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