topic Re: How to access any datasource with generic User in Qlikview in QlikView

How to access any datasource with generic User in Qlikview

Thu, 14 Jul 2016 20:51:46 GMT

Hi,

Generic user is created in my organization and the same will be assigned to data sources(like Oracle 12 c) so that no password is required to access any data source with this user, how can I access the data source from Qlikview with out using any credentials since it's a generic user and credential were not required.

If any one face the same experience then please guide me on this.

Appreciate your response.

Thanks,

Mahesh

Re: How to access any datasource with generic User in Qlikview

Peter_Cammaert — Thu, 14 Jul 2016 20:58:45 GMT

For all data sources that require identification, you can either supply the name of the generic user, or if you can use SSO, you need to log in as the generic user and access will be granted automatically.

For any other data sources that do not require you to log in (like files, web sources or any other source without authentication) you don't need to do anything.

But actually, you're asking for QlikView to silently fix authentication issues with every data source possible. Quite a challenge...

Peter

Re: How to access any datasource with generic User in Qlikview

rwunderlich — Thu, 14 Jul 2016 20:59:44 GMT

QV Connnections don't require a password per se. QV can connect to any datasource -- OLEDB or ODBC -- using the parameters expected by that connection.

I take it these are ODBC data sources? If so, just make the QV connection to the ODBC datasource. The ODBC dsn will need to be defined on the machine where QV is running.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com