Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
innashna
Contributor II
Contributor II

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

Labels (2)
1 Reply
dilipranjith
Partner
Partner

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...