Skip navigation

Log In

Forgot your password?
Don’t have an account? Sign Up

Sign Up

Access our rich network of apps, trials, and services.

Start the registration process by entering your email address below.

Already have an account? Log In

QlikView Connector for Informatica PowerCenter

Free download

Posted by: Qlik Technologies

QlikView Connector for Informatica PowerCenter provides out-of-the-box integration with Informatica data mappings.

Overview

HOW THE CONNECTOR WORKS:

 

The QlikView Informatica PowerCenter connector is designed to create native QlikView Data Exchange (QVX) targets within Informatica PowerCenter installations. (A QVX file is a file format similar to an XML file that is optimized for rapid loading of data into QlikView). With the capabilities provided by the adapter, it can create QVX files from different data sources supported by Informatica, which in turn can be read by QlikView to load data.

 

The PowerCenter designer - once all the desired fields are added to the target fields - can click on “Create”. This will create the QlikView QVX file.

 

Part of the PowerCenter ETL process can involve consolidation of multiple data sources as part of a mapping process. The QlikView plug-in is now tightly integrated into this process.

 

Common fields can be used to create a joiner transformation which is sent forward to the QlikView QVX writer.

 

Once a mapping is created, PowerCenter uses a session associated with the mapping in the Informatica’s workflow manager tool.

 

PowerCenter runs the workflow and a QVX file gets generated at the specified location with the specified name. This QVX file is then imported into QlikView software. After importing, the user will see the data in QlikView.

 

Take a tour of QlikView:

http://www.qlikview.com/us/explore/experience/product-tour?ga-link=promo

 

Experience QlikView here:

http://demo.qlikview.com/?ga-link=promo

Key Features

Benefits of QlikView and Informatica: :

QlikView

delivers power and simplicity without the cost or complexity of traditional BI tools, enabling Business Discovery across an organization.

Unlock the value of your data warehouse

Informatica PowerCenter extracts data from multiple sources into a data warehouse. As part of the ETL process the QlikView Connector allows data to be exported in an optimised format (QVX - QlikView data exchange format).

Speed of deployment

Deploy individual analyses and reporting solutions in weeks or days using the QlikView script builder. Expedite and simplify the process of analyzing relevant data from Informatica.

Flexible yet secure:

QlikView is easy for business people to use and IT pros to manage. QlikView provides the flexibility at the edges critical to business discovery while ensuring discipline at the core of every deployment.

Specifications

System Requirements:

  • PowerCenter 8.6.1, 9.0.1 and 9.1

Seller


QlikTech was founded on the belief that business intelligence (BI) should be about business users. Traditional BI solutions have become bloated, complex software stacks, leaving users confused and frustrated. For 18 years, QlikTech has focused on simplifying decision making for business users across organizations. We pioneered new approaches to accessing, managing, and interacting with data. Our QlikView Business Discovery platform is recognized as a groundbreaking solution. Combined with a relentless focus on customer success and a vibrant, passionate user community, it’s no wonder more than 19,000 companies in over 100 countries use QlikView, with an industry-leading 96% satisfaction rate.


The QlikView Business Discovery platform bridges the gap between traditional BI solutions and standalone office productivity applications, enabling users to forge new paths and make new discoveries. QlikView works with what you already have and infuses a broad set of new capabilities into BI. It brings a whole new level of analysis, insight, and value to existing data stores with user interfaces that are clean, simple, and straightforward.

Headquarters
Qlik Technologies, Inc.,
150 N. Radnor Chester Road,
Suite E220
Radnor, PA 19087
Phone:+1 (888) 828-9768
www.qlikview.com

Resources

Comments Comments (39)

Related