Connect to a view on Qlik Sense

[#1]

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!

[#2]

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

Try for this.

Regards.

[#3]

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

[brian_booden · Accepted solution]

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:

Regards,

Brian

[#5]

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.

[#6]

Nice it appeared.

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

Regards.

[fernando_tonial]

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.