Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Connect to a view on Qlik Sense

Hi everyone,

Is possible to connect to views existing on a database with Qlik Sense? I am trying to access a view created on a Oracle database but with no sucess (the view does not appear in the Qlik Sense and there is not "View" option as we have on QlikView).

Thanks!

1 Solution

Accepted Solutions
brian_booden
Luminary Alumni
Luminary Alumni

Hi Pollyanna,

Did you ensure that you have selected the correct Owner of the view in Qlik Sense as highlighted below?  The default owner might not contain the View you are looking for:

QlikSenseOwner.png

Regards,

Brian

View solution in original post

6 Replies
Not applicable
Author

I believe is possible Pollyanna. Exist the connector OLE DB, equals on QlikView Desktop.

Try for this.

Regards.

Not applicable
Author

Im trying to connect by ODBC. This is not possible in this connector?

brian_booden
Luminary Alumni
Luminary Alumni

Hi Pollyanna,

Did you ensure that you have selected the correct Owner of the view in Qlik Sense as highlighted below?  The default owner might not contain the View you are looking for:

QlikSenseOwner.png

Regards,

Brian

View solution in original post

Not applicable
Author

Thank you for the help guys! I don't know what happened since yesterday I was not able to find the created view and now it suddenly appeared in Qlik Sense.

Not applicable
Author

Nice it appeared.


In my clients have been using OLE DB connector for Oracle database.


Regards.

fernando_tonial
Partner
Partner

Hi Pollyanna,

I recommend using the Qlik ODBC Connector.

See the documentation.

This connector works both (QlikView and Qlik Sense).

Don't worry, be Qlik.

Tonial.