Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
innashna
New Contributor

Can we automate Data Base connections in QlikView Model?

Hello,

I have QlikView Model, which is connected to  Oracle Data Base.

I got now second Data Base, and request to connect automatically only to one of the Data Bases according to the connection success. Means, that if one connection to Oracle fails, there will be trial for another connection.

How I can implement that in QlikView?

Thanks,

Inna

1 Reply
Partner
Partner

Re: Can we automate Data Base connections in QlikView Model?

Havent tried this myself but you should be able to set erromode to 0 (ignore failure) and then use ScriptError variable to identify the error and connect to alternative DB
https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ErrorVariables...

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ErrorVariables...