topic qlikview with powercenter (informatica) in QlikView

qlikview with powercenter (informatica)

Mon, 12 Dec 2011 20:13:53 GMT

hi together,

can anybody explain me why we have to use powercenter with qlikview.

What are the advantages of using both tools ? or What PowerCenter provides an added value for use with QlikView ?

Thank you very much.

Best Regards,

qlikview vs. powercenter (informatica)

rajeshvaswani77 — Tue, 13 Dec 2011 01:22:17 GMT

Qlikview is for reporting your data in the form of dashboards. Informatica is for extract, transform and load of data.

qlikview vs. powercenter (informatica)

Tue, 13 Dec 2011 09:16:24 GMT

but qlikview can it handle too, or not ? It can load, transform, extract various data from various sources.

I get really confused

How would the cooperation of both tools like ?

Thank you very much for any advice.

regards,

qlikview vs. powercenter (informatica)

matt_crowther — Tue, 13 Dec 2011 09:41:12 GMT

I'm currently in the process of assisting with the integrating of Informatica with Qlikview using the new Informatica connector to generate QVX files.

The massive benefit of using Informatica is that it gives you confidence in the data. Within a large organisation there are likely to be multiple datasources (straight db's and warehouses) that are used by more than one reporting tool - Qlikview, BO, Cognos etc and by using Informatica we can have a single extract and transformation layer instead of several versions all with their own differences.

That doesn't sound a big deal (and in a small deployment it wouldn't be) but think of all the ET(L) to be maintained across say a bank or insurance company; it's so much more reliable to use a single extract process that results in one set of code to maintain. In addition Informatica provides great data lineage, meaning your MI is fully auditable ie: you know exactly where field 'X' in a Qlikview dashboard has come from and how it's been transformed.

It also allows Qlikview (through the QVX files) to benefit from ETL already generated in Informatica; there's no need to re-write existing complex transforms that in some cases would be totally impractical in QV script.

For me it goes to the heart of Qlikview's sales pitch 'one version of the truth' - with multiple ETL processes how can you possibly be sure that the picture you present in Qlikview is the same as the one being presented in BO; you can't - plus when it comes to audit (SOX etc) you can quickly and easily prove that the MI you're presenting is correct and reliable.

Due to the cost of Informatica I can only ever see it of being of use for larger organisations and those with a stringent audit requirement.

So far it looks as though the Connector is a great tool; v1.01 has vastly improved the speed to make it a viable solution.

Hope that clears things up.

All the best,

Matt - Visual Analytics Ltd

qlikview vs. powercenter (informatica)

Tue, 13 Dec 2011 19:29:58 GMT

Hi Matt,

thanks for the detailed explanation.

Do I need to use PowerCenter to a physical destination database. I wonder, therefore, purely because we load the data from existing systems in QlikView and evaluated immediately thereafter.

can i imagine it so that the PowerCenter organized the data collection and qlikview does only visualized it ?

And for the combination of both tools did I need a target database ?

Thank you very much

regards,

Re: qlikview with powercenter (informatica)

matt_crowther — Wed, 14 Dec 2011 15:05:23 GMT

I have to confess; I'm no Informatica Expert but as I understand it the process works best as follows:

Multiple Datasources - - - > Load, Merge & Transform in Informatica - - - > Use Informatica to create QVX files (and other file types for BO etc based on the SAME transforms)- - - > Load QVX files into 1 or more QV Dashboards with minimal (if any) transformation.

So in it's purest form you are as you suggest using Informatica to create the 'data' and Qlikview to simply visualize and present it to users...a very happy marriage!

As far as I know there is no need whatsoever for a target database.

All the best,

Matt - Visual Analytics Ltd

Re: qlikview with powercenter (informatica)

Anonymous — Tue, 31 Jul 2012 20:41:05 GMT

Hi Matt:

We are looking into converting to PowerCenter to generate QVX files rather than have Qlikview generate QVDs. I have been testing for a couple of weeks now and I am noticing that the QVX files are much larger than the QVDs with both containing the same data set. Is this what you guys noticed also or am I doing something wrong? I have experimented with the data types in the QVX and have achieved minimal gains. Any suggestions on your part would be appreciated. Thanks

Matt Weyenberg

Re: qlikview vs. powercenter (informatica)

EIM — Thu, 12 Sep 2019 17:59:02 GMT

Hello,

Where did you manage to get the connector? I have looked over qlik and informatica knowledge bases and cannot find a download location.

Thanks,