topic Re: Data source, ETL and map application on QlikView in QlikView

Data source, ETL and map application on QlikView

Thu, 07 Nov 2013 15:32:27 GMT

Hi all,

I have tried to use QlikView Desktop for a few days and had some questions to ask.

1. QlikView supports excel files and database as data source. It does not affect the original source, so where and how QlikView to store the data source?

2. Is Expressor use to develop ETL?

3. I have read some Demo Apps at QlikView Official Website. I found that QlikView can present data on map. How to do that?

Thanks a lot.

Regards,

Re: Data source, ETL and map application on QlikView

Clever_Anjos — Thu, 07 Nov 2013 15:37:39 GMT

1. QlikView supports excel files and database as data source. It does not affect the original source, so where and how QlikView to store the data source?

Basically QlikView is a 'in-memory' platform. It loads your data to memory. There are some files (QVD´s) that QlikView can use to store that data if needed

2. Is Expressor use to develop ETL?

Yes, but it´s not totally necessary. You can write your ETL scripts using QlikView Developer

3. I have read some Demo Apps at QlikView Official Website. I found that QlikView can present data on map. How to do that?

Youtube has a lot of videos about including maps into your Qlikview Application

Re: Data source, ETL and map application on QlikView

Anonymous — Thu, 07 Nov 2013 16:59:31 GMT

1. QlikView stores the data which it loads inside the QV application file itself. You can notice that the more data, the large the app file.

2. QlikView script is ETL script. No external tools needed.

QlikView application includes:
- Script. It is executed during the reload. Reads data from the sources, transforms if necessary, creates associations, build data model
- Data. This is what you get after running the script.
- Front end. Sheet objects like charts, filters, buttons, text boxes. In general, you need to load data before you can build front end.

All this is stored within one QVW file.

3. Search this forum for Google Maps. It is the most common, although you can use other maps, e.g. Bing. To build maps, you have to load geocodes (latitude/longitude) of your data points.

Regards,
Michael

Re: Data source, ETL and map application on QlikView

Fri, 08 Nov 2013 01:12:32 GMT

For expressor, what is/are the main functions of it? Does it provide more advanced ETL functions?

Re: Data source, ETL and map application on QlikView

Clever_Anjos — Fri, 08 Nov 2013 11:14:09 GMT

Yes, it provides a totally different approach.

To know about this product I recommend you to read the product documentation (which is very extense)

http://www.qlik.com/us/explore/products/expressor

I must remember you that QlikView itself (without Expressor) cand do a very very nice job

Re: Data source, ETL and map application on QlikView

Wed, 13 Nov 2013 02:02:19 GMT

I have watched some video about how Expressor works. It likes Informatica PowerCenter. Thus, I am a bit interested in it.

Thanks a lot.