Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
elduderino
Contributor II
Contributor II
‎2018-10-01 11:08 AM

Qlikview dashboard: Updating Excel data source(s) to Informatica

Hi,

I'm fairly new to Qlikview and am unable to find a clear answer to my question despite having searched the community far an wide.

Synopsis:

I created a prototype QlikView dashboard that utilizes six Excel files as data sources. These flat-files are essentially snapshots of data from other sources, and the QVD Builder utilizes joins between said files. The prototype has been approved, and I will now create/remake this dashboard to utilize an Informatica connection for up-to-date and continuously updated company data.

Questions:

Where do I start in order to switch the data source(s) from Excel files to the Informatica source that has been specifically created for this project? Is it as simple as replacing the Excel relative pathnames with the Informatica pathnames within the QVD Builder?

Thanks in advance!

409 Views
0 Likes
1 Reply
vamsee
Specialist
Specialist
‎2018-10-01 01:58 PM

Yes to switch replace your excel loads with the Informatica extract loads. But it won't be just changing path names, I assume you would be needing a connector to fetch data into Qlikview.

Please have a look at the following

https://marketplace.informatica.com/solutions/qlikview_connector_for_informatica_powercenter

How to Integrate Informatica with Qlikview

336 Views