Data Mining the vCenter Database with QlikView

Several months ago one of my students (Jan-Peter Klijn) showed me a real nifty application called QlikView, it’s a program that makes it possible to retrieve and assimilate data from different sources. Once loaded into the program, the data is presented in a way that is easy to understand and work with. To make selections in QlikView, you don’t need any previous knowledge of databases or search routines: you simply click on the item of which you want to know more. The clicked item turns green, and the program immediately presents all the items associated with the selected one. Graphics and tables can be created to get an even better overview of data. Any graphic or table can be printed or exported to other programs.

I’ve managed to connect QlikView with the vCenter database and within minutes, I was able to create some great “Real Time” reports. I’ve created a Jing movie which demos the configuration and report creation. QlikView is free for personal use, you can get it here.

Trackbacks

Trackback specific URI for this entry

Social comments and analytics for this post
This post was mentioned on Twitter by PlanetV12n: Data Mining the vCenter Database with QlikView (NTPRO.NL) http://bit.ly/9Xms7O

Weblog: uberVU - social comments
Tracked: Mar 21, 21:16

Comments

Display comments as (Linear | Threaded)

Very interesting and powerfull tool! Do you have an excample qvw you could provide?

#1 Alex on 2010-03-21 20:12 (Reply)

The movie shows how to build an example, in the free version I don’t think running the QWV file on another system is supported.

#1.1 Eric Sloof on 2010-03-21 20:16 (Reply)

Hi, loading a .qvw from another instance of Qlikview is indeed not supported on a personal version. A registered Qlikview can read qvw files from any other qlikview, but the personal version does only reads files that are saved in that particular version, installed on that computer. If you created a very nifty script however, you are of course able to copy it to a text file and paste it in another qlikview Instance. To see the real power of qlikview try feeding it with another large datasets (for example event or performance data for machines in the first database). If there are corresponding field names (which are case-sensitive) in the tables, those will be automatically associated

#1.1.1 Jan-Peter Klijn (Homepage) on 2010-03-22 09:19 (Reply)

Thanks for that presentation of that tool. Makes some presentations easier for me (and managing too )

#2 Patrick (Homepage) on 2010-03-22 07:21 (Reply)

I'm expert user This tool is revolucionary as excel 2.0 but NO limit, have 2 architecture client & server, oriented to users (pure click, programation 0, low cost in implementation in value y timing) ... I'am not supplier ¡¡ test for believe for valid the true With client is possible share .qvw (template + data) for small & medium enterprise, server is oriented to internet (vía web page), TIC (mobile) Additional service is the automation (ETL: extract of data of any source , vía .bat), configuration of alarm & scenarios for control & shortcut corresponding I am working in distribution to users of sms, xls, html, xml, data converted in images to email & mobile Also exist template for clear BB (black box) of data in Sql server, Oracle, AS400 The level as requisite for maintenence is low only editing .txt Is revolucionary because the programation oriented to low cost, then the hi projects of implementation by BI not will exist on time

#3 llauses (Homepage) on 2010-03-22 10:15 (Reply)

Name
Email
Homepage
In reply to
Comment: Standard emoticons like :-) and ;-) are converted to images.
E-Mail addresses will not be displayed and will only be used for E-Mail notifications.

To prevent automated Bots from commentspamming, please enter the string you see in the image below in the appropriate input box. Your comment will only be submitted if the strings match. Please ensure that your browser supports and accepts cookies, or your comment cannot be verified correctly.

Enter the string from the spam-prevention image above:
: Remember Information? Subscribe to this entry
Submitted comments will be subject to moderation before being displayed.

Eric Sloof - NTPRO.NL

Sunday, 21 March 2010

Data Mining the vCenter Database with QlikView

Recent Entries

Archive