Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Connecting Qlikview to OBIEE RPD!

Hi,

I was trying to connect QlikView to OBIEE RPD and build a report. I am able to connect to OBIEE RPD by creating a DSN and pull the data.

Now the next objective which I want to achieve is to import the complete data model into QlikiVew from OBIEE RPD (where the data model is already built).

The idea is to use the data model build in OBIEE and build reports i.e only the visualization into QlikView.

Is it possible to import the data model into Qlikview instead of loading all the tables in Qlikview again and forming the joins?

If YES how? and if NO why?

And if we import the data model from OBIEE RPD, by default the key fields will not be visible in presentation layer.

And if we need to for the joins in QlikView (presentation layer in this case), key fields must be present. How do I achieve these things?

Hope I am clear on my part.

Thanks in advance!

Regards,

Laxmi

Tags (1)
1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Re: Connecting Qlikview to OBIEE RPD!

The associations between tables in the Qlikview data model are created in the script that loads the data into the Qlikview in-memory database and they are used in the presentation layer. The table associations are fundamental to how Qlikview works.


talk is cheap, supply exceeds demand

View solution in original post

8 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: Connecting Qlikview to OBIEE RPD!

Is it possible to import the data model into Qlikview instead of loading all the tables in Qlikview again and forming the joins?

If YES how? and if NO why?

No, because Qlikview associates tables based on the field names that the tables have in common. It cannot use the primary and foreign keys of the tables from the source database.


talk is cheap, supply exceeds demand
Highlighted
Creator II
Creator II

Re: Connecting Qlikview to OBIEE RPD!

Hi Gysbert,

Thanks for you reply. I had few questions.

Does those associations has to happen in presentation layer? Can't we use any existing Association directly into Qlikview Presentation Layer?

Is there any way I can connect to existing association(Data Model)?

Thanks for your time!

Regards,

Laxmi

Highlighted
MVP & Luminary
MVP & Luminary

Re: Connecting Qlikview to OBIEE RPD!

The associations between tables in the Qlikview data model are created in the script that loads the data into the Qlikview in-memory database and they are used in the presentation layer. The table associations are fundamental to how Qlikview works.


talk is cheap, supply exceeds demand

View solution in original post

Highlighted
Creator II
Creator II

Re: Connecting Qlikview to OBIEE RPD!

Thanks for the reply.

It helps!

Regards,

Laxmi

Highlighted
Specialist III
Specialist III

Re: Connecting Qlikview to OBIEE RPD!

Hi Laxmi,

Were you able to load data from OBIEE ? Could you let us know what have done after your first step.

Apologies for raising a question in a closed thread.

Highlighted
Creator II
Creator II

Re: Connecting Qlikview to OBIEE RPD!

Hi Kiran,

We were not able to fetch OBIEE data model into Qlikview, the reason being Qlikview creates its own data model as Gysbert Wassenaar explained in this thread.


You have create the data model(from OBIEE) again in Qlikview using LOAD SCRIPT.


Hope this helps.


Regards,

Laxmi 

Highlighted
Specialist III
Specialist III

Re: Connecting Qlikview to OBIEE RPD!

Thanks laxmi for your come back and answering

Highlighted
Contributor
Contributor

Re: Connecting Qlikview to OBIEE RPD!

Hello everyone,

With BI Connector, you can connect Qlik to OBIEE Subject Areas and Reports data (with joins and aggregations).

Thanks!